Re: Declarative partitioning optimization for large amountof partitions - Mailing list pgsql-hackers

From Aleksander Alekseev
Subject Re: Declarative partitioning optimization for large amountof partitions
Date
Msg-id 20170324151801.GC16830@e733.localdomain
Whole thread Raw
In response to Re: Declarative partitioning optimization for large amountof partitions  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
Hi Simon,

> > I don't know which way you're thinking of fixing this, but a planner patch
> > to implement faster partition-pruning will have taken care of this, I
> > think.  As you may know, even declarative partitioned tables currently
> > depend on constraint exclusion for partition-pruning and planner's current
> > approach of handling inheritance requires to open all the child tables
> > (partitions), whereas the new approach hopefully shouldn't need to do
> > that.  I am not sure if looking for a more localized fix for this would be
> > worthwhile, although I may be wrong.
>
> What "new approach" are we discussing?
> Is there a patch or design discussion?

I think what was meant was plans of my colleague Dmitry Ivanov to
implement partition-pruning. I've just spoke with Dmitry about this
matter. Unless there is anyone else who is already working on this
optimization we would like to work on it together. Unfortunately there
is no patch or design discussion of partition-pruning on this
commitfest.

--
Best regards,
Aleksander Alekseev

pgsql-hackers by date:

Previous
From: David Steele
Date:
Subject: Re: LWLock optimization for multicore Power machines
Next
From: David Steele
Date:
Subject: Re: PATCH: Batch/pipelining support for libpq