From: Michael Monnerie <lists.michael.monnerie@is.it-management.at>
To: pgsql-admin@postgresql.org
Subject: speedup pg_dumpall
Date: Wed, 22 Feb 2012 07:30:45 +0100
Message-ID: <2829256.7Mb1lcLYlD@saturn> (raw)
On one database server, we have both MySQL und PostgreSQL running, and
via script make a fulldump. We see that MySQL is more than twice as fast
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=2 --all-
databases --add-drop-table
2) pg_dumpall -c
What can I do to improve pg_dump performance?
--
mit freundlichen Grüssen,
Michael Monnerie, Ing. BSc
it-management Internet Services: Protéger
http://proteger.at [gesprochen: Prot-e-schee]
Tel: +43 660 / 415 6531
Attachments:
signature.asc (application/pgp-signature, 197B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: lists.michael.monnerie@is.it-management.at
Subject: Re: speedup pg_dumpall
In-Reply-To: <2829256.7Mb1lcLYlD@saturn>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox