Re: Determining current block size?

From: ptjm(at)interlog(dot)com (Patrick TJ McPhee)
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Determining current block size?
Date: 2007-12-11 04:44:06
Message-ID: 13ls5cmqojq1c99@corp.supernews.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In article <44dddf400712061323x5e721da7ped6075f6dc01f7c7(at)mail(dot)gmail(dot)com>,
John Wells <john(dot)wells(at)greatworx(dot)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(at)interlog(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Trevor Talbot 2007-12-11 04:50:00 Re: partitioned table query question
Previous Message Brett Neumeier 2007-12-11 04:43:11 question about warm standby databases in 8.2.5