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
"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
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