Bug Report - Mailing list pgsql-bugs

From Tumrong (Tommy) Sakulchaicharoen
Subject Bug Report
Date
Msg-id KL1PR0601MB4340077D6B92EF37D78277C4F2959@KL1PR0601MB4340.apcprd06.prod.outlook.com
Whole thread Raw
List pgsql-bugs
Dear Support,
    
     We freshly installed Postgres version on Amazon Web Service, Then, we did data dump from old Postgres to our new Postgres database. After database is recovered from the old Postgres. We try to the command VACUUM, REINDEX, and ANALYZE tables. The commands run successfully on some table, Some table The ANALYZE table command keep running forever. The ANALYZE command is being run inside pgAdmin 4. 

Here is our Postgres and OS version:

PostgreSQL 9.6.22 on x86_64-pc-linux-gnu (Ubuntu 9.6.22-1.pgdg16.04+1),
compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.12) 5.4.0 20160609, 64-bit


Please kindly provide recommendation to fix the problem.  The screen shot of ANALYZE command. The table has the total number of records 101183. I check table "pg_stat_all_tables" The column name "last_analyze" has time stamp. Thank you very much for your support. 



Best regards, 
Tommy
Attachment

pgsql-bugs by date:

Previous
From: Padmakumar Kadayaprth
Date:
Subject: Logical Replication not working for few Tables
Next
From: "Euler Taveira"
Date:
Subject: Re: Logical Replication not working for few Tables