Horton

Thread

  1. Re: First draft of PG 19 release notes

    Bruce Momjian <bruce@momjian.us> — 2026-05-07T23:08:21Z

    On Tue, Apr 21, 2026 at 05:24:59AM -0700, Etsuro Fujita wrote:
> On Wed, Apr 15, 2026 at 10:19 AM Bruce Momjian <bruce@momjian.us> wrote:
> > I have completed the first draft of the PG 19 release notes:
> >
> >         https://www.postgresql.org/docs/devel/release-19.html
> 
> Thank you!
> 
> "Allow the retrieval of statistics from foreign data wrapper servers
> (Corey Huinker, Etsuro Fujita)"
> 
> This is mentioned in the Additional Modules section, presumably
> because it was supported in postgres_fdw, but it isn't limited to
> postgres_fdw, so we should move it to the General Performance section?

Well, the full text is:

	Allow the retrieval of statistics from foreign data wrapper servers
	(Corey Huinker, Etsuro Fujita) §
	
	This is enabled for postgres_fdw by using the option restore_stats. The
	default is for ANALYZE to retrieve rows from the remote server to
	locally generate statistics.

It clearly mentions in the detail that it applies only to postgres_fdw,
so I think it is already in the right section.  While it technically can
be done by any FDW, it is now only postgres_fdw so people looking for
postgres_fdw improvements will find it in the Additional Modules
section.  What we can do is to reword it to:

-->	Allow the retrieval of statistics from postgres_fdw foreign data wrapper servers
	(Corey Huinker, Etsuro Fujita) §
	
-->	This is enabled by using the option restore_stats. The
	default is for ANALYZE to retrieve rows from the remote server to
	locally generate statistics.

but I think this is worse because it sounds like it can _only_ ever be
done by postgres_fdw.  However, if you prefer this I will make this
change.

I avoided "General Performance" because frankly, it is only
postgres_fdw, and it not a "General" performance improvement, and we
have a section for postgres_fdw already.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Do not let urgent matters crowd out time for investment in the future.