Mark Wong wrote:
I would agree that is "not good" :-) It sounds like pg_autovacuum is being to aggressive for this type of load, that is vacuuming more often than needed, however the lazy vacuum options were added so as to reduce the performance impact of running a vacuum while doing other things, so, I would recommend both higher autovacuum thresholds and trying out some of the lazy vacuum settings.The overall throughput is better for a run like this: http://www.osdl.org/projects/dbt2dev/results/dev4-010/207/
A drop from 3865 to 2679 (31%) by just adding pg_autovacuum. That's
what I meant by "not good". :)
I'll start with the additional debug messages, with 8.0rc2, before I start changing the other settings, if that sounds good.
Sounds fine. From Tom Lane's response, we have a backend bug that needs to be resolved and I think that is the priority.
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
