Re: Extended Statistics set/restore/clear functions.

From: Corey Huinker <corey(dot)huinker(at)gmail(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: Chao Li <li(dot)evan(dot)chao(at)gmail(dot)com>, Tender Wang <tndrwang(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Extended Statistics set/restore/clear functions.
Date: 2026-01-25 10:20:13
Message-ID: CADkLM=c7DY3Jv6ef0n_MGUJ1FyTMUoT697LbkST05nraVGNHYg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Jan 24, 2026 at 9:35 PM Michael Paquier <michael(at)paquier(dot)xyz> wrote:

> On Sat, Jan 24, 2026 at 09:19:30PM -0500, Corey Huinker wrote:
> > Expressions would be a 4th patch, and honestly it's the lion's share of
> the
> > code.
>
> I was under the impression that this was a strong dependency. If that
> can be split out of the rest, well better for us then.

Ok, here's my attempt at splitting things out:

0001 - Add attribute stats test for multiranges
0002 - Basic restore functionality ndistinct
0003 - add dependencies
0004 - add mcv
0005 - add expressions
0006 - Add in the before/after diff test on a stats object (in theory this
could be added after 0002)
0007 - add SGML
0008 - restore MAINTAIN test (in theory this could be merged into 0002)
0009 - pg_dump

Attachment Content-Type Size
v31-0004-Add-mcv-support-to-pg_restore_extended_stats.patch text/x-patch 45.3 KB
v31-0001-Add-pg_restore_attribute_stats-test-for-multiran.patch text/x-patch 3.6 KB
v31-0003-Add-dependencies-support-to-pg_restore_extended_.patch text/x-patch 8.4 KB
v31-0002-Add-pg_restore_extended_stats.patch text/x-patch 22.7 KB
v31-0005-Add-expressions-support-to-pg_restore_extended_s.patch text/x-patch 43.9 KB
v31-0007-Add-documentation-for-pg_restore_extended_stats.patch text/x-patch 5.5 KB
v31-0006-Add-comprehensive-copy-test-for-extended-stats.patch text/x-patch 12.2 KB
v31-0008-Add-privs-tests-for-pg_restore_extended_stats.patch text/x-patch 5.3 KB
v31-0009-Include-Extended-Statistics-in-pg_dump.patch text/x-patch 14.0 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2026-01-25 10:34:38 Re: alignas (C11)
Previous Message David Rowley 2026-01-25 10:14:57 Re: Fix a reference error for window functions: In the function 'find_window_functions', the deduplication logic should be removed