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

From Tom Lane
Subject Re: pg_dump and thousands of schemas
Date
Msg-id 20887.1337956883@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump and thousands of schemas  ("Hugo <Nabble>" <hugo.tech@gmail.com>)
Responses Re: pg_dump and thousands of schemas  (Bruce Momjian <bruce@momjian.us>)
Re: pg_dump and thousands of schemas  (Tatsuo Ishii <ishii@postgresql.org>)
Re: pg_dump and thousands of schemas  ("Hugo <Nabble>" <hugo.tech@gmail.com>)
List pgsql-performance
"Hugo <Nabble>" <hugo.tech@gmail.com> writes:
> If anyone has more suggestions, I would like to hear them. Thank you!

Provide a test case?

We recently fixed a couple of O(N^2) loops in pg_dump, but those covered
extremely specific cases that might or might not have anything to do
with what you're seeing.  The complainant was extremely helpful about
tracking down the problems:
http://archives.postgresql.org/pgsql-general/2012-03/msg00957.php
http://archives.postgresql.org/pgsql-committers/2012-03/msg00225.php
http://archives.postgresql.org/pgsql-committers/2012-03/msg00230.php

            regards, tom lane

pgsql-performance by date:

Previous
From: Greg Spiegelberg
Date:
Subject: Re: Maximum number of sequences that can be created
Next
From: Craig James
Date:
Subject: Re: Maximum number of sequences that can be created