Re: auto truncate/vacuum full - Mailing list pgsql-general

From Tom Lane
Subject Re: auto truncate/vacuum full
Date
Msg-id 6032.1256676779@sss.pgh.pa.us
Whole thread Raw
In response to Re: auto truncate/vacuum full  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-general
Greg Smith <gsmith@gregsmith.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: auto truncate/vacuum full
Next
From: "Little, Douglas"
Date:
Subject: Re: Pgadmin support for writing files or psql \copy command