[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 n

Re: [PATCHES] Load Distributed Checkpoints, revised patch

2007-06-15 Thread Michael Paesold
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 be pushed to 8.4. Why

[PATCHES] WIP: script binaries renaming

2007-06-15 Thread Zdenek Kotala
I attach patch which renames following binaries createdb createlang createuser dropdb droplang dropuser clusterdb vacuumdb reindexdb to pg_createdb pg_createlang pg_createuser pg_dropdb pg_droplang pg_dropuser pg_clusterdb pg_vacuumdb pg_reindexdb Symlinks (or copy on win32) are created f

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 tha

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'

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 checkpo

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 apar

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