Re: Add expressions to pg_restore_extended_stats()

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>, Tomas Vondra <tomas(at)vondra(dot)me>
Subject: Re: Add expressions to pg_restore_extended_stats()
Date: 2026-02-09 20:09:49
Message-ID: CADkLM=cTKaT_XwsZznJzj-42WJnq6rFKst_M0kRiV3Q_2_YSZw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, Feb 9, 2026 at 2:59 AM Michael Paquier <michael(at)paquier(dot)xyz> wrote:

> On Mon, Feb 09, 2026 at 02:25:49AM -0500, Corey Huinker wrote:
> > I was thinking of doing exactly that, with a lot of language around how
> > these extra patches don't need to make it into v19. But having said that,
> > they'll probably be pretty small.
>
> Getting the catalog change in would be nice at least, even if the
> expression bits of the restore do not make it in time. Thanks for
> that.
> --
> Michael
>

0001 - the v8 patch, as-is
0002 - minor tweaks to get v8 to build, kept separate to make applying on
top of v8 easier
0003 - Bring back the pg_stats_ext_exprs set difference tests
0004 - Add the 3 range-stats to pg_stats_ext_exprs
0005 - Support importing the 3 range-stats.

Attachment Content-Type Size
v9-0001-Add-support-for-exprs-in-pg_restore_extended_stat.patch text/x-patch 81.7 KB
v9-0002-minor-fixes-for-some-errhints.patch text/x-patch 1.8 KB
v9-0003-Restore-pg_stats_ext_exprs-set-difference-checks.patch text/x-patch 8.5 KB
v9-0004-Add-range-stats-to-pg_stats_ext_exprs.patch text/x-patch 4.6 KB
v9-0005-Add-range-statistics-to-pg_restore_extended_stats.patch text/x-patch 32.0 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2026-02-09 20:16:56 Re: Subquery pull-up increases jointree search space
Previous Message Tom Lane 2026-02-09 20:01:09 Re: ecdh support causes unnecessary roundtrips