pgsql: BRIN de-summarization

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: BRIN de-summarization
Date: 2017-04-01 19:16:00
Message-ID: E1cuOVE-0005XF-OZ@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

BRIN de-summarization

When the BRIN summary tuple for a page range becomes too "wide" for the
values actually stored in the table (because the tuples that were
present originally are no longer present due to updates or deletes), it
can be useful to remove the outdated summary tuple, so that a future
summarization can install a tighter summary.

This commit introduces a SQL-callable interface to do so.

Author: Álvaro Herrera
Reviewed-by: Eiji Seki
Discussion: https://postgr.es/m/20170228045643.n2ri74ara4fhhfxf@alvherre.pgsql

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/c655899ba9ae2a0d24e99c797167c33e0cfa0820

Modified Files
--------------
doc/src/sgml/brin.sgml | 4 +
doc/src/sgml/func.sgml | 15 ++++
src/backend/access/brin/brin.c | 74 +++++++++++++++++
src/backend/access/brin/brin_revmap.c | 140 ++++++++++++++++++++++++++++++++-
src/backend/access/brin/brin_xlog.c | 43 ++++++++++
src/backend/access/rmgrdesc/brindesc.c | 10 +++
src/include/access/brin_revmap.h | 1 +
src/include/access/brin_xlog.h | 20 ++++-
src/include/catalog/catversion.h | 2 +-
src/include/catalog/pg_proc.h | 2 +
src/test/regress/expected/brin.out | 27 +++++++
src/test/regress/sql/brin.sql | 7 ++
12 files changed, 340 insertions(+), 5 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Andrew Dunstan 2017-04-01 20:12:52 Re: pgsql: Full Text Search support for json and jsonb
Previous Message Andres Freund 2017-04-01 19:06:50 Re: Vendor LLVM 4.0.