Skip site navigation (1) Skip section navigation (2)

Re: Configuring BLCKSZ and XLOGSEGSZ (in 8.3)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Configuring BLCKSZ and XLOGSEGSZ (in 8.3)
Date: 2006-11-27 18:51:10
Message-ID: 21839.1164653470@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
"Simon Riggs" <simon(at)2ndquadrant(dot)com> writes:
> It seems possible to vary both BLCKSZ and XLOGSEGSZ rather than have
> them set within pg_config_manual.

The work required for this is much larger than you make it out to be,
and zero evidence has been offered for any benefit.  I have not heard of
anyone bothering to use a custom BLCKSZ since we added TOAST to get rid
of the row-length limitation ...

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2006-11-27 18:53:59
Subject: Re: Shared pg_xlog directory/partition and warm standby
Previous:From: Tom LaneDate: 2006-11-27 18:44:29
Subject: Re: PrivateRefCount (for 8.3)

pgsql-patches by date

Next:From: Peter EisentrautDate: 2006-11-27 21:08:10
Subject: Re: Configuring BLCKSZ and XLOGSEGSZ (in 8.3)
Previous:From: Simon RiggsDate: 2006-11-27 17:02:28
Subject: Re: Configuring BLCKSZ and XLOGSEGSZ (in 8.3)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group