| From: | Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> |
|---|---|
| To: | Bruce Momjian <bruce(at)momjian(dot)us> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: First draft of PG 19 release notes |
| Date: | 2026-05-09 09:15:44 |
| Message-ID: | CAPmGK14cVrOBOQLDTLHikzi_xoHpSCpV=tMBa2C9xz7TmO_Y2g@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, May 8, 2026 at 8:08 AM Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> On Tue, Apr 21, 2026 at 05:24:59AM -0700, Etsuro Fujita wrote:
> > "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.
Agreed. I think the current text is fine.
Thank you for your detailed reply!
Best regards,
Etsuro Fujita
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2026-05-09 09:28:51 | Re: Parallel INSERT SELECT take 2 |
| Previous Message | Zhongpu Chen | 2026-05-09 08:58:09 | Re: Proposal: tighten validation for legacy EUC encodings or document that accepted byte sequences may be unconvertible to UTF8 |