| From: | Andri Saar <andris(at)estpak(dot)ee> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Hannu Krosing <hannu(at)tm(dot)ee>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Serious issues with CPU usage |
| Date: | 2003-09-08 14:31:13 |
| Message-ID: | 200309081731.13136.andris@estpak.ee |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Monday 08 September 2003 17:04, Tom Lane wrote:
>
> It looks to me like throwing a plain VACUUM into your poller cycle
> (or possibly VACUUM ANALYZE depending on how fast the table's stats
> change) would solve your problems nicely.
>
I compled the pg_autovacuum daemon from 7.4beta sources as Shridhar Daithankar
recommended, and it seems to work fine. At first glance I thought VACUUM is a
thing you do maybe once per week during routine administration tasks like
making a full backup, but I was wrong.
Thanks to all for your help, we can consider this problem solved.
Note to future generations: default postgres configuration settings are very
conservative and don't be afraid to VACUUM very often.
andri
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shridhar Daithankar | 2003-09-08 14:50:35 | Re: Serious issues with CPU usage |
| Previous Message | Rhaoni Chiu Pereira | 2003-09-08 14:29:21 | Explain Doc |