| From: | Corey Huinker <corey(dot)huinker(at)gmail(dot)com> |
|---|---|
| To: | Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com> |
| Cc: | Etsuro Fujita <etsuro(dot)fujita(at)gmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, pgsql-hackers(at)postgresql(dot)org, jkatz(at)postgresql(dot)org, nathandbossart(at)gmail(dot)com |
| Subject: | Re: Import Statistics in postgres_fdw before resorting to sampling. |
| Date: | 2026-01-21 20:51:23 |
| Message-ID: | CADkLM=dbh+4+7pJniH_P19iSeeAtahVSijFbdEyhw-1+qwamSQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
>
> Changes in this release, aside from rebasing:
>
> - The generic analyze and fdw.h changes are in their own patch (0001) that
> ignores contrib/postgres_fdw entirely.
> - The option for remote_analyze has been moved to its own patch (0003).
> - The errors raised are now warnings, to ensure that we can always fall
> back to row sampling.
> - All local attributes with attstatarget > 0 must get matching remote
> statistics or the import is considered a failure.
> - The pg_restore_attribute_stats() call has been turned into a prepared
> statement, for clarity and some minor parsing savings.
> - The calls to pg_restore_relation_stats() are parameterized, but not
> prepared as this is rarely called more than once.
> - postgresStatisticsAreImportable will now disqualify a table if has
> extended statistics objects, because we can't compute those without a row
> sample.
>
Rebase
| Attachment | Content-Type | Size |
|---|---|---|
| v11-0001-Add-FDW-functions-for-importing-optimizer-statis.patch | text/x-patch | 5.0 KB |
| v11-0002-Add-remote-statistics-fetching-to-postgres_fdw.patch | text/x-patch | 36.1 KB |
| v11-0003-Add-remote_analyze-to-postgres_fdw-remote-statis.patch | text/x-patch | 10.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jelte Fennema-Nio | 2026-01-21 21:00:39 | Re: pgsql: tests: Add a test C++ extension module |
| Previous Message | Matthias van de Meent | 2026-01-21 20:50:54 | Re: Reduce build times of pg_trgm GIN indexes |