Re: [PATCHES] Load distributed checkpoint V3

2007-03-25 Thread Greg Smith
On Mon, 26 Mar 2007, ITAGAKI Takahiro wrote: I'm assuming checkpoints are triggered by timeout in normal use -- and it's my recommended configuration whether the patch is installed or not. I'm curious what other people running fairly serious hardware do in this area for write-heavy loads, whe

Re: [PATCHES] Load distributed checkpoint V3

2007-03-25 Thread ITAGAKI Takahiro
Greg Smith <[EMAIL PROTECTED]> wrote: > > Here is the latest version of Load distributed checkpoint patch. > > Couple of questions for you: > > -Is it still possible to get the original behavior by adjusting your > tunables? It would be nice to do a before/after without having to > recompile

Re: [PATCHES] Improvement of procArray.xmin for VACUUM

2007-03-25 Thread Gregory Stark
"Tom Lane" <[EMAIL PROTECTED]> writes: > Gregory Stark <[EMAIL PROTECTED]> writes: >> Well I think this would be the same infrastructure we would need to do >> the other discussed improvement to address pg_dump's impact. That >> would require us to publish the youngest xmax of the live >> snapshot

Re: [PATCHES] Improvement of procArray.xmin for VACUUM

2007-03-25 Thread Tom Lane
Gregory Stark <[EMAIL PROTECTED]> writes: > Well I think this would be the same infrastructure we would need to do > the other discussed improvement to address pg_dump's impact. That > would require us to publish the youngest xmax of the live > snapshots. Vacuum could deduce that that xid cannot po

Re: [PATCHES] Load distributed checkpoint V3

2007-03-25 Thread Greg Smith
On Fri, 23 Mar 2007, ITAGAKI Takahiro wrote: Here is the latest version of Load distributed checkpoint patch. Couple of questions for you: -Is it still possible to get the original behavior by adjusting your tunables? It would be nice to do a before/after without having to recompile, and I