Analyze using savepoints?

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Analyze using savepoints?
Date: 2004-08-09 08:44:58
Message-ID: 4117398A.2040504@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message OKADA Satoshi 2004-08-09 08:52:10 PITR - Some data is not recovered.
Previous Message Christopher Kings-Lynne 2004-08-09 08:33:38 Re: Changing the type of timestamp columns