Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id B97293405C6 for ; Wed, 22 Feb 2012 02:31:33 -0400 (AST) Received: from mailsrv14.zmi.at ([212.69.164.54]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1S05jf-0000Lz-Kg for pgsql-admin@postgresql.org; Wed, 22 Feb 2012 06:31:33 +0000 Received: from mailsrv.i.zmi.at (h081217106014.dyn.cm.kabsi.at [81.217.106.14]) (using TLSv1 with cipher DHE-RSA-CAMELLIA256-SHA (256/256 bits)) (Client CN "mailsrv2.i.zmi.at", Issuer "power4u.zmi.at" (not verified)) by mailsrv14.zmi.at (Postfix) with ESMTPSA id 84CB4182242F for ; Wed, 22 Feb 2012 07:30:45 +0100 (CET) Received: from saturn.localnet (saturn.i.zmi.at [10.72.27.2]) by mailsrv.i.zmi.at (Postfix) with ESMTP id 101A1CD7C8C for ; Wed, 22 Feb 2012 07:30:51 +0100 (CET) From: Michael Monnerie To: pgsql-admin@postgresql.org Subject: speedup pg_dumpall Date: Wed, 22 Feb 2012 07:30:45 +0100 Message-ID: <2829256.7Mb1lcLYlD@saturn> Organization: it-management http://it-management.at User-Agent: KMail/4.7.2 (Linux/3.1.9-1.4-desktop; KDE/4.7.2; x86_64; ; ) MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart2350789.JaxrU08E3A"; micalg="pgp-sha1"; protocol="application/pgp-signature" Content-Transfer-Encoding: quoted-printable X-Pg-Spam-Score: -2.6 (--) X-Archive-Number: 201202/85 X-Sequence-Number: 39145 --nextPart2350789.JaxrU08E3A Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="utf-8" On one database server, we have both MySQL und PostgreSQL running, and=20= via script make a fulldump. We see that MySQL is more than twice as fas= t=20 for that: mysql 5.1: 100s (1.66 Min) 1110224519 Bytes, 10.58 MB/s postgres 8.4: 133s (2.21 Min) 654205642 Bytes, 4.69 MB/s The commands are: 1) mysqldump --single-transaction --flush-logs --master-data=3D2 --all-= databases --add-drop-table 2) pg_dumpall -c What can I do to improve pg_dump performance? --=20 mit freundlichen Gr=C3=BCssen, Michael Monnerie, Ing. BSc it-management Internet Services: Prot=C3=A9ger http://proteger.at [gesprochen: Prot-e-schee] Tel: +43 660 / 415 6531 --nextPart2350789.JaxrU08E3A Content-Type: application/pgp-signature; name="signature.asc" Content-Description: This is a digitally signed message part. -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.18 (GNU/Linux) iEYEABECAAYFAk9Ei5UACgkQzhSR9xwSCbRyegCZAfpHXyEhZb39+Znv4n8jmYXr qyUAn0g/2YPca15Mo6i44aZumAEFvUlZ =/BrW -----END PGP SIGNATURE----- --nextPart2350789.JaxrU08E3A--