Re: High Availability and Replication

2024-03-02 Thread Abdul Sayeed
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

Re: Guarantees/Semantics of pg_stats

2024-03-02 Thread Laurenz Albe
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

Re: Content for talk on Postgres Type System at PostgresConf

2024-03-02 Thread Laurenz Albe
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

Re: Content for talk on Postgres Type System at PostgresConf

2024-03-02 Thread grimy . outshine830
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

Re: Guarantees/Semantics of pg_stats

2024-03-02 Thread Baziotis, Stefanos
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

Thoughts on user-defined types for talk at Postgres conference?

2024-03-02 Thread Guyren Howe
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