Re: auto truncate/vacuum full

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: auto truncate/vacuum full
Дата
Msg-id 6032.1256676779@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: auto truncate/vacuum full  (Greg Smith <gsmith@gregsmith.com>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: auto truncate/vacuum full
Следующее
От: "Little, Douglas"
Дата:
Сообщение: Re: Pgadmin support for writing files or psql \copy command