X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 43C96D1B4F8 for ; Sun, 7 Sep 2003 05:23:57 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 08251-08 for ; Sun, 7 Sep 2003 02:23:25 -0300 (ADT) Received: from flake.decibel.org (unknown [66.143.173.58]) by svr1.postgresql.org (Postfix) with SMTP id 61883D1B4F4 for ; Sun, 7 Sep 2003 02:23:24 -0300 (ADT) Received: (qmail 34795 invoked by uid 1001); 7 Sep 2003 05:23:24 -0000 Date: Sun, 7 Sep 2003 00:23:24 -0500 From: "Jim C. Nasby" To: pgsql-performance@postgresql.org Subject: Poor pg_dump performance Message-ID: <20030907052324.GC37152@nasby.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.4.1i X-Operating-System: FreeBSD 4.8-RELEASE-p3 i386 X-Distributed: Join the Effort! http://www.distributed.net X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/113 X-Sequence-Number: 3479 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@nasby.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?"