| From: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Performance improvement for joins where outer side is unique |
| Date: | 2016-04-02 12:14:59 |
| Message-ID: | CAKJS1f_TwwnJoXFgmwY39L81u9e6HiRuO1dnnCy2EFuHLaeYCQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 2 April 2016 at 23:26, David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> wrote:
> I worked on this today to try and get it into shape.
In the last patch I failed to notice that there's an alternative
expected results file for one of the regression tests.
The attached patch includes the fix to update that file to match the
new expected EXPLAIN output.
--
David Rowley http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| Attachment | Content-Type | Size |
|---|---|---|
| unique_joins_57837dc_2016-04-03.patch | application/octet-stream | 62.6 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dean Rasheed | 2016-04-02 12:20:13 | Re: improving GROUP BY estimation |
| Previous Message | Michael Paquier | 2016-04-02 12:12:47 | Re: snapshot too old, configured by time |