How to Trigger An Automtic Vacuum on Selected Tables
От
Lane Van Ingen
Тема
How to Trigger An Automtic Vacuum on Selected Tables
Дата
Msg-id
EKEMKEFLOMKDDLIALABIEECFCDAA.lvaningen@esncc.com
Список
Дерево обсуждения
How to Trigger An Automtic Vacuum on Selected Tables "Lane Van Ingen" <lvaningen@esncc.com>
Re: How to Trigger An Automtic Vacuum on Selected Tables "Dario" <dario_d_s@unitech.com.ar>
I am running version 8.0.1 on Windows 2003. I have an application that subjects PostgreSQL to sudden bursts of activity at times which cannot be predicted. The bursts are significant enough to cause performance degradation, which can be fixed by a 'vacuum analyze'. I am aware of the existence and contents of tables like pg_class. QUESTION: I would like to trigger a vacuum analyze process on a table whenever it gets a large enough burst of activity to warrant it. Using the data in pg_class (like the number of pages the system found the last time it was vacuumed / analyzed), I would like to compare those statistics to current size, and trigger a vacuum/analyze on a table if needed. Does anyone know of any available tools, or an approach I could use, to determine what the CURRENT SIZE is ?
В списке pgsql-performance по дате отправления