Re: Optimize pg_dump schema-only - Mailing list pgsql-general

From Tom Lane
Subject Re: Optimize pg_dump schema-only
Date
Msg-id 29891.1556511173@sss.pgh.pa.us
Whole thread Raw
In response to Re: Optimize pg_dump schema-only  (senor <frio_cervesa@hotmail.com>)
List pgsql-general
senor <frio_cervesa@hotmail.com> writes:
> I'm afraid it is 9.2.4.

That's pretty old :-(

> I noticed on 2 installations with similar table numbers (~200,000), 
> schema and hardware that one was done in hours and the other didn't 
> finish over the weekend. Keeping tabs on pg_stat_activity indicated 
> pg_dump was still processing and nothing else running.

Hmm ... but without knowing what's different between the two, that's
not much help.

> Would you say that updating to 9.2.24 would be beneficial before 
> upgrading to 9.6? An update is pretty quick and could be worth the time 
> if there aren't additional requirements prior to starting the upgrade.

That was my reasoning.  It might not help, but it's a simple thing
to do and it might help.

            regards, tom lane



pgsql-general by date:

Previous
From: senor
Date:
Subject: Re: Optimize pg_dump schema-only
Next
From: Shai Cantor
Date:
Subject: Thousands of partitions performance questions