pgsql: pg_dump: Simplify query for retrieving attribute statistics. - Mailing list pgsql-committers

From Nathan Bossart
Subject pgsql: pg_dump: Simplify query for retrieving attribute statistics.
Date
Msg-id E1w2XMM-000BlE-2T@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
pg_dump: Simplify query for retrieving attribute statistics.

This query fetches information from pg_stats, which did not return
table OIDs until recent commit 3b88e50d6c.  Because of this, we had
to cart around arrays of schema and table names, and we needed an
extra filter clause to hopefully convince the planner to use the
correct index.  With the introduction of pg_stats.tableid, we can
instead just use an array of OIDs, and we no longer need the extra
filter clause hack.

Author: Corey Huinker <corey.huinker@gmail.com>
Reviewed-by: Sami Imseih <samimseih@gmail.com>
Discussion: https://postgr.es/m/CADkLM%3DcoCVy92QkVUUTLdo5eO2bMDtwMrzRn_8miAhX%2BuPaqXg%40mail.gmail.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/4b5ba0c4ca5244d0ed589f67baf0204957886e6b

Modified Files
--------------
src/bin/pg_dump/pg_dump.c | 65 ++++++++++++++++++++++++++++++++++++++---------
src/bin/pg_dump/pg_dump.h |  1 +
2 files changed, 54 insertions(+), 12 deletions(-)


pgsql-committers by date:

Previous
From: Peter Eisentraut
Date:
Subject: pgsql: Hardcode typeof_unqual to __typeof_unqual__ for clang
Next
From: Robert Haas
Date:
Subject: pgsql: pg_plan_advice: Always install pg_plan_advice.h, and in the righ