| From: | Michael Monnerie <lists(dot)michael(dot)monnerie(at)is(dot)it-management(dot)at> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | speedup pg_dumpall |
| Date: | 2012-02-22 06:30:45 |
| Message-ID: | 2829256.7Mb1lcLYlD@saturn |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gera Mel Handumon | 2012-02-22 09:39:23 | constraints primary key and foreign key lost. |
| Previous Message | Kevin Grittner | 2012-02-20 17:09:56 | Re: R: Out of memory... |