Greg Smith <gsmith(at)gregsmith(dot)com> writes:
> On Tue, 27 Oct 2009, Tom Lane wrote:
>> The issue I can see is that we might never be able to complete any
>> truncation if there's a lot of potentially removable pages and a pretty
>> steady flow of conflicting lock attempts. But that would result in
>> failure to remove bloat, not stoppage of conflicting queries.
> That's exactly it.
That might be exactly what's worrying *you*, but my point was that it
doesn't appear to explain the OP's complaint. Whatever issue he has
got is something else.
regards, tom lane
In response to
pgsql-general by date
|Next:||From: Little, Douglas||Date: 2009-10-27 21:31:40|
|Subject: Re: Pgadmin support for writing files or psql \copy command|
|Previous:||From: Tom Lane||Date: 2009-10-27 20:47:53|
|Subject: Re: auto truncate/vacuum full |