Determining current block size?

Started by John Wellsover 18 years ago3 messagesgeneral
Jump to latest
#1John Wells
jb@sourceillustrated.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

#2Bruce Momjian
bruce@momjian.us
In reply to: John Wells (#1)
Re: Determining current block size?

"John Wells" <jb@sourceillustrated.com> writes:

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.

postgres=# show block_size;
block_size
------------
8192
(1 row)

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's On-Demand Production Tuning

#3John Wells
jb@sourceillustrated.com
In reply to: Bruce Momjian (#2)
Re: Determining current block size?

On 12/6/07, Gregory Stark <stark@enterprisedb.com> wrote:

"John Wells" <jb@sourceillustrated.com> writes:

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.

postgres=# show block_size;
block_size
------------
8192
(1 row)

Well *that* was unexpected easy.

Thanks!
John