Poor pg_dump performance

From: "Jim C(dot) Nasby" <jim(at)nasby(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Poor pg_dump performance
Date: 2003-09-07 05:23:24
Message-ID: 20030907052324.GC37152@nasby.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

First, sorry if this has been answered before; the list search seems to
be down...

This is on a quad Xeon-PII 450 machine running FBSD 4.8.

84386 pgsql 64 0 104M 99M RUN 1 78:20 61.87% 61.87% postgres
84385 decibel 64 0 3748K 2268K CPU1 3 49:49 37.79% 37.79% pg_dump

(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't the
pg_dump process be at 100% CPU? It does seem a bit coincidental that the
two procs seem to be taking 100% of one CPU (top shows them running on
different CPUs though).

This is version 7.3.4.
--
Jim C. Nasby, Database Consultant jim(at)nasby(dot)net
Member: Triangle Fraternity, Sports Car Club of America
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"

Browse pgsql-performance by date

  From Date Subject
Next Message Bruce Momjian 2003-09-07 16:22:55 Re: [GENERAL] how to get accurate values in pg_statistic
Previous Message Hannu Krosing 2003-09-06 09:10:13 Re: Serious issues with CPU usage