Re: Vacuum DB in Postgres Vs similar concept in other RDBMS

Поиск
Список
Период
Сортировка
Искать
От
Ron Mayer
Тема
Re: Vacuum DB in Postgres Vs similar concept in other RDBMS
Дата
в 16:44:15
Msg-id
465DD3FA.7010506@cheapcomplexdevices.com
Ответ на
Список
Дерево обсуждения
Vacuum DB in Postgres Vs similar concept in other RDBMS "Harpreet Dhaliwal" <harpreet.dhaliwal01@gmail.com>
Re: Vacuum DB in Postgres Vs similar concept in other RDBMS "Alexander Staubo" <alex@purefiction.net>
Remove query results from cache André Volpato<andre.volpato@ecomtecnologia.com.br>
Re: Remove query results from cache Alvaro Herrera <alvherre@commandprompt.com>
Re: Vacuum DB in Postgres Vs similar concept in other RDBMS "Dann Corbit" <DCorbit@connx.com>
Re: Vacuum DB in Postgres Vs similar concept in other RDBMS "Alexander Staubo" <alex@purefiction.net>
Re: Vacuum DB in Postgres Vs similar concept in other RDBMS "Harpreet Dhaliwal" <harpreet.dhaliwal01@gmail.com>
Tom Lane wrote:
> 
> Exactly.  VACUUM sucks (ahem) in all ways but one: it pushes the
> maintenance costs associated with MVCC out of the foreground query code
> paths and into an asynchronous cleanup task.  AFAIK we are the only DBMS
> that does it that way.  Personally I believe it's a fundamentally
> superior approach --- because when you are under peak load you can defer
> the cleanup work --- but you do need to pay attention to make sure that
> the async cleanup isn't postponed too long.  We're still fooling around
> with autovacuum and related tuning issues to make it work painlessly...
> 

Should this paragraph be added to the FAQ here?
http://www.postgresql.org/docs/faqs.FAQ.html
В списке pgsql-general по дате отправления
От: Brandon Aiken
Дата:
От: Ron Mayer
Дата:
FAQ