Re: pgsql: Support partition pruning at execution time - Mailing list pgsql-committers

From Andrew Gierth
Subject Re: pgsql: Support partition pruning at execution time
Date
Msg-id 87a7ueidzv.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to Re: pgsql: Support partition pruning at execution time  (David Rowley <david.rowley@2ndquadrant.com>)
Responses Re: pgsql: Support partition pruning at execution time  (David Rowley <david.rowley@2ndquadrant.com>)
List 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 by date:

Previous
From: Andrey Borodin
Date:
Subject: Re: pgsql: Indexes with INCLUDE columns and their support in B-tree
Next
From: David Rowley
Date:
Subject: Re: pgsql: Support partition pruning at execution time