Quick Links

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

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	pgsql-hackers(at)postgresql(dot)org
Cc:	Andreas Joseph Krogh <andreas(at)visena(dot)com>
Subject:	Re: Bogus ANALYZE results for an otherwise-unique column with many nulls
Date:	2016-08-04 23:01:06
Message-ID:	18487.1470351666@sss.pgh.pa.us
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-hackers

I wrote:
> Looking around, there are a couple of places outside commands/analyze.c
> that are making the same mistake, so this patch isn't complete, but it
> illustrates what needs to be done.

Here's a more complete patch.

regards, tom lane

Attachment	Content-Type	Size
analyze-unique-with-nulls-2.patch	text/x-diff	6.6 KB

In response to

Bogus ANALYZE results for an otherwise-unique column with many nulls at 2016-08-04 22:39:31 from Tom Lane

Responses

Re: Bogus ANALYZE results for an otherwise-unique column with many nulls at 2016-08-05 09:43:04 from Andreas Joseph Krogh

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Peter Geoghegan	2016-08-04 23:09:17	Re: Possible duplicate release of buffer lock.
Previous Message	Bruce Momjian	2016-08-04 22:41:23	Re: Heap WARM Tuples - Design Draft