Re: Buglist - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: Buglist
Date
Msg-id 20030822140127.GA27885@wolff.to
Whole thread Raw
In response to Re: Buglist  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
List pgsql-general
On Fri, Aug 22, 2003 at 12:17:41 +0530,
  Shridhar Daithankar <shridhar_daithankar@persistent.co.in> wrote:
>
> Idea of autovacuum is to reduce load on vacuum full. If you set shared_buffers
> higher and FSM properly for he update/delete load, autovacuum is expected to
> catch most of the dead tuples in shared cache only. If it is successful in
> doubling the frequency on vacuum full, that's a big win, isn't it?

If you run a normal vacuum often enough, you shouldn't need to regularly
run vacuum full.

pgsql-general by date:

Previous
From: Shridhar Daithankar
Date:
Subject: Re: Postgresql for Solaris on Sparc
Next
From: javier garcia - CEBAS
Date:
Subject: pgAdminII Error