Re: MCV lists for highly skewed distributions

From: Andres Freund <andres(at)anarazel(dot)de>
To: Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>, John Naylor <jcnaylor(at)gmail(dot)com>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: MCV lists for highly skewed distributions
Date: 2018-03-01 21:01:38
Message-ID: 20180301210138.5llbjbm6rjnehzr5@alap3.anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Dean,

On 2018-02-07 15:58:14 +0000, Dean Rasheed wrote:
> On 7 February 2018 at 15:25, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
> > Do you plan to press forward with this, then, or what's
> > the next step?
> >
>
> Yes, I think the results are pretty good so far, especially for the
> more non-uniform distributions. AFAICS it solves the 2 original
> complaints, and I've not yet seen a case where it makes things worse.
>
> I plan to do more testing (and if anyone else wants to, that would be
> most welcome), and then barring any unexpected issues/objections, I'll
> commit it. Probably not this week though.

This sounds like the patch's status of "waiting on author" isn't right,
and it should more be ready for committer?

Greetings,

Andres Freund

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2018-03-01 21:04:56 Re: "failed to find parent tuple for heap-only tuple" error as an ERRCODE_DATA_CORRUPTION ereport()
Previous Message Robert Haas 2018-03-01 21:01:28 Re: [HACKERS] Moving relation extension locks out of heavyweight lock manager