How to improve the restore performance in PostgreSQL

1090105 pts.
Tags:
Backup and restore
PostgreSQL
For our restore performance in PostgreSQL, we used pg_dump with the default plain format (which worked okay). But then we started to get time / space improvements when using pg_dump -Fc | gzip -9 -c > However, when we tried to create the database anew, the restore took almost half a day to create it (and that's only a piece of what it will become) Here's what we used:
# create tablespace dbname location '/SAN/dbname';
# create database dbname tablespace dbname;
# alter database dbname set temp_tablespaces = dbname;

% gunzip dumpfile.gz              # to evaluate restore time without a piped uncompression
% pg_restore -d dbname dumpfile   # into a new, empty database defined above
How can we improve the performance? Thank you

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: