"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