Re: [PERFORM] Serious issues with CPU usage

[EMAIL PROTECTED] kirjutas L, 06.09.2003 kell 00:58: > Hi, > > i'm having _serious_ issues of postgres hogging up the CPU over time. A graph > showing this can be seen at http://andri.estpak.ee/cpu0.png . > > The database is running on Redhat 9 (stock 2.4.20-8 kernel), on a reiserfs > partition (

[PERFORM] Poor pg_dump performance

(note that the CPU percents are per-cpu, so 100% would be 100% of one CPU) According to vmstat, there's very little disk I/O, so that's not a bottleneck. The command I used was: pg_dump -vFc -f pgsql-20030906.cdb stats It should be compressing, but if that was the bottleneck, shouldn