Horton

BRIN de-summarization

Alvaro Herrera <alvherre@alvh.no-ip.org>

View on postgr.es
Commit: c655899ba9ae2a0d24e99c797167c33e0cfa0820
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
Date: 2017-04-01T19:10:04Z
Releases: 10.0 
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

Files

PathChange+/−
doc/src/sgml/brin.sgml modified +4 −0
doc/src/sgml/func.sgml modified +15 −0
src/backend/access/brin/brin.c modified +74 −0
src/backend/access/brin/brin_revmap.c modified +137 −3
src/backend/access/brin/brin_xlog.c modified +43 −0
src/backend/access/rmgrdesc/brindesc.c modified +10 −0
src/include/access/brin_revmap.h modified +1 −0
src/include/access/brin_xlog.h modified +19 −1
src/include/catalog/catversion.h modified +1 −1
src/include/catalog/pg_proc.h modified +2 −0
src/test/regress/expected/brin.out modified +27 −0
src/test/regress/sql/brin.sql modified +7 −0

Documentation touched

Discussion