Postgres Pro
Downloads
Home   >   mailing lists

Re: Determining current block size? - Mailing list pgsql-general

From Gregory Stark
Subject Re: Determining current block size?
Date
Msg-id 87r6hzpjpt.fsf@oxford.xeocode.com
Whole thread Raw
In response to Determining current block size?  ("John Wells" <jb@sourceillustrated.com>)
Responses Re: Determining current block size?
List pgsql-general
Tree view 
"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

pgsql-general by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Replication Monitoring
Next
From: "John Wells"
Date:
Subject: Re: Determining current block size?