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-08-12 17:28:14
Message-ID: CADkLM=d_=STa4RHWHk7AGZ1RAZYKMtJxGMsw0Mrdb8s6CHdvbw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Jun 21, 2025 at 8:12 PM Corey Huinker <corey(dot)huinker(at)gmail(dot)com>
wrote:

>
>> 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.
>
>

Rebased. Enjoy.

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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2025-08-12 17:51:15 Re: index prefetching
Previous Message Bruce Momjian 2025-08-12 17:10:57 Re: Parallel Apply