| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Need to vacuum multiple times for effectiveness? |
| Date: | 2002-02-25 07:34:00 |
| Message-ID: | 20020225183400.A16945@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Mon, Feb 25, 2002 at 03:28:20PM +0800, Lincoln Yeoh wrote:
> Hi,
>
> I'm using v7.1.3 and somehow when some tables get very bloated (many
> inserts over weeks) I seem to need to vacuum repeatedly before the table
> really gets cleaned up and postmaster starts using less CPU.
It is generally recommended to run VACUUM ANALYZE every day. The reason is
that new rows are put on the end of the table and yet need VACUUM to clean
out the cruft.
This is better explained in the docs.
--
Martijn van Oosterhout <kleptog(at)svana(dot)org>
http://svana.org/kleptog/
> If the company that invents a cure for AIDS is expected to make their
> money back in 17 years, why can't we ask the same of the company that
> markets big-titted lip-syncing chicks and goddamn cartoon mice?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Meskes | 2002-02-25 07:47:25 | Re: [HACKERS] connect with ecpg |
| Previous Message | Lincoln Yeoh | 2002-02-25 07:28:20 | Need to vacuum multiple times for effectiveness? |