Re: [COMMITTERS] pgsql: Avoid having vacuum set reltuples to 0 onnon-empty relations in

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: [COMMITTERS] pgsql: Avoid having vacuum set reltuples to 0 onnon-empty relations in
Дата
Msg-id 20170317034427.2bpbaii6riswpiwk@alap3.anarazel.de
обсуждение исходный текст
Ответ на Re: [COMMITTERS] pgsql: Avoid having vacuum set reltuples to 0 on non-empty relations in  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-committers
On 2017-03-16 23:37:06 -0400, Tom Lane wrote:
> Andrew Gierth <rhodiumtoad@postgresql.org> writes:
> > Avoid having vacuum set reltuples to 0 on non-empty relations in the
> > presence of page pins, which leads to serious estimation errors in the
> > planner.
>
> Hm, buildfarm results suggest this test is not entirely stable:
>
> https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=crake&dt=2017-03-17%2000%3A47%3A57
>
> I have not looked very closely, but I'm suspicious that the test case
> depends on no autovacuum transactions running concurrently with it.
> Disabling autovac on the table itself is not enough to control whether
> global xmin is being held back by some other autovac transaction
> somewhere.

Yea, brought it up on IRC too - he's gone for the night (Europe).  I
suspect changing things > might do the trick.

- Andres


В списке pgsql-committers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Avoid having vacuum set reltuples to 0 on non-empty relations in
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: [COMMITTERS] pgsql: Fix and simplify check for whether we're running as Windowsserv