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

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема Re: [COMMITTERS] pgsql: Avoid having vacuum set reltuples to 0 on non-empty relations in
Дата
Msg-id 87tw6sayrv.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответ на Re: [COMMITTERS] pgsql: Avoid having vacuum set reltuples to 0 on non-empty relations in  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [COMMITTERS] pgsql: Avoid having vacuum set reltuples to 0 on non-empty relations in  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
Список pgsql-committers
>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:

 Tom> Hm, buildfarm results suggest this test is not entirely stable:

I see it and will work on it.

 Tom> I have not looked very closely, but I'm suspicious that the test
 Tom> case depends on no autovacuum transactions running concurrently
 Tom> with it.  Disabling autovac on the table itself is not enough to
 Tom> control whether global xmin is being held back by some other
 Tom> autovac transaction somewhere.

Aren't vacuum transactions ignored for that? vacuum_set_xid_limits is
certainly passing ignoreVacuum=true to GetOldestXmin.

--
Andrew.


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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: [COMMITTERS] pgsql: Allow plaintext 'password' authentication when user has aSCRAM
Следующее
От: Andrew Gierth
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Avoid having vacuum set reltuples to 0 on non-empty relations in