public inbox for [email protected]
help / color / mirror / Atom feedFrom: Heikki Linnakangas <[email protected]>
To: [email protected]
Subject: pgsql: Add support for sorted gist index builds to btree_gist
Date: Thu, 03 Apr 2025 10:59:00 +0000
Message-ID: <[email protected]> (raw)
Add support for sorted gist index builds to btree_gist
This enables sortsupport in the btree_gist extension for faster builds
of gist indexes.
Sorted gist index build strategy is the new default now. Regression
tests are unchanged (except for one small change in the 'enum' test to
add coverage for enum values added later) and are using the sorted
build strategy instead.
One version of this was committed a long time ago already, in commit
9f984ba6d2, but it was quickly reverted because of buildfarm
failures. The failures were presumably caused by some small bugs, but
we never got around to debug and commit it again. This patch was
written from scratch, implementing the same idea, with some fragments
and ideas from the original patch.
Author: Bernd Helmle <[email protected]>
Author: Andrey Borodin <[email protected]>
Discussion: https://www.postgresql.org/message-id/[email protected]
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/e4309f73f698851a2f7d49ca5e98e3e188400891
Modified Files
--------------
contrib/btree_gist/Makefile | 2 +-
contrib/btree_gist/btree_bit.c | 46 +++++++
contrib/btree_gist/btree_bool.c | 23 ++++
contrib/btree_gist/btree_bytea.c | 34 +++++
contrib/btree_gist/btree_cash.c | 28 ++++
contrib/btree_gist/btree_date.c | 25 ++++
contrib/btree_gist/btree_enum.c | 39 ++++++
contrib/btree_gist/btree_float4.c | 23 ++++
contrib/btree_gist/btree_float8.c | 23 ++++
contrib/btree_gist/btree_gist--1.8--1.9.sql | 197 ++++++++++++++++++++++++++++
contrib/btree_gist/btree_gist.control | 2 +-
contrib/btree_gist/btree_inet.c | 28 ++++
contrib/btree_gist/btree_int2.c | 26 ++++
contrib/btree_gist/btree_int4.c | 27 +++-
contrib/btree_gist/btree_int8.c | 27 ++++
contrib/btree_gist/btree_interval.c | 25 ++++
contrib/btree_gist/btree_macaddr.c | 25 ++++
contrib/btree_gist/btree_macaddr8.c | 25 ++++
contrib/btree_gist/btree_numeric.c | 34 +++++
contrib/btree_gist/btree_oid.c | 28 ++++
contrib/btree_gist/btree_text.c | 69 ++++++++++
contrib/btree_gist/btree_time.c | 26 ++++
contrib/btree_gist/btree_ts.c | 25 ++++
contrib/btree_gist/btree_utils_var.h | 12 +-
contrib/btree_gist/btree_uuid.c | 23 ++++
contrib/btree_gist/expected/enum.out | 5 +-
contrib/btree_gist/meson.build | 1 +
contrib/btree_gist/sql/enum.sql | 6 +-
doc/src/sgml/btree-gist.sgml | 7 +
29 files changed, 855 insertions(+), 6 deletions(-)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: pgsql: Add support for sorted gist index builds to btree_gist
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox