Re: pgsql: Support partition pruning at execution time

Поиск
Список
Период
Сортировка
От Andrew Gierth
Тема Re: pgsql: Support partition pruning at execution time
Дата
Msg-id 87a7ueidzv.fsf@news-spur.riddles.org.uk
обсуждение исходный текст
Ответ на Re: pgsql: Support partition pruning at execution time  (David Rowley <david.rowley@2ndquadrant.com>)
Ответы Re: pgsql: Support partition pruning at execution time  (David Rowley <david.rowley@2ndquadrant.com>)
Список pgsql-committers
>>>>> "David" == David Rowley <david.rowley@2ndquadrant.com> writes:

 >> It happens 12 or 13 times on my machine, then does not happen again
 >> for 60 seconds, then happens again.

 David> Setting autovacuum_naptime to 10 seconds makes it occur in 10
 David> second intervals...

Analyze (including auto-analyze on a different table entirely) has a
snapshot, which can hold back OldestXmin, hence preventing the
all-visible flag from being set.

-- 
Andrew (irc:RhodiumToad)


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

Предыдущее
От: Andrey Borodin
Дата:
Сообщение: Re: pgsql: Indexes with INCLUDE columns and their support in B-tree
Следующее
От: David Rowley
Дата:
Сообщение: Re: pgsql: Support partition pruning at execution time