Re: [PG19] pg_dump --statistics restores extended statistics by attribute number

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: shihao zhong <zhong950419(at)gmail(dot)com>
Cc: Corey Huinker <corey(dot)huinker(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, tomas(at)vondra(dot)me
Subject: Re: [PG19] pg_dump --statistics restores extended statistics by attribute number
Date: 2026-10-18 23:43:04
Message-ID: atVZiIcK1nnu_0xS@paquier.xyz
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Oct 15, 2026 at 11:05:06PM -0400, shihao zhong wrote:
> After a restore the stats of z land on a, with no warning. A list of
> tables with dropped columns does not find it.

Yeah, due to the numbering of the columns. I doubt that this is
something that would happen in practice, still pointing out to the
fact that we've never been good at mapping across dumps and restore
and what should be a logical vs a physical attnum.

> Michael, is v2 the rejection you meant, or is the warning we get today
> enough?

I mean that there is nothing that I see worth acting on here.
--
Michael

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message shihao zhong 2026-10-19 00:06:04 Re: [PG19] pg_dump --statistics restores extended statistics by attribute number
Previous Message Michael Paquier 2026-10-18 22:37:36 Re: Revert libpq servicefile connection option in v19 (info leak and uninterruptible backend DoS)