Denis <socsam@xxxxxxxxx> writes: > I've read all the posts in thread, and as I understood in version 9.2 some > patches were applied to improve pg_dump speed. I've just installed > PostgreSQL 9.2.1 and I still have the same problem. I have a database with > 2600 schemas in it. I try to dump each schema individually, but it takes too > much time for every schema (about 30-40 seconds per schema, no matter what > the data size is). Could you provide a test case for that? Maybe the output of pg_dump -s, anonymized as you see fit? > Also for each schema dump I have a slow query log entry, Could you provide EXPLAIN ANALYZE output for that query? regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
