Обсуждение: 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