]> granicus.if.org Git - postgresql/commit
BRIN de-summarization
authorAlvaro Herrera <alvherre@alvh.no-ip.org>
Sat, 1 Apr 2017 19:10:04 +0000 (16:10 -0300)
committerAlvaro Herrera <alvherre@alvh.no-ip.org>
Sat, 1 Apr 2017 19:10:04 +0000 (16:10 -0300)
commitc655899ba9ae2a0d24e99c797167c33e0cfa0820
tree5493791074d6624cf5ce44313a870846d4563f97
parent3a82129a40a3a2987356d4051e017fd456876c8d
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
12 files changed:
doc/src/sgml/brin.sgml
doc/src/sgml/func.sgml
src/backend/access/brin/brin.c
src/backend/access/brin/brin_revmap.c
src/backend/access/brin/brin_xlog.c
src/backend/access/rmgrdesc/brindesc.c
src/include/access/brin_revmap.h
src/include/access/brin_xlog.h
src/include/catalog/catversion.h
src/include/catalog/pg_proc.h
src/test/regress/expected/brin.out
src/test/regress/sql/brin.sql