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-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
