Need to vacuum multiple times for effectiveness?

From: Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Need to vacuum multiple times for effectiveness?
Date: 2002-02-25 07:28:20
Message-ID: 5.1.0.14.1.20020225152153.02634ec0@192.228.128.13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2002-02-25 07:34:00 Re: Need to vacuum multiple times for effectiveness?
Previous Message Bob T 2002-02-25 06:38:01 template Database