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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-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

Browse pgsql-hackers by date

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

Browse pgsql-patches by date

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