Re: Concurrent VACUUM and ANALYZE
| От | Simon Riggs |
|---|---|
| Тема | Re: Concurrent VACUUM and ANALYZE |
| Дата | |
| Msg-id | 1216904794.3894.824.camel@ebony.2ndQuadrant обсуждение исходный текст |
| Ответ на | Concurrent VACUUM and ANALYZE ("Jonah H. Harris" <jonah.harris@gmail.com>) |
| Ответы |
Re: Concurrent VACUUM and ANALYZE
|
| Список | pgsql-hackers |
On Mon, 2008-07-21 at 17:50 -0400, Jonah H. Harris wrote: > Currently, one cannot perform a concurrent VACUUM and ANALYZE. This > is a significant problem for tables which are not only large and have > designated cost-delays, but which are also heavily inserted into and > deleted from. I suspect this is not the root problem, but one solution to it. If the stats need such frequent updating, then the code that handles the stats probably needs extension/improvement to avoid such sensitivities. -- Simon Riggs www.2ndQuadrant.comPostgreSQL Training, Services and Support
В списке pgsql-hackers по дате отправления: