On Fri, 2007-06-15 at 13:11 +0200, 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
Jaime Casanova [EMAIL PROTECTED] writes:
another question: if the fillfactor is 100% then is a complete waste
of time to look for a suggested block. maybe we could check for that?
No, it isn't, since the page might have been vacuumed since it was last
filled up.
Simon Riggs [EMAIL PROTECTED] writes:
checkpoint_maxpages would seem like a better name; we've already had
those _maxpages settings for 3 releases, so changing that is not really
an option (at so late a stage).
Sure it is. We've never promised stability of obscure tuning settings.
For
On Sat, 2007-06-16 at 11:02 -0400, Tom Lane wrote:
Simon Riggs [EMAIL PROTECTED] writes:
checkpoint_maxpages would seem like a better name; we've already had
those _maxpages settings for 3 releases, so changing that is not really
an option (at so late a stage).
Sure it is.
Maybe, but
On 6/16/07, Tom Lane [EMAIL PROTECTED] wrote:
Jaime Casanova [EMAIL PROTECTED] writes:
another question: if the fillfactor is 100% then is a complete waste
of time to look for a suggested block. maybe we could check for that?
No, it isn't, since the page might have been vacuumed since it was
Forwarding to -patches. FWIW I looked around a little and couldn't find a
suitable replacement, but if someone knows of one (or can find one) we could
replace the link rather than remove it.
On Friday 15 June 2007 20:23, David Gardner wrote:
I was just reading the pgsql developer faq :
Completed all of the agreed changes for TG:
- WAL writer now runs always, wal_writer_delay = 50ms (default)
- when transaction_guarantee = off we record the latest LSN
- when we set xact hint bits we look at the latest LSN
- added database-level stats to show guaranteed commits
- fsync parameter