Horton

Re: pgsql: Support partition pruning at execution time

Andrew Gierth <andrew@tao11.riddles.org.uk>

View thread View on postgr.es
From: Andrew Gierth <andrew@tao11.riddles.org.uk>
To: David Rowley <david.rowley@2ndquadrant.com>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>, Tom Lane <tgl@sss.pgh.pa.us>, pgsql-committers@lists.postgresql.org
Date: 2018-04-08T03:21:10Z
Lists: pgsql-hackers 
>>>>> "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)

Commits

  1. Update Append's idea of first_partial_plan

  2. Fix IndexOnlyScan counter for heap fetches in parallel mode

  3. Fix incorrect logic for choosing the next Parallel Append subplan

  4. Minor comment updates

  5. Attempt to stabilize partition_prune test output.

  6. Support partition pruning at execution time