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.1323534...@sss.pgh.pa.us > http://www.postgresql.org/message-id/4ee77ea1.6030...@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 <br...@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
