From: Teodor Sigaev <teodor@sigaev.ru>
To: Pgsql Hackers <pgsql-hackers@postgresql.org>
Subject: compress method for spgist
Date: Wed, 22 Oct 2014 17:41:19 +0400
Message-ID: <5447B3FF.2080406@sigaev.ru> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
When we developed SP-GiST we missed analogue of GiST's compress method. There
was two reasons for that: lack of imagination to imagine case with different
types of indexed value and column, and we didn't want call some method while
index fit in one page. Some discussion on that
http://www.postgresql.org/message-id/27542.1323534819@sss.pgh.pa.ushttp://www.postgresql.org/message-id/4EE77EA1.6030503@sigaev.ru
But we was wrong: PostGIS guys found an example: polygon indexing with storing
just a bounding box. Actually, I don't know index structure for boxes suitable
for SP-GiST but I'm not a geometer. They are.
Attached patch provides support of optional compress method for SP-GiST.
--
Teodor Sigaev E-mail: teodor@sigaev.ru
WWW: http://www.sigaev.ru/
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackersAttachments:
spgist_compress_method-1.patch.gz (application/x-gzip, 1.6K) download
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: pgsql-hackers@postgresql.org
Cc: teodor@sigaev.ru
Subject: Re: compress method for spgist
In-Reply-To: <5447B3FF.2080406@sigaev.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox