Re: improving GROUP BY estimation - Mailing list pgsql-hackers

From Dean Rasheed
Subject Re: improving GROUP BY estimation
Date
Msg-id CAEZATCVkTeN6fLvhcp=0EeKK091NCyOcO1mh9Znnk5GQp=N1+w@mail.gmail.com
Whole thread Raw
In response to Re: improving GROUP BY estimation  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: improving GROUP BY estimation  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On 31 March 2016 at 22:02, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> I'm just concerned about what happens when the Dellera paper stops being
> available.  I don't mind including that URL as a backup to the written-out
> argument I just suggested.
>

Here's an updated patch with references to both papers, and a more
detailed justification for the formula, along with the other changes
discussed. Note that although equation (2) in the Dell'Era paper looks
different from the Yao formula, it's actually the same.

Regards,
Dean

Attachment

pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: Performance improvement for joins where outer side is unique
Next
From: Michael Paquier
Date:
Subject: Re: [PATCH v11] GSSAPI encryption support