Re: Statistics Import and Export - Mailing list pgsql-hackers

From Corey Huinker
Subject Re: Statistics Import and Export
Date
Msg-id CADkLM=cioQmOFh98qQmqVEkVPjLYszEhZtNtUbmmNAdHOSr3WQ@mail.gmail.com
Whole thread Raw
In response to Re: Statistics Import and Export  (Corey Huinker <corey.huinker@gmail.com>)
Responses Re: Statistics Import and Export
List pgsql-hackers
On Fri, Mar 22, 2024 at 9:51 PM Corey Huinker <corey.huinker@gmail.com> wrote:
v12 attached.


v13 attached. All the same features as v12, but with a lot more type checking, bounds checking, value inspection, etc. Perhaps the most notable feature is that we're now ensuring that histogram values are in ascending order. This could come in handy for detecting when we are applying stats to a column of the wrong type, or the right type but with a different collation. It's not a guarantee of validity, of course, but it would detect egregious changes in sort order.
 
Attachment

pgsql-hackers by date:

Previous
From: Bertrand Drouvot
Date:
Subject: Re: Introduce XID age and inactive timeout based replication slot invalidation
Next
From: Jelte Fennema-Nio
Date:
Subject: Re: session username in default psql prompt?