Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

2 Answers 2

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
1  
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

 
discard

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.