| From: | "Tumrong (Tommy) Sakulchaicharoen" <tumrong(at)k2insight(dot)com> |
|---|---|
| To: | "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Bug Report |
| Date: | 2021-11-12 15:25:29 |
| Message-ID: | KL1PR0601MB4340077D6B92EF37D78277C4F2959@KL1PR0601MB4340.apcprd06.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
[cid:af850314-1a1f-4915-a8af-5441cdcedcda]
Best regards,
Tommy
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Euler Taveira | 2021-11-12 19:00:18 | Re: Logical Replication not working for few Tables |
| Previous Message | Padmakumar Kadayaprth | 2021-11-12 14:36:32 | Logical Replication not working for few Tables |