Re: Import Statistics in postgres_fdw before resorting to sampling. - Mailing list pgsql-hackers

From Ashutosh Bapat
Subject Re: Import Statistics in postgres_fdw before resorting to sampling.
Date
Msg-id CAExHW5uTy=xbdsjKO6kHE3Oc=5O5L_Fy-UPmBGkUW2aQPuiirA@mail.gmail.com
Whole thread Raw
In response to Re: Import Statistics in postgres_fdw before resorting to sampling.  (Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>)
List pgsql-hackers
On Thu, Jan 22, 2026 at 3:45 PM Ashutosh Bapat
<ashutosh.bapat.oss@gmail.com> wrote:
>
> On Thu, Jan 22, 2026 at 2:21 AM Corey Huinker <corey.huinker@gmail.com> wrote:
> >>
> >> 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
parsingsavings. 
> >> - 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
computethose without a row sample. 
> >

The patches fail to build the document. Attached diff fixes that.


--
Best Wishes,
Ashutosh Bapat

Attachment

pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Remove redundant AssertVariableIsOfType uses in pg_upgrade
Next
From: Mihail Nikalayeu
Date:
Subject: Re: Adding REPACK [concurrently]