autovacuum?
От | Jesper Krogh |
---|---|
Тема | autovacuum? |
Дата | |
Msg-id | 4807A9A1.9040806@krogh.cc обсуждение исходный текст |
Ответы |
Re: autovacuum?
|
Список | pgsql-admin |
Hi. I have a mostly insert/select database, so vacumming is generally not much needed.. but among the tables I have one which is used as a message-queue so a lot of insert/updates/deletes on small simple records on that one. How do I check that autovacumm is running at all? (I think i have enabled it in /etc/postgresql/8.2/*/postgresql.conf ). select relname,last_autovacuum,last_autoanalyze from pg_stat_user_tables where relname = 'job'; relname | last_autovacuum | last_autoanalyze ---------+-------------------------------+------------------------------- job | 2008-04-16 07:19:24.832413+02 | 2008-04-17 01:40:05.242914+02 So it seems to be running. But shouldn't it hit the table a lot more? How do I check that it is somehow near optimal? -- Jesper
В списке pgsql-admin по дате отправления: