| From: | Corey Huinker <corey(dot)huinker(at)gmail(dot)com> |
|---|---|
| To: | Jeff Davis <pgsql(at)j-davis(dot)com> |
| Cc: | Stephen Frost <sfrost(at)snowman(dot)net>, Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>, Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>, Peter Smith <smithpb2250(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Tomas Vondra <tomas(dot)vondra(at)enterprisedb(dot)com> |
| Subject: | Re: Statistics Import and Export |
| Date: | 2024-03-25 08:27:38 |
| Message-ID: | CADkLM=cioQmOFh98qQmqVEkVPjLYszEhZtNtUbmmNAdHOSr3WQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, Mar 22, 2024 at 9:51 PM Corey Huinker <corey(dot)huinker(at)gmail(dot)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 | Content-Type | Size |
|---|---|---|
| v13-0001-Create-pg_set_relation_stats-pg_set_attribute_st.patch | text/x-patch | 119.9 KB |
| v13-0002-Enable-dumping-of-table-index-stats-in-pg_dump.patch | text/x-patch | 21.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jelte Fennema-Nio | 2024-03-25 08:30:14 | Re: session username in default psql prompt? |
| Previous Message | Bertrand Drouvot | 2024-03-25 08:07:35 | Re: Introduce XID age and inactive timeout based replication slot invalidation |