On Fri, Jun 13, 2025 at 1:19 PM Daniel Gustafsson <dan...@yesql.se> wrote: > > > On 13 Jun 2025, at 09:19, Fujii Masao <masao.fu...@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?
We include only statistics and no data for regular tables. Shouldn't we do the same to the foreign tables? -- Best Wishes, Ashutosh Bapat
