Re: pg_dump incredibly slow dumping a single schema from a large db

From: Mike Roest <mike(dot)roest(at)replicon(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump incredibly slow dumping a single schema from a large db
Date: 2012-03-30 17:33:38
Message-ID: CAE7ByhjxXqs=CrQBYiKwA766wOw87j8RRbrLhBDYFpU8RCVp1g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

That was on the CentOS 5.8 x64 machine. The one I'm trying it from now is
Ubuntu 11.10 x64

On Fri, Mar 30, 2012 at 11:30 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Mike Roest <mike(dot)roest(at)replicon(dot)com> writes:
> > Ok I just realized that's probably not going to be much help :)
>
> gmon.out would be of no value to anybody else anyway --- making sense of
> it requires the exact executable you took the measurements with.
>
> > 0.00 0.00 0.00 5 0.00 0.00 canonicalize_path
> > 0.00 0.00 0.00 5 0.00 0.00
> > trim_trailing_separator
> > 0.00 0.00 0.00 3 0.00 0.00 strlcpy
>
> Ugh. There are some platforms on which gprof is busted to various
> degrees; you may have one. What platform is this exactly?
>
> regards, tom lane
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alan Hodgson 2012-03-30 17:44:25 Re: ERROR: invalid byte sequence for encoding "UTF8": 0xc325
Previous Message Tom Lane 2012-03-30 17:30:26 Re: pg_dump incredibly slow dumping a single schema from a large db

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Farina 2012-03-30 17:44:20 Re: HTTP Frontend? (and a brief thought on materialized views)
Previous Message Tom Lane 2012-03-30 17:30:26 Re: pg_dump incredibly slow dumping a single schema from a large db