Concurrent VACUUM and ANALYZE
От | Jonah H. Harris |
---|---|
Тема | Concurrent VACUUM and ANALYZE |
Дата | |
Msg-id | 36e682920807211450t26aefefap64107e30dc123f2b@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Concurrent VACUUM and ANALYZE
Re: Concurrent VACUUM and ANALYZE Re: Concurrent VACUUM and ANALYZE |
Список | pgsql-hackers |
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. After performing a quick cursory investigation on this, it doesn't appear to be difficult to change. Other than the ShareUpdateExclusiveLock, is there anything technically preventing us from performing both concurrently? Because we wouldn't want multiple ANALYZEs running on the same table, changing the lock back to an AccessShareLock doesn't sound like a solution. However, what are the thoughts around creating another, more-specific lock? Perhaps something like ShareUpdateAnalysisLock? Any other suggestions? -Jonah
В списке pgsql-hackers по дате отправления: