Analyze using savepoints?

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Analyze using savepoints?
Дата
Msg-id 4117398A.2040504@familyhealth.com.au
обсуждение исходный текст
Ответы Re: Analyze using savepoints?
Re: Analyze using savepoints?
Список pgsql-hackers
I read this in the release notes:

---
# Database-wide ANALYZE does not hold locks across tables (Tom)

This reduces the potential for deadlocks against other backends that 
want exclusive locks on tables. To get the benefit of this change, do 
not execute database-wide ANALYZE inside a transaction block (BEGIN 
block); it must be able to commit and start a new transaction for each 
table.
---

Does that mean that now if we used savepoints internally, analyze can 
still be run in a transaction and still not hold lots of locks?

Chris



В списке pgsql-hackers по дате отправления: