Postgres Pro
Downloads
Home   >   mailing lists

Need to vacuum multiple times for effectiveness? - Mailing list pgsql-general

From Lincoln Yeoh
Subject Need to vacuum multiple times for effectiveness?
Date
Msg-id 5.1.0.14.1.20020225152153.02634ec0@192.228.128.13
Whole thread Raw
In response to vacuum never finishes  (david blood <davidjblood@yahoo.com>)
Responses Re: Need to vacuum multiple times for effectiveness?  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Tree view 
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.

Why is this so?

Regards,
Link.

pgsql-general by date:

Previous
From: "Bob T"
Date:
Subject: template Database
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Need to vacuum multiple times for effectiveness?