Re: cost-based vacuum

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Ian Westmacott <ianw(at)intellivid(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: cost-based vacuum
Date: 2005-07-11 13:28:52
Message-ID: 7752.1121088532@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Simon Riggs <simon(at)2ndquadrant(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Huxton 2005-07-11 13:29:07 Re: Question
Previous Message Ian Westmacott 2005-07-11 13:07:46 Re: cost-based vacuum