Re: Allow pg_dump --statistics-only to dump foreign table statistics? - Mailing list pgsql-hackers

From Daniel Gustafsson
Subject Re: Allow pg_dump --statistics-only to dump foreign table statistics?
Date
Msg-id BE247745-033C-49C4-A5F0-9119657B0E38@yesql.se
Whole thread Raw
Responses Re: Allow pg_dump --statistics-only to dump foreign table statistics?
List pgsql-hackers
> On 13 Jun 2025, at 09:19, Fujii Masao <masao.fujii@oss.nttdata.com> wrote:

> I noticed that pg_restore_relation|attribute_stats() can restore statistics
> for foreign tables, but pg_dump --statistics-only doesn't include them.
> Is there a reason why pg_dump skips statistics for foreign tables?
> Are there any risks or concerns around including them?

That indeed seems like an oversight, and regardless it's unclear to the user
what actually happens.  Question is, since we don't know what's on the other
end do we need a corresponding option to --include-foreign-data to be able to
be selective with statistics?

--
Daniel Gustafsson




pgsql-hackers by date:

Previous
From: Richard Guo
Date:
Subject: Re: Eager aggregation, take 3
Next
From: Vaibhav Dalvi
Date:
Subject: pg_upgrade fails with an error "object doesn't exist"