On Wed, Nov 13, 2019 at 02:41:14PM +0100, Tomas Vondra wrote:
>On Wed, Nov 13, 2019 at 10:42:32AM +0000, PG Bug reporting form wrote:
>>The following bug has been logged on the website:
>>
>>Bug reference: 16111
>>Logged by: Tuomas Leikola
>>Email address: tuomas.leikola@gmail.com
>>PostgreSQL version: 12.0
>>Operating system: windows, linux
>>Description:
>>
>>I’ve been trying to cook up some kind of online reorganizer, which requires
>>looking at rows’ physical locations and rearranging those that are
>>suboptimal. In this endeavor, I stumbled on what appears to be a compiler
>>bug introduced with multivariate statistics.
>>
>
>Yeah, this is a bug in estimate_multivariate_ndistinct, which fails to
>ignore system attributes :-(
>
>The attached patch fixes it, but unfortunatly we've missed this round of
>minor releases :-( I'll get it pushed in a couple of days.
>
>Thanks for the report and the reproducer, very helpful!
>
I've pushed the fix, after a minor improvement (it wasn't quite right,
because the bitmap was updated again a bit later). Backpatched to 10+.
regards
--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services