| From: | Ryan MYJ <ryanmyj(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Hi All, |
| Date: | 2023-02-18 00:00:18 |
| Message-ID: | CANJgbZcZbAb+Z0bF6Dqeh6UCm1H0A0sb5+PWfFvWQtLuniHvHw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Currently I'm working on upgrading a postgresql version from 9.3 to 12. The
database size is around 700G.
I finished the pg_upgrade process but when I ran 'analyze_new_cluster.sh'
it stucked at the first log 'vacuumdb: processing database "otdb":
Generating minimal optimizer statistics (1 target)'.
Then I checked the active query, the following query has been running for
several hours:
pid | db | start | lap |
query
---------+-----------+-------------------------------+-----------------+------------------------------
1822933 | otdb | 2023-02-18 03:02:36.035755+08 | 04:56:41.408329 |
ANALYZE pg_catalog.pg_class;
Do you know what I can do to speed up this process? Because on another
Testing environment(around 300G data), this 'analyze_new_cluster.sh' only
took several minutes to complete.
Thanks a lot.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Pospisek | 2023-02-18 14:02:00 | can't get psql authentication against Active Directory working |
| Previous Message | Peter Geoghegan | 2023-02-17 21:34:57 | Re: Automatic aggressive vacuum on almost frozen table takes too long |