pgsql: pgstattuple: Have pgstattuple_approx accept TOAST tables

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

pgsql: pgstattuple: Have pgstattuple_approx accept TOAST tables

Peter Eisentraut-3
pgstattuple: Have pgstattuple_approx accept TOAST tables

TOAST tables have a visibility map and a free space map, so they can
be supported by pgstattuple_approx just fine.

Add test cases to show how various pgstattuple functions accept TOAST
tables.  Also add similar tests to pg_visibility, which already
accepted TOAST tables correctly but had no test coverage for them.

Reviewed-by: Laurenz Albe <[hidden email]>
Discussion: https://www.postgresql.org/message-id/flat/27c4496a-02b9-dc87-8f6f-bddbef54e0fe@...

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/ee0202d552791f14bc407ce299628ce8d50eebe3

Modified Files
--------------
contrib/pg_visibility/expected/pg_visibility.out | 17 ++++++++++++++--
contrib/pg_visibility/sql/pg_visibility.sql      |  7 +++++--
contrib/pgstattuple/expected/pgstattuple.out     | 25 +++++++++++++++++++++---
contrib/pgstattuple/pgstatapprox.c               | 10 +++++-----
contrib/pgstattuple/sql/pgstattuple.sql          |  5 +++++
5 files changed, 52 insertions(+), 12 deletions(-)