Re: Import Statistics in postgres_fdw before resorting to sampling.

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

In response to

Responses

Browse pgsql-hackers by date

  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