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
Attachment:
signature.asc
Description: This is a digitally signed message part.
