Search Postgresql Archives

Hi All,

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux