Re: [PATCHES] configure option for XLOG_BLCKSZ

2008-05-05 Thread Alvaro Herrera
Andreas 'ads' Scherbaum wrote: > On Sat, 03 May 2008 13:14:35 -0400 Tom Lane wrote: > > > Simon Riggs <[EMAIL PROTECTED]> writes: > > > > > Not seen any gains from varying the WAL file size since then... > > > > I think the use-case for varying the WAL segment size is unrelated to > > performan

Re: [PATCHES] configure option for XLOG_BLCKSZ

2008-05-05 Thread Andreas 'ads' Scherbaum
On Mon, 5 May 2008 11:09:32 -0400 Alvaro Herrera wrote: > Andreas 'ads' Scherbaum wrote: > > On Sat, 03 May 2008 13:14:35 -0400 Tom Lane wrote: > > > > > Simon Riggs <[EMAIL PROTECTED]> writes: > > > > > > > Not seen any gains from varying the WAL file size since then... > > > > > > I think th

Re: [PATCHES] configure option for XLOG_BLCKSZ

2008-05-05 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: >> On Sat, 03 May 2008 13:14:35 -0400 Tom Lane wrote: >>> I think the use-case for varying the WAL segment size is unrelated to >>> performance of the master server, but would instead be concerned with >>> adjusting the granularity of WAL log shipping. >

Re: [PATCHES] configure option for XLOG_BLCKSZ

2008-05-05 Thread Simon Riggs
On Mon, 2008-05-05 at 13:06 -0400, Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> writes: > >> On Sat, 03 May 2008 13:14:35 -0400 Tom Lane wrote: > >>> I think the use-case for varying the WAL segment size is unrelated to > >>> performance of the master server, but would instead be concerned

Re: [PATCHES] win32mak_patch

2008-05-05 Thread Magnus Hagander
Magnus Hagander wrote: > Hiroshi Saito wrote: > >> Anyway. If you get references to it, you need to pull in > >> port/dirmod.c into psql as well. Normally, it would get this > >> through libpgport, but it looks like your custom makfile is > >> pulling the files in directly instead. So adding dirmod

Re: [PATCHES] create or replace language

2008-05-05 Thread Gregory Stark
"Tom Lane" <[EMAIL PROTECTED]> writes: > The equivalent problem for views and functions is handled by restricting > CREATE OR REPLACE to not change the output column set of a view or the > type signature of a function, independently of whether there are any > actual references to the object. So m

Re: [PATCHES] create or replace language

2008-05-05 Thread Tom Lane
Gregory Stark <[EMAIL PROTECTED]> writes: > "Tom Lane" <[EMAIL PROTECTED]> writes: >> ... So maybe the right thing is that >> CREATE OR REPLACE LANGUAGE can change "inessential" properties of an >> existing language, but not the core properties --- which might only be >> the handler function, thou