senor <frio_cerv...@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


Reply via email to