1

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?

2 Answers 2

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.

0

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

1
  • 1
    How do you know he's storing images? There is nothing in the question that supports this assumption...
    – voretaq7
    Aug 30, 2011 at 18:52

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .