"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