Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YYnVh-0003cj-C1 for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Mar 2015 03:22:09 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YYnVg-0000tu-Qw for pgsql-hackers@arkaria.postgresql.org; Fri, 20 Mar 2015 03:22:08 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YYnVe-0000qz-SU for pgsql-hackers@postgresql.org; Fri, 20 Mar 2015 03:22:07 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YYnVb-00048i-Ml for pgsql-hackers@postgresql.org; Fri, 20 Mar 2015 03:22:05 +0000 Received: from bruce by momjian.us with local (Exim 4.72) (envelope-from ) id 1YYnVa-0005qp-Oy; Thu, 19 Mar 2015 23:22:02 -0400 Date: Thu, 19 Mar 2015 23:22:02 -0400 From: Bruce Momjian To: Teodor Sigaev Cc: Pgsql Hackers Subject: Re: compress method for spgist Message-ID: <20150320032202.GF6317@momjian.us> References: <5447B3FF.2080406@sigaev.ru> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <5447B3FF.2080406@sigaev.ru> User-Agent: Mutt/1.5.20 (2009-06-14) X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org 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 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