Обсуждение: Determining current block size?

I see that BLOCK_SIZE can be set at compile time, but is there a way
to determine what block size is in use in a running system? I've been
searching but have been unsuccessful so far.

Thanks!
John

In article <44dddf400712061323x5e721da7ped6075f6dc01f7c7@mail.gmail.com>,
John Wells <john.wells@greatworx.com> wrote:
% I see that BLOCK_SIZE can be set at compile time, but is there a way
% to determine what block size is in use in a running system? I've been
% searching but have been unsuccessful so far.

show block_size;

If you try to start the database with a postmaster compiled with the
wrong block size, the error message tells you what block size you need.

--

Patrick TJ McPhee
North York  Canada
ptjm@interlog.com