Determining current block size?

Started by John Wellsover 18 years ago2 messagesgeneral
Jump to latest
#1John Wells
john.wells@greatworx.com

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

#2Noname
ptjm@interlog.com
In reply to: John Wells (#1)
Re: Determining current block size?

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