Re: [PATCHES] smartvacuum() instead of autovacuum - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [PATCHES] smartvacuum() instead of autovacuum
Date
Msg-id 10306.1161569392@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCHES] smartvacuum() instead of autovacuum  ("Hitoshi Harada" <hitoshi_harada@forcia.com>)
Responses Re: [PATCHES] smartvacuum() instead of autovacuum  ("Hitoshi Harada" <hitoshi_harada@forcia.com>)
List pgsql-hackers
"Hitoshi Harada" <hitoshi_harada@forcia.com> writes:
>> How is this different from what autovacuum does?

> My application needs to do vacuum by itself, while
> autovacuum does it as daemon.
> The database is updated so frequently that 
> normal vacuum costs too much and tables to be updated are
> not so many as the whole database is vacuumed.
> I want to use autovacuum except the feature of daemon, 
> but want to control when to vacuum and which table to vacuum.
> So, nothing is different between autovacuum and smartvacuum(),
> but former is daemon and later is user function.

This seems completely unconvincing.  What are you going to do that
couldn't be done by autovacuum?
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: New CRC algorithm: Slicing by 8
Next
From: Tom Lane
Date:
Subject: Re: New CRC algorithm: Slicing by 8