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

From Corey Huinker
Subject Re: Import Statistics in postgres_fdw before resorting to sampling.
Date
Msg-id CADkLM=dbh+4+7pJniH_P19iSeeAtahVSijFbdEyhw-1+qwamSQ@mail.gmail.com
Whole thread Raw
In response to Re: Import Statistics in postgres_fdw before resorting to sampling.  (Corey Huinker <corey.huinker@gmail.com>)
Responses Re: Import Statistics in postgres_fdw before resorting to sampling.
List 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

pgsql-hackers by date:

Previous
From: Matthias van de Meent
Date:
Subject: Re: Reduce build times of pg_trgm GIN indexes
Next
From: Jelte Fennema-Nio
Date:
Subject: Re: pgsql: tests: Add a test C++ extension module