Hi,
Not required.
Thanks & Regards,
Abdul Sayeed
PostgreSQL DBA
Postgres Professional Certified
Skype: abdul.sayeed24
On Sat, 2 Mar 2024 at 12:21 PM, normandavis1990
wrote:
> > On Saturday, March 2nd, 2024 at 1:24 AM, Abdul Sayeed <
> abdulsayee...@gmail.com> wrote:
>
> Hi,
>
> When Master
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 times or
> maybe w
On Fri, 2024-03-01 at 08:14 -0800, Adrian Klaver wrote:
> [pointers to the documentation]
I know. I was not searching for help with PostgreSQL,
I was trying to point out the surprising behavior of
"character" as a suggestion for the talk.
Yours,
Laurenz Albe
On Fri, Mar 01, 2024 at 03:25:35PM -0500, Tom Lane wrote:
> No, what he showed was correct. I'm talking about a different facet
> of the problem:
> ...
> Even if that took account of the exchange rate, it'd not be great.
> But it doesn't; it's just the same digits reinterpreted with a new
> cur
Hi Laurenz,
Thanks for replying. I see. 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?
Best,
Stefanos
I am doing a talk at Postgres Conf about Postgres’s type system. I already
asked about this and got some great responses:
https://www.postgresql.org/message-id/flat/b82f8886db61a3395e6eab94981258274cdbacd3.camel%40cybertec.at#f13288b72bd2d564ee758c1a273652ad
Those responses discussed mostly gotc