On Sat, 2024-03-02 at 22:29 +, Baziotis, Stefanos wrote:
> Can I maybe get accurate information if the column has an index? In other
> words,
> are there any type of indexes through which I can get the number of distinct
> values or the values themselves, without needing to scan the column?
N
From: Laurenz Albe
Sent: Saturday, March 2, 2024 04:28
To: Baziotis, Stefanos ; pgsql-general@lists.postgresql.org
Subject: Re: Guarantees/Semantics of pg_stats
On Sat, 2024-03-02 at 07:41 +, Baziotis, Stefanos wrote:
> I'm interested in learning more a
On Sat, 2024-03-02 at 07:41 +, Baziotis, Stefanos wrote:
> I'm interested in learning more about the guarantees/semantics of pg_stats.
> For example, is there a guarantee that the n_distinct and most_common_vals
> fields will take into account any values appearing more than M ti
Hi,
I'm interested in learning more about the guarantees/semantics of pg_stats. For
example, is there a guarantee that the n_distinct and most_common_vals fields
will take into account any values appearing more than M times or maybe with
frequence more than f? In what cases will n_distinc
