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

From ptjm@interlog.com (Patrick TJ McPhee)
Subject Re: Determining current block size?
Date
Msg-id 13ls5cmqojq1c99@corp.supernews.com
Whole thread Raw
In response to Determining current block size?  ("John Wells" <john.wells@greatworx.com>)
List pgsql-general
In article <44dddf400712061323x5e721da7ped6075f6dc01f7c7@mail.gmail.com>,
John Wells <john.wells@greatworx.com> wrote:
% 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.

show block_size;

If you try to start the database with a postmaster compiled with the
wrong block size, the error message tells you what block size you need.

--

Patrick TJ McPhee
North York  Canada
ptjm@interlog.com

pgsql-general by date:

Previous
From: "jzhang2004@sbcglobal.net"
Date:
Subject: VTD-XML Tutorial by Code Examples Posted Options
Next
From: "Charles.Hou"
Date:
Subject: about the performance of autovacuum and vacuumdb?