Thread: 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