Re: Performance regression with PostgreSQL 11 and partitioning

On 26 May 2018 at 02:30, Thomas Reiss <thomas.reiss@dalibo.com> wrote:
> I spent some time to test the new features on partitioning with the
> beta1. I noticed a potentially huge performance regression with
> plan-time partition pruning.

Thanks for reporting. I've added this item to the PG11 open items list in:

https://wiki.postgresql.org/wiki/PostgreSQL_11_Open_Items#Open_Issues

I've placed it there so that it does not get forgotten about. It's
still to be decided if we can come up with something low-risk enough
that will resolve the issue.

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services