Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] pg_dump and thousands of schemas

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Denis <socsam(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: [HACKERS] pg_dump and thousands of schemas
Date: 2012-11-06 15:07:34
Message-ID: 13005.1352214454@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
Denis <socsam(at)gmail(dot)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


In response to

Responses

pgsql-performance by date

Next:From: Willem LeenenDate: 2012-11-06 15:12:27
Subject: Re: help with too slow query
Previous:From: Виктор ЕгоровDate: 2012-11-06 14:52:01
Subject: Re: help with too slow query

pgsql-hackers by date

Next:From: DenisDate: 2012-11-06 15:40:21
Subject: Re: [HACKERS] pg_dump and thousands of schemas
Previous:From: DenisDate: 2012-11-06 14:16:14
Subject: Re: [HACKERS] pg_dump and thousands of schemas

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group