Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump incredibly slow dumping a single schema from a large db - Mailing list pgsql-general

From Mike Roest
Subject Re: pg_dump incredibly slow dumping a single schema from a large db
Date
Msg-id CAE7ByhgEPyoX+1rz-PjJn5GBWkTuex_C6y9po5d-7mpeS57UyQ@mail.gmail.com
Whole thread Raw
In response to Re: pg_dump incredibly slow dumping a single schema from a large db  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_dump incredibly slow dumping a single schema from a large db
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: "Hu, William"
Date:
Subject: PSQL 9.1.3 segmentation fault
Next
From: Jeff Davis
Date:
Subject: Re: PSQL 9.1.3 segmentation fault