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 20:34:03
Message-ID: CAE7ByhgEPyoX+1rz-PjJn5GBWkTuex_C6y9po5d-7mpeS57UyQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

>
> That could be out-of-date info though. Here's some info about
> another possibility:
> http://wiki.postgresql.org/wiki/Profiling_with_perf
>
>
There we go this perf worked on the VM.

The file is 6 megs so I've dropped it here.

That was doing perf for the length of the pg_dump command and then a perf
report -n
http://dl.dropbox.com/u/13153/output.txt

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Davis 2012-03-30 21:00:58 Re: PSQL 9.1.3 segmentation fault
Previous Message Hu, William 2012-03-30 20:11:01 PSQL 9.1.3 segmentation fault

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2012-03-30 21:18:42 Re: Speed dblink using alternate libpq tuple storage
Previous Message Jeff Davis 2012-03-30 20:11:47 Re: pg_upgrade incorrectly equates pg_default and database tablespace