Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fXUSi-0001wU-Qa for pgsql-admin@arkaria.postgresql.org; Mon, 25 Jun 2018 16:35:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fXUSh-0007p9-53 for pgsql-admin@arkaria.postgresql.org; Mon, 25 Jun 2018 16:35:31 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fXUSg-0007ov-R5 for pgsql-admin@lists.postgresql.org; Mon, 25 Jun 2018 16:35:30 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fXUSd-0003yp-VT for pgsql-admin@postgresql.org; Mon, 25 Jun 2018 16:35:29 +0000 Received: from bruce by momjian.us with local (Exim 4.84_2) (envelope-from ) id 1fXUSb-0003kJ-DL; Mon, 25 Jun 2018 12:35:25 -0400 Date: Mon, 25 Jun 2018 12:35:25 -0400 From: Bruce Momjian To: Wei Shan Cc: pg@bowt.ie, pgsql-admin Subject: Re: BTree index support prefix compression Message-ID: <20180625163525.GB24940@momjian.us> References: MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.23 (2014-03-12) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Thu, Jun 14, 2018 at 01:04:53PM +0100, Wei Shan wrote: > Thanks Peter! I would take a look at SP-Gist, which does do prefix compression on strings. --------------------------------------------------------------------------- > > On Wed, 13 Jun 2018 at 16:24, Peter Geoghegan wrote: > > On Wed, Jun 13, 2018 at 4:44 AM, Wei Shan wrote: > > Does PostgreSQL BTree index support prefix compression? I can only see > that > > this has been discussed in the mailing list. But it doesn't say if it has > > been implemented > > Unfortunately, no, it does not. > > > -- > Peter Geoghegan > > > > -- > Regards, > Ang Wei Shan -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +