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

Re: pg_dump and thousands of schemas

From: "Hugo <Nabble>" <hugo(dot)tech(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: pg_dump and thousands of schemas
Date: 2012-05-27 04:12:13
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackerspgsql-performance
Here is a sample dump that takes a long time to be written by pg_dump:
(the file above has 2.4Mb, the dump itself has 66Mb)

This database has 2,311 schemas similar to those in my production database.
All schemas are empty, but pg_dump still takes 3 hours to finish it on my
computer. So now you can imagine my production database with more than
20,000 schemas like that. Can you guys take a look and see if the code has
room for improvements? I generated this dump with postgresql 9.1 (which is
what I have on my local computer), but my production database uses
postgresql 9.0. So it would be great if improvements could be delivered to
version 9.0 as well.

Thanks a lot for all the help!


View this message in context:
Sent from the PostgreSQL - performance mailing list archive at

In response to


pgsql-performance by date

Next:From: Ivan VorasDate: 2012-05-27 15:57:55
Subject: Re: Seqscan slowness and stored procedures
Previous:From: Pavel StehuleDate: 2012-05-27 03:28:32
Subject: Re: Seqscan slowness and stored procedures

pgsql-hackers by date

Next:From: Magnus HaganderDate: 2012-05-27 08:48:55
Subject: Re: pg_stat_statements temporary file
Previous:From: Pavel StehuleDate: 2012-05-27 03:40:53
Subject: Re: VIP: new format for psql - shell - simple using psql in shell

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