Re: Autovacuum / full vacuum - Mailing list pgsql-performance

From Michael Riess
Subject Re: Autovacuum / full vacuum
Date
Msg-id dqih4p$1clg$1@news.hub.org
Whole thread Raw
In response to Re: Autovacuum / full vacuum  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: Autovacuum / full vacuum  (Michael Stone <mstone+postgres@mathom.us>)
Re: Autovacuum / full vacuum  ("Matthew T. O'Connor" <matthew@zeut.net>)
List pgsql-performance
Hi,

did you read my post? In the first part I explained why I don't want to
increase the FSM that much.

Mike

>> So my question is: What's the use of an autovacuum daemon if I still
>> have to use a cron job to do full vacuums? wouldn't it just be a minor
>> job to enhance autovacuum to be able to perform full vacuums, if one
>> really wants it to do that - even if some developers think that it's
>> the wrong approach?
>
> You should never have to do full vacuums...
>
> Chris
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

pgsql-performance by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: Autovacuum / full vacuum
Next
From: Marcos
Date:
Subject: Use of Stored Procedures and