Re: Multivariate MCV list vs. statistics target

From: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
To: "Shinoda, Noriyoshi (PN Japan A&PS Delivery)" <noriyoshi(dot)shinoda(at)hpe(dot)com>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, "Jamison, Kirk" <k(dot)jamison(at)jp(dot)fujitsu(dot)com>, Dean Rasheed <dean(dot)a(dot)rasheed(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Multivariate MCV list vs. statistics target
Date: 2020-03-18 15:53:26
Message-ID: 20200318155326.h2umvzrdu4qnzgji@development
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Mar 18, 2020 at 01:32:19PM +0000, Shinoda, Noriyoshi (PN Japan
A&PS Delivery) wrote:
>Hi,
>
>>Thanks for the report. Yes, this is clearly an omission. I think it
>>would be better to use wording >similar to attstattarget, per the
>>attached patch. That is, without reference to ALTER STATISTICS and
>>>better explaination of what positive/negative values do. Do you
>>>agree?
>
>Thank you for your comment. I agree with the text you suggested.
>

Thank you for the report, I've pushed the reworded fix.

regards

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2020-03-18 15:55:43 Re: PATCH: add support for IN and @> in functional-dependency statistics use
Previous Message Peter Eisentraut 2020-03-18 15:46:23 potential stuck lock in SaveSlotToPath()