Re: BTree index support prefix compression

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Wei Shan <weishan(dot)ang(at)gmail(dot)com>
Cc: pg(at)bowt(dot)ie, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: BTree index support prefix compression
Date: 2018-06-25 16:35:25
Message-ID: 20180625163525.GB24940@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)bowt(dot)ie> wrote:
>
> On Wed, Jun 13, 2018 at 4:44 AM, Wei Shan <weishan(dot)ang(at)gmail(dot)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(at)momjian(dot)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 +

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Anjul Tyagi 2018-06-26 12:47:26 Server Crash
Previous Message Rui DeSousa 2018-06-25 14:21:23 Re: Investigate postgres 9.6.3 repmgr lag 4.0.4