[PATCHES] Load Distributed Checkpoints, revised patch

2007-06-15 Thread Heikki Linnakangas
Here's an updated WIP version of the LDC patch. I just spreads the writes, that achieves the goal of smoothing the checkpoint I/O spikes. I think sorting the writes etc. is interesting but falls in the category of further development and should be pushed to 8.4. The documentation changes are

Re: [PATCHES] WIP: script binaries renaming

2007-06-15 Thread Andrew Dunstan
Zdenek Kotala wrote: I think this patch has no (or small) impact on functionality and it should be committed to 8.3 That's really not the test we apply. We are in feature freeze, which means the only things not on the queue that should get in are bug fixes. If we don't stick to

Re: [PATCHES] WIP: script binaries renaming

2007-06-15 Thread Tom Lane
Zdenek Kotala [EMAIL PROTECTED] writes: I think this patch has no (or small) impact on functionality and it should be committed to 8.3 This missed the feature freeze deadline by well over two months. It is not a candidate for 8.3. regards, tom lane

Re: [PATCHES] Load Distributed Checkpoints, revised patch

2007-06-15 Thread Alvaro Herrera
Heikki Linnakangas wrote: - The signaling between RequestCheckpoint and bgwriter is a bit tricky. Bgwriter now needs to deal immediate checkpoint requests, like those coming from explicit CHECKPOINT or CREATE DATABASE commands, differently from those triggered by checkpoint_segments. I'm

Re: [PATCHES] Load Distributed Checkpoints, revised patch

2007-06-15 Thread Heikki Linnakangas
Michael Paesold wrote: Heikki Linnakangas wrote: Here's an updated WIP version of the LDC patch. I just spreads the writes, that achieves the goal of smoothing the checkpoint I/O spikes. I think sorting the writes etc. is interesting but falls in the category of further development and should

Re: [PATCHES] Load Distributed Checkpoints, revised patch

2007-06-15 Thread Heikki Linnakangas
Alvaro Herrera wrote: Heikki Linnakangas wrote: - The signaling between RequestCheckpoint and bgwriter is a bit tricky. Bgwriter now needs to deal immediate checkpoint requests, like those coming from explicit CHECKPOINT or CREATE DATABASE commands, differently from those triggered by

Re: [PATCHES] Load Distributed Checkpoints, revised patch

2007-06-15 Thread Alvaro Herrera
Heikki Linnakangas wrote: Alvaro Herrera wrote: if (BgWriterShmem-ckpt_time_warn elapsed_secs CheckPointWarning) ereport(LOG, (errmsg(checkpoints are occurring too frequently (%d seconds apart),

Re: [PATCHES] Maintaining cluster order on insert

2007-06-15 Thread Jaime Casanova
On 5/27/07, Jim C. Nasby [EMAIL PROTECTED] wrote: On Mon, May 21, 2007 at 10:48:59AM +0100, Heikki Linnakangas wrote: IOW it's working as designed. But maybe it's not the desired behavior. Should we have a special case and always respect the fillfactor when inserting to the last page of the