| From: | Jesper Krogh <jesper(at)krogh(dot)cc> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | autovacuum? |
| Date: | 2008-04-17 19:48:49 |
| Message-ID: | 4807A9A1.9040806@krogh.cc |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Jorjoliani | 2008-04-17 20:21:23 | Database update problem from crontab on ubuntu server |
| Previous Message | Peter Koczan | 2008-04-17 16:40:22 | PG 8.3 and kerberos failures |