Horton
Menu

Re: BUG #18885: ERROR: corrupt MVNDistinct entry - 2

David Rowley <dgrowleyml@gmail.com>

View thread
From: David Rowley <dgrowleyml@gmail.com>
To: Tomas Vondra <tomas@vondra.me>
Cc: Andrei Lepikhov <lepihov@gmail.com>, tharakan@gmail.com, pgsql-bugs@lists.postgresql.org, Alexander Korotkov <aekorotkov@gmail.com>
Date: 2025-04-21T12:11:08Z
Lists: pgsql-bugs 
On Mon, 21 Apr 2025 at 21:41, Tomas Vondra <tomas@vondra.me> wrote:
> Yeah, you're right the estimate_multivariate_ndistinct() comments should
> have mentioned that the GroupVarInfos are expected to be unique ... and
> perhaps there could have been some assert to check that.

I did the comments in f3281f9f9.

David

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Properly prepare varinfos in estimate_multivariate_bucketsize()

  2. Improve comments for estimate_multivariate_ndistinct()

  3. Use extended stats for precise estimation of bucket size in hash join

  4. Ignore nullingrels when looking up statistics