after 9.2.4 patch vacuumdb -avz not analyzing all tables
От | Mike Broers |
---|---|
Тема | after 9.2.4 patch vacuumdb -avz not analyzing all tables |
Дата | |
Msg-id | CAB9893het38CbHoHOt=GZ5tuUnb77EauGidjHsyy7Mqu_4_P9w@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: after 9.2.4 patch vacuumdb -avz not analyzing all tables
|
Список | pgsql-admin |
After patching to 9.2.4 I am noticing some mysterious behavior in my nightly vacuumdb cron job.
I have been running vacuumdb -avz nightly for a while now, and have a script that tells me the next day if all the tables in pg_stat_user_tables have been vacuumed and analyzed in the last 24 hours.
Since the patch some tables do not seem to be getting analyzed. This did not happen after I patched from earlier versions of 9.2 like 9.2.1 to 9.2.2, 9.2.3.
I pipe the output of the vacuumdb command to a log file, and there dont appear to be any errors, its just not analyzing all the tables as it did before. Some tables are still being analyzed ok. Its vacuuming all but a few tables that I know are being blocked by idle in transaction sessions.
Manually analyzing the table with the psql analyze command updates the timestamp in pg_stat_user_tables as expected. I patched about 8 database servers to 9.2.4 and this is the only one with this problem.
Any advice?
В списке pgsql-admin по дате отправления: