| From: | Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my> |
|---|---|
| To: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Need to vacuum multiple times for effectiveness? |
| Date: | 2002-02-25 09:01:09 |
| Message-ID: | 5.1.0.14.1.20020225165505.0299ed40@192.228.128.13 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I know that.
What I don't understand is why each time I decide to vacuum, I need more
than one vacuum to clean out lots of accumulated cruft.
Why do I need to issue two or three or even more vacuums before the tables
reach their fully cleaned sizes and states?
Regards,
Link.
At 06:34 PM 25-02-2002 +1100, Martijn van Oosterhout wrote:
>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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hugo Coolens | 2002-02-25 09:05:38 | terminal with horizontal scrollbar |
| Previous Message | Devrim GUNDUZ | 2002-02-25 08:51:18 | Re: About functions |