public inbox for [email protected]  
help / color / mirror / Atom feed
From: Tom Lane <[email protected]>
To: Matt Long <[email protected]>
Cc: Mark Frost <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column
Date: Fri, 19 Sep 2025 15:23:22 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAB2=oSHPNvOREdoPnTTbNeiPHWK7WpPZTX+xKZtUj_+D7+C7Ow@mail.gmail.com>
References: <PH3PPF1C905D6E6F24A5C1A1A1D8345B593E16FA@PH3PPF1C905D6E6.namprd15.prod.outlook.com>
	<[email protected]>
	<PH3PPF1C905D6E61EEB89CF46C1F572D402E16EA@PH3PPF1C905D6E6.namprd15.prod.outlook.com>
	<[email protected]>
	<[email protected]>
	<CAB2=oSHo0cjK-BktYgFL-mDHCov125my4XhvQRJzZo2VBBz=eA@mail.gmail.com>
	<[email protected]>
	<[email protected]>
	<CAB2=oSHPNvOREdoPnTTbNeiPHWK7WpPZTX+xKZtUj_+D7+C7Ow@mail.gmail.com>

Matt Long <[email protected]> writes:
> I finally got around to testing your patch on a realistic data set. In
> short, the patch worked beautifully even with the division by 2 removed. In
> case it's helpful, the full write up of my investigation can be found at
> https://gist.github.com/mattlong/0617bec6e1cf5bc6b70c6c2951901df7

Thank you!  I'm now inclined to keep the divisions by 2 (with comment
fixes).

			regards, tom lane





view thread (13+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox