Bug Report

Поиск
Список
Период
Сортировка
От Tumrong (Tommy) Sakulchaicharoen
Тема Bug Report
Дата
Msg-id KL1PR0601MB4340077D6B92EF37D78277C4F2959@KL1PR0601MB4340.apcprd06.prod.outlook.com
обсуждение исходный текст
Список 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
Вложения

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Padmakumar Kadayaprth
Дата:
Сообщение: Logical Replication not working for few Tables
Следующее
От: "Euler Taveira"
Дата:
Сообщение: Re: Logical Replication not working for few Tables