Re: Bogus ANALYZE results for an otherwise-unique column with many nulls

From: Andreas Joseph Krogh <andreas(at)visena(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Bogus ANALYZE results for an otherwise-unique column with many nulls
Date: 2016-08-07 08:16:45
Message-ID: VisenaEmail.73.5dca3a2cff447283.15664125425@tc7-visena
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

På søndag 07. august 2016 kl. 09:01:40, skrev Dean Rasheed <
dean(dot)a(dot)rasheed(at)gmail(dot)com <mailto:dean(dot)a(dot)rasheed(at)gmail(dot)com>>:
On 5 August 2016 at 21:48, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> OK, thanks.  What shall we do about Andreas' request to back-patch this?
> I'm personally willing to do it, but there is the old bugaboo of "maybe
> it will destabilize a plan that someone is happy with".
>

My inclination would be to back-patch it because arguably it's a
bug-fix -- at the very least the old behaviour didn't match the docs
for stadistinct:
[snip]
 
 
Will this then make it into the soon-to-be-released 9.5.4?
 
-- Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>

 

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2016-08-07 09:15:22 patch: xmltable - proof concept
Previous Message Dean Rasheed 2016-08-07 07:01:40 Re: Bogus ANALYZE results for an otherwise-unique column with many nulls