Re: extended statistics n-distinct on multiple columns not used when join two tables

From: David Rowley <dgrowleyml(at)gmail(dot)com>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, "James Pang (chaolpan)" <chaolpan(at)cisco(dot)com>
Subject: Re: extended statistics n-distinct on multiple columns not used when join two tables
Date: 2023-06-22 00:53:10
Message-ID: CAApHDvqTowv0qNzgTx8v4u6SEJpvqaB9LaLhF3=-Dx4mxPsX+g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

On Tue, 13 Jun 2023 at 23:29, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:
>> I think it's probably worth adjusting the docs to mention this. It
>> seems like it might be something that could surprise someone.
>>
>> Something like the attached, maybe?
>
> +1

Ok, I pushed that patch. Thanks.

David

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Hayato Kuroda (Fujitsu) 2023-06-22 01:36:47 [Patch] Use *other* indexes on the subscriber when REPLICA IDENTITY is FULL
Previous Message Kirk Wolak 2023-06-22 00:52:32 Re: Adding SHOW CREATE TABLE

Browse pgsql-performance by date

  From Date Subject
Next Message Patrick O'Toole 2023-06-25 06:29:00 Fwd: Helping planner to chose sequential scan when it improves performance
Previous Message Tomas Vondra 2023-06-20 12:45:30 Re: Merge David and Goliath tables efficiently