Horton

Re: pgsql: Support partition pruning at execution time

Alvaro Herrera <alvherre@alvh.no-ip.org>

View thread View on postgr.es
From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Andrew Gierth <andrew@tao11.riddles.org.uk>
Cc: David Rowley <david.rowley@2ndquadrant.com>, Tom Lane <tgl@sss.pgh.pa.us>, pgsql-committers@lists.postgresql.org
Date: 2018-04-08T06:37:34Z
Lists: pgsql-hackers 
Andrew Gierth wrote:
> >>>>> "David" == David Rowley <david.rowley@2ndquadrant.com> writes:
> 
>  David> I've attached my proposed fix for the unstable regression tests.
>  David> I removed the vacuums I'd added in the last version and
>  David> commented why we're doing set enable_indesonlyscan = off;
> 
> Looks basically sane - I'll try it out and commit it shortly.

Thanks for cleaning that up.  I'll look into why the test (without this
commit) fails with force_parallel_mode=regress next week.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

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