| From: | Corey Huinker <corey(dot)huinker(at)gmail(dot)com> |
|---|---|
| To: | Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com> |
| Cc: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Several issues with postgres_fdw stats import |
| Date: | 2026-09-11 20:53:24 |
| Message-ID: | CADkLM=dasZ_3bsHX-VFtWuRP1z=z-CT5gifaPHawZ_p19=7Ujw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
>
>
> No, it won't fall back; the syntax error on the remote server will
> lead to an error on the local server, actually. That isn't great, so
> I modified postgres_fdw to do the fallback. Patch attached.
>
My mistake. The patch looks good. Clearly there's no sufficiently venerable
buildfarm animal that could have detected this, or else we would have found
it sooner, and it's hard to justify supporting it if we cant test it.
>
> > The obvious counter-example are databases that are forks of postgres
> from the 8.x era (Vertica, Redshift), neither of which have a pg_stats
> view, so the queries are dead ends anyway. I could envision a future where
> those databases are encouraged to add a pg_stats view with the stats
> translated/synthesized to FDW-friendly values.
>
> Me too.
>
It's a bummer that this change will make it slightly harder to do so, but
the chance of redshift or vertica doing such a thing is very low, and if
they did they'd probably bump their server_version_number along with the
change.
> e user trusts the remote to have good stats, otherwise they wouldn't use
> this option.
>
> I modified postgres-fdw.sgml as well to mention that that option is
> ignored, tweaking a phrase a bit.
>
>
+1. Applies clean. Passes tests tho obviously the test we needed all along
would have been on a very old buildfarm animal. The wording of the
documentation change is clear.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andres Freund | 2026-09-11 21:07:40 | Re: Temporal fkey bugs |
| Previous Message | Melanie Plageman | 2026-09-11 20:44:30 | Re: WAL_LOG CREATE DATABASE strategy broken for non-standard page layouts |