Skip site navigation (1) Skip section navigation (2)

speedup pg_dumpall

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 (view raw, whole thread or download thread mbox)
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 [gesprochen: Prot-e-schee]
Tel: +43 660 / 415 6531


pgsql-admin by date

Next:From: Gera Mel HandumonDate: 2012-02-22 09:39:23
Subject: constraints primary key and foreign key lost.
Previous:From: Kevin GrittnerDate: 2012-02-20 17:09:56
Subject: Re: R: Out of memory...

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group