| From: | Peter Eisentraut <peter(at)eisentraut(dot)org> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: pgstattuple: Have pgstattuple_approx accept TOAST tables |
| Date: | 2020-06-29 23:13:05 |
| Message-ID: | E1jq2xV-0003F0-Io@gemulon.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
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(dot)albe(at)cybertec(dot)at>
Discussion: https://www.postgresql.org/message-id/flat/27c4496a-02b9-dc87-8f6f-bddbef54e0fe(at)2ndquadrant(dot)com
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(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Amit Kapila | 2020-06-30 04:13:03 | Re: pgsql: Enable Unix-domain sockets support on Windows |
| Previous Message | Tom Lane | 2020-06-29 22:55:08 | pgsql: Remove support for timezone "posixrules" file. |