Search Postgresql Archives

Exp/Imp data with blobs

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

In one db that I have, there are a few columns that are blob datatype.
This db has around 200MB of data today and as it a development db yet,
so I am replicating data to another db for testing purposes using
pg_dump and pg_restore.

To export the data it is pretty fast, about 3~4 minutes, that means acceptable.
However, when I import this data to another db (even on the same
machine) it takes around 4 hours to perform the pg_restore. I see
during the process that spend most of the time importing the blob
records.
So I stopped to think if I need to adjust this db with different
parameters, or if this behavior is already expected when working with
blobs.
Does anyone have suggestions how can I tune this process??

Here is the basic info about my env.
Windows 32;
Postgres 9.1;
shared_buffers = 256M
maintenance_work_mem = 32M

Any other question or doubt, please let me know.

Thank you in advance.
Alex

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux