| From: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> |
|---|---|
| To: | Thomas Reiss <thomas(dot)reiss(at)dalibo(dot)com> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Performance regression with PostgreSQL 11 and partitioning |
| Date: | 2018-05-30 03:01:02 |
| Message-ID: | CAKJS1f_2=68RdOJVBdBJDdyizrYjQy+SM_vHL2unkszbGcmt3Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 26 May 2018 at 02:30, Thomas Reiss <thomas(dot)reiss(at)dalibo(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Charles Cui | 2018-05-30 04:42:11 | [GSoC] json helper functions |
| Previous Message | Michael Paquier | 2018-05-30 02:48:20 | Re: Supporting tls-server-end-point as SCRAM channel binding for OpenSSL 1.0.0 and 1.0.1 |