Re:PostgreSQL 15: Stats Collector Gone? What’s New?
by inferiorhuman on Sunday August 28, 2022 @11:26PM
(#32634492)
Interesting! Were the queries reliably returning wrong results?
[ Parent
| on HN ]
Re:PostgreSQL 15: Stats Collector Gone? What’s New?
by pilif on Monday August 29, 2022 @04:16AM
(#32635836)
it was in the 2012/2013 time frame, so I can't find the relevant release note any more, but it was reliably returning wrong results for a specific sub query pattern.
Not all of them were broken, but the broken one was returning wrong results 100% of the time.
Index corruption shows the same symptoms, but, of course, it is a different cause.