Re: BTree index support prefix compression - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: BTree index support prefix compression
Date
Msg-id 20180625163525.GB24940@momjian.us
Whole thread Raw
In response to Re: BTree index support prefix compression  (Wei Shan <weishan.ang@gmail.com>)
List pgsql-admin
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 <pg@bowt.ie> wrote:
> 
>     On Wed, Jun 13, 2018 at 4:44 AM, Wei Shan <weishan.ang@gmail.com> 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  <bruce@momjian.us>        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 +


pgsql-admin by date:

Previous
From: Rui DeSousa
Date:
Subject: Re: Investigate postgres 9.6.3 repmgr lag 4.0.4
Next
From: John Scalia
Date:
Subject: Upgrading 9.6.9 to 10.4