| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | senor <frio_cervesa(at)hotmail(dot)com> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Optimize pg_dump schema-only |
| Date: | 2019-04-29 04:12:53 |
| Message-ID: | 29891.1556511173@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
senor <frio_cervesa(at)hotmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shai Cantor | 2019-04-29 05:12:41 | Thousands of partitions performance questions |
| Previous Message | senor | 2019-04-29 01:59:12 | Re: Optimize pg_dump schema-only |