Re: Additional improvements to extended statistics

From: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
To: Daniel Gustafsson <daniel(at)yesql(dot)se>
Cc: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Additional improvements to extended statistics
Date: 2020-07-03 01:10:30
Message-ID: 20200703011030.smzijlphrjjodhxx@development
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Jul 01, 2020 at 01:19:40PM +0200, Daniel Gustafsson wrote:
>> On 24 Mar 2020, at 15:33, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com> wrote:
>>
>> On Tue, Mar 24, 2020 at 01:20:07PM +0000, Dean Rasheed wrote:
>
>>> Sounds like a reasonable approach, but I think it would be better to
>>> preserve the current public API by having clauselist_selectivity()
>>> become a thin wrapper around a new function that optionally applies
>>> extended stats.
>>>
>>
>> OK, makes sense. I'll take a stab at it.
>
>Have you had time to hack on this? The proposed patch no longer applies, so
>I've marked the entry Waiting on Author.

Yep, here's a rebased patch. This does not include the changes we've
discussed with Dean in March, but I plan to address that soon.

regards

--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Attachment Content-Type Size
0001-Improve-estimation-of-OR-clauses-using-exte-20200703.patch text/plain 26.3 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2020-07-03 01:56:51 Re: track_planning causing performance regression
Previous Message Mitar 2020-07-03 00:58:22 Re: Persist MVCC forever - retain history