>> You should never have to do full vacuums... I would rather say, You should never have to do full vacuums by any periodic means. It may be done on a adhoc basis, when you have figured out that your table is never going to grow that big again. On 1/17/06, Christopher Kings-Lynne <chriskl@xxxxxxxxxxxxxxxxxxx> wrote: > > 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 >
