>>> On Tue, Aug 21, 2007 at 1:12 PM, in message <[EMAIL PROTECTED]>, Greg Smith <[EMAIL PROTECTED]> wrote: > My suggestion for a starting 8.3 configuration for you would be adjusting > these settings as follows: > > shared_buffers=1GB > checkpoint_segments = 50 I'm not into the most meaningful tests yet, but I'm trying to garner what useful information I can from the load of the 8.2.5 database into a server running the cvs tip copy taken a few hours ago. After letting the cache settle in, while in the middle of a COPY of a large table, I see the attached through a couple checkpoint cycles. The pattern is pretty consistent with this over other the other checkpoint cycles I've examined. Note that the system can sustain over 20000 writes per second without the disk being a bottleneck. The current tip behavior is smoother than 8.2.x without background writer, for sure. It still isn't as smooth as 8.2.x with an aggressive backgroud writer, at least for loading a dump. Note how it lounges around at as low as 5500 writes per second for prolonged periods with occassional spikes into the 55000 range, causing I/O wait time, although these only last a few seconds. Without more rigorous tests for comparison, I'd say that this is probably a net loss for this operation -- I seem to recall seeing a pretty steady 20000 bo under 8.2.x. More info to follow as testing progresses. -Kevin
vmstat.sample1.out
Description: Binary data
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
