Re: First draft of PG 19 release notes - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: First draft of PG 19 release notes
Date
Msg-id af0bZW6qQO-WlTEK@momjian.us
Whole thread
In response to Re: First draft of PG 19 release notes  (Etsuro Fujita <etsuro.fujita@gmail.com>)
List pgsql-hackers
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.



pgsql-hackers by date:

Previous
From: Cary Huang
Date:
Subject: Re: PostgreSQL and OpenSSL 4.0.0
Next
From: Paul A Jungwirth
Date:
Subject: Re: FOR PORTION OF does not recompute GENERATED STORED columns that depend on the range column