"Hitoshi Harada" <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to