Analyze using savepoints?

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Analyze using savepoints?
Дата
Msg-id 4117398A.2040504@familyhealth.com.au
обсуждение исходный текст
Ответы Re: Analyze using savepoints?  (Alvaro Herrera Munoz <alvherre@dcc.uchile.cl>)
Re: Analyze using savepoints?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Changing the type of timestamp columns
Следующее
От: OKADA Satoshi
Дата:
Сообщение: PITR - Some data is not recovered.