pgsql: Add pgstattuple_approx() to the pgstattuple extension.

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add pgstattuple_approx() to the pgstattuple extension.
Date: 2015-05-13 05:38:34
Message-ID: E1YsPNK-0007xH-81@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Add pgstattuple_approx() to the pgstattuple extension.

The new function allows to estimate bloat and other table level statics
in a faster, but approximate, way. It does so by using information from
the free space map for pages marked as all visible in the visibility
map. The rest of the table is actually read and free space/bloat is
measured accurately. In many cases that allows to get bloat information
much quicker, causing less IO.

Author: Abhijit Menon-Sen
Reviewed-By: Andres Freund, Amit Kapila and Tomas Vondra
Discussion: 20140402214144(dot)GA28681(at)kea(dot)toroid(dot)org

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/5850b20f58a594ac69f4f77b24cad94fc3bfd946

Modified Files
--------------
contrib/pgstattuple/Makefile | 4 +-
contrib/pgstattuple/pgstatapprox.c | 273 +++++++++++++++++++++++++
contrib/pgstattuple/pgstattuple--1.2--1.3.sql | 18 ++
contrib/pgstattuple/pgstattuple--1.2.sql | 79 -------
contrib/pgstattuple/pgstattuple--1.3.sql | 95 +++++++++
contrib/pgstattuple/pgstattuple.control | 2 +-
doc/src/sgml/pgstattuple.sgml | 136 +++++++++++-
7 files changed, 524 insertions(+), 83 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Heikki Linnakangas 2015-05-13 07:16:51 pgsql: Fix RBM_ZERO_AND_LOCK mode to not acquire lock on local buffers.
Previous Message Amit Kapila 2015-05-13 03:22:38 Re: Re: [COMMITTERS] pgsql: pg_basebackup -F t now succeeds with a long symlink target