Re: Extended Statistics set/restore/clear functions.

From: Corey Huinker <corey(dot)huinker(at)gmail(dot)com>
To: jian he <jian(dot)universality(at)gmail(dot)com>
Cc: Tomas Vondra <tomas(at)vondra(dot)me>, pgsql-hackers(at)lists(dot)postgresql(dot)org, tgl(at)sss(dot)pgh(dot)pa(dot)us
Subject: Re: Extended Statistics set/restore/clear functions.
Date: 2025-06-22 00:12:28
Message-ID: CADkLM=daHJhUf-sO1iD=UTaymbBVEgEW4Sxm8PtHWWDEGWW9jQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>
>
> Any thoughts on using/improving these structures?
>

Hearing no objections, here is the latest patchset.

0001 - Changes input/output functions of pg_ndistinct to the format
described earlier.
0002 - Changes input/output functions of pg_dependencies to the format
described earlier.
0003 - Makes some previously internal/static attribute stats functions
visible to extended_stats.c, because the exprs attribute is basically an
array of partially filled-out pg_statistic rows.
0004 - Adds pg_restore_attribute_stats(), pg_clear_attribute_stats(), in
the pattern of their relation/attribute brethren.
0005 - adds the dumping and restoring of extended statistics back to v10.
No command line flag changes needed.

Attachment Content-Type Size
v4-0001-Refactor-output-format-of-pg_ndistinct-and-add-wo.patch text/x-patch 23.2 KB
v4-0002-Refactor-output-format-of-pg_dependencies-and-add.patch text/x-patch 22.2 KB
v4-0003-Expose-attribute-statistics-functions-for-use-in-.patch text/x-patch 4.7 KB
v4-0004-Add-extended-statistics-support-functions.patch text/x-patch 111.7 KB
v4-0005-Include-Extended-Statistics-in-pg_dump.patch text/x-patch 12.8 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alexander Korotkov 2025-06-22 00:20:23 Re: Slot's restart_lsn may point to removed WAL segment after hard restart unexpectedly
Previous Message Arseniy Mukhin 2025-06-21 21:55:31 Re: amcheck support for BRIN indexes