Re: [PERFORM] Migrating to 8.3 - checkpoints and background writer

2007-11-05 Thread Erik Jones
On Nov 4, 2007, at 6:33 PM, Greg Smith wrote: For those of you considering a move to the upcoming 8.3 release, now in beta, I've written some documentation on the changes made in checkpoint and background writer configuration in the new version: http://www.westnet.com/~gsmith/content/postg

Re: [PERFORM] Migrating to 8.3 - checkpoints and background writer

2007-11-04 Thread Greg Smith
On Mon, 5 Nov 2007, Steinar H. Gunderson wrote: I'm a bit puzzled by this part, though: "All tests are on linux with the anticipatory I/O scheduler. The default I/O scheduler for Linux is CFQ (Completely Fair Queue), which does not work well for PostgreSQL in my tests." The syncronized scan

Re: [PERFORM] Migrating to 8.3 - checkpoints and background writer

2007-11-04 Thread Steinar H. Gunderson
On Sun, Nov 04, 2007 at 07:33:46PM -0500, Greg Smith wrote: > On the topic of performance improvements in 8.3, I don't think this list > has been getting information about the concurrent sequential scans > improvements. Check out these documents for more about that: > > http://j-davis.com/postgr

[PERFORM] Migrating to 8.3 - checkpoints and background writer

2007-11-04 Thread Greg Smith
For those of you considering a move to the upcoming 8.3 release, now in beta, I've written some documentation on the changes made in checkpoint and background writer configuration in the new version: http://www.westnet.com/~gsmith/content/postgresql/chkp-bgw-83.htm Since the first half of that