Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have locally a 2 GB database dump with BLOB-s, in "custom" pg_dump format. It takes about 50 minutes to restore, 49 of which is restoring the BLOB-s.

PostgreSQL version is 8.4.2. Platforms: OS X & Linux

Can the restoration time be somehow improved?

share|improve this question

Restoring large amounts of binary data is an inherently time-consuming process, and Postgres is about as efficient at it as a database server can be.

In order to speed up the restore you basically need faster disks.

share|improve this answer

Stop saving the images in the database, just save the path instead.

share|improve this answer
How do you know he's storing images? There is nothing in the question that supports this assumption... – voretaq7 Aug 30 '11 at 18:52

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.