pgstattuple: Have pgstattuple_approx accept TOAST tables
authorPeter Eisentraut <peter@eisentraut.org>
Mon, 29 Jun 2020 22:29:35 +0000 (00:29 +0200)
committerPeter Eisentraut <peter@eisentraut.org>
Mon, 29 Jun 2020 22:56:43 +0000 (00:56 +0200)
commitee0202d552791f14bc407ce299628ce8d50eebe3
tree5abce35cf66587e328e71169d9db1b2783924242
parentea57e531b9487e042131ca1151a3ef5d655f40ec
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 <laurenz.albe@cybertec.at>
Discussion: https://www.postgresql.org/message-id/flat/27c4496a-02b9-dc87-8f6f-bddbef54e0fe@2ndquadrant.com
contrib/pg_visibility/expected/pg_visibility.out
contrib/pg_visibility/sql/pg_visibility.sql
contrib/pgstattuple/expected/pgstattuple.out
contrib/pgstattuple/pgstatapprox.c
contrib/pgstattuple/sql/pgstattuple.sql