Search Postgresql Archives

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

To: Tom Lane <tgl@xxxxxxxxxxxxx>
Subject: Re: pg_dump incredibly slow dumping a single schema from a large db
From: Mike Roest <mike.roest@xxxxxxxxxxxx>
Date: Sat, 31 Mar 2012 14:54:23 -0600
Cc: pgsql-hackers@xxxxxxxxxxxxxx, pgsql-general@xxxxxxxxxxxxxx
In-reply-to: <CAE7ByhhDgMdiALoGwpu+UXunP=iM9wJHWynfuk8bBhYNYH2bPQ@mail.gmail.com>

I'm just pulling another backup using the stock 9.1.1 pg_dump to ensure the backups are equivalent.

Schema & data are identical between the 2 backups. the new backup passes all our tests for validating a tenant.

Thank you again for the quick response!

--Mike

References:
- pg_dump incredibly slow dumping a single schema from a large db
  - From: Mike Roest
- Re: pg_dump incredibly slow dumping a single schema from a large db
  - From: Tom Lane
- Re: pg_dump incredibly slow dumping a single schema from a large db
  - From: Mike Roest
- Re: pg_dump incredibly slow dumping a single schema from a large db
  - From: Mike Roest
- Re: pg_dump incredibly slow dumping a single schema from a large db
  - From: Tom Lane
- Re: pg_dump incredibly slow dumping a single schema from a large db
  - From: Mike Roest
- Re: pg_dump incredibly slow dumping a single schema from a large db
  - From: Tom Lane
- Re: pg_dump incredibly slow dumping a single schema from a large db
  - From: Mike Roest
- Re: pg_dump incredibly slow dumping a single schema from a large db
  - From: Tom Lane
- Re: pg_dump incredibly slow dumping a single schema from a large db
  - From: Tom Lane
- Re: pg_dump incredibly slow dumping a single schema from a large db
  - From: Mike Roest