pg.ddx.io pgsql-hackers@postgresql.org mailing list archive
help / color / mirror / Atom feedcompress method for spgist
2+ messages / 2 participants
[nested] [flat]
Commits from this thread:
2017-12-22 854823fa33 Add optional compression method to SP-GiST
* compress method for spgist
@ 2014-10-22 13:41 Teodor Sigaev <teodor@sigaev.ru>
2015-03-20 03:22 ` Re: compress method for spgist Bruce Momjian <bruce@momjian.us>
0 siblings, 1 reply; 2+ messages in thread
From: Teodor Sigaev @ 2014-10-22 13:41 UTC (permalink / raw)
To: pgsql-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.us
http://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-hackers
Attachments:
spgist_compress_method-1.patch.gz (application/x-gzip, 1.6K) download
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: compress method for spgist
2014-10-22 13:41 compress method for spgist Teodor Sigaev <teodor@sigaev.ru>
@ 2015-03-20 03:22 ` Bruce Momjian <bruce@momjian.us>
0 siblings, 0 replies; 2+ messages in thread
From: Bruce Momjian @ 2015-03-20 03:22 UTC (permalink / raw)
To: Teodor Sigaev <teodor@sigaev.ru>; +Cc: pgsql-hackers
On Wed, Oct 22, 2014 at 05:41:19PM +0400, Teodor Sigaev wrote:
> 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.us
> http://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.
Where are we on this?
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2015-03-20 03:22 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-10-22 13:41 compress method for spgist Teodor Sigaev <teodor@sigaev.ru>
2015-03-20 03:22 ` Bruce Momjian <bruce@momjian.us>
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