| From: | Bruce Momjian <bruce(at)momjian(dot)us> |
|---|---|
| To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Magnus Hagander <magnus(at)hagander(dot)net> |
| Subject: | Re: Further pg_upgrade analysis for many tables |
| Date: | 2012-11-09 00:33:40 |
| Message-ID: | 20121109003340.GA26605@momjian.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Nov 8, 2012 at 03:46:09PM -0800, Jeff Janes wrote:
> On Wed, Nov 7, 2012 at 6:17 PM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> > As a followup to Magnus's report that pg_upgrade was slow for many
> > tables, I did some more testing with many tables, e.g.:
> >
> ...
> >
> > Any ideas? I am attaching my test script.
>
> Have you reviewed the thread at:
> http://archives.postgresql.org/pgsql-performance/2012-09/msg00003.php
> ?
>
> There is a known N^2 behavior when using pg_dump against pre-9.3 servers.
I am actually now dumping git head/9.3, so I assume all the problems we
know about should be fixed.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2012-11-09 01:01:41 | Enabling Checksums |
| Previous Message | Jeff Janes | 2012-11-08 23:58:47 | Re: AutoVacuum starvation from sinval messages |