Re: [HACKERS] pg_dump and thousands of schemas - Mailing list pgsql-performance

From Tom Lane
Subject Re: [HACKERS] pg_dump and thousands of schemas
Date
Msg-id 13005.1352214454@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] pg_dump and thousands of schemas  (Denis <socsam@gmail.com>)
Responses Re: [HACKERS] pg_dump and thousands of schemas  (Denis <socsam@gmail.com>)
List pgsql-performance
Denis <socsam@gmail.com> 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


pgsql-performance by date:

Previous
From: Виктор Егоров
Date:
Subject: Re: help with too slow query
Next
From: Willem Leenen
Date:
Subject: Re: help with too slow query