From: Bruce Momjian <bruce@momjian.us>
To: Wei Shan <weishan.ang@gmail.com>
Cc: pg@bowt.ie, pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: BTree index support prefix compression
Date: Mon, 25 Jun 2018 12:35:25 -0400
Message-ID: <20180625163525.GB24940@momjian.us> (raw)
In-Reply-To: <CAFe9ZTqSFjm2ytRv96yybiMYmxL23FTpiw=MdpM5pB08=SoUEg@mail.gmail.com>
References: <CAFe9ZTom3K0rsFqK=FLKpUxjjy0zUQpN13vAKd721SDktdT9Zw@mail.gmail.com>
<CAH2-Wzn4++f-xHEy5uzmdjo9acGMrNqqWdCpZK5Bse3hVhyumw@mail.gmail.com>
<CAFe9ZTqSFjm2ytRv96yybiMYmxL23FTpiw=MdpM5pB08=SoUEg@mail.gmail.com>
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 +
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: bruce@momjian.us, weishan.ang@gmail.com
Subject: Re: BTree index support prefix compression
In-Reply-To: <20180625163525.GB24940@momjian.us>
References: <CAFe9ZTom3K0rsFqK=FLKpUxjjy0zUQpN13vAKd721SDktdT9Zw@mail.gmail.com> <CAH2-Wzn4++f-xHEy5uzmdjo9acGMrNqqWdCpZK5Bse3hVhyumw@mail.gmail.com> <CAFe9ZTqSFjm2ytRv96yybiMYmxL23FTpiw=MdpM5pB08=SoUEg@mail.gmail.com> <20180625163525.GB24940@momjian.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox