Analyze using savepoints? - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Analyze using savepoints?
Date
Msg-id 4117398A.2040504@familyhealth.com.au
Whole thread Raw
Responses Re: Analyze using savepoints?  (Alvaro Herrera Munoz <alvherre@dcc.uchile.cl>)
Re: Analyze using savepoints?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: Re: Changing the type of timestamp columns
Next
From: OKADA Satoshi
Date:
Subject: PITR - Some data is not recovered.