Alvaro Herrera Munoz <[EMAIL PROTECTED]> writes:
> I think both VACUUM and ANALYZE could be best served by appropiate use
> of short-lived ResourceOwners. It needs some thought though.
At least for VACUUM FULL, this is pretty much a nonstarter: it needs a
real live genuine COMMIT in the middle.
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> 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 chang
On Mon, Aug 09, 2004 at 04:44:58PM +0800, Christopher Kings-Lynne wrote:
> 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
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 b
