Re: cost-based vacuum - Mailing list pgsql-performance

From Tom Lane
Subject Re: cost-based vacuum
Date
Msg-id 7752.1121088532@sss.pgh.pa.us
Whole thread Raw
In response to Re: cost-based vacuum  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-performance
Simon Riggs <simon@2ndquadrant.com> writes:
>> I don't understand why this would be.  I don't think there
>> are any lock issues, and I don't see any obvious I/O issues.

> The ANALYZE commands hold read locks on the tables you wish to write to.

Unless there were more commands that Ian didn't show us, he's not taking
any locks that would conflict with ANALYZE.  So I don't believe this is
the explanation.

            regards, tom lane

pgsql-performance by date:

Previous
From: Ian Westmacott
Date:
Subject: Re: cost-based vacuum
Next
From: Richard Huxton
Date:
Subject: Re: Question