Re: [PATCHES] smartvacuum() instead of autovacuum
| От | Tom Lane |
|---|---|
| Тема | Re: [PATCHES] smartvacuum() instead of autovacuum |
| Дата | |
| Msg-id | 10306.1161569392@sss.pgh.pa.us обсуждение |
| Ответ на | Re: [PATCHES] smartvacuum() instead of autovacuum ("Hitoshi Harada" <hitoshi_harada@forcia.com>) |
| Ответы |
Re: [PATCHES] smartvacuum() instead of autovacuum
|
| Список | 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 по дате отправления: