BTree index support prefix compression

classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

BTree index support prefix compression

Wei Shan
Hi all,

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

Thanks!

--
Regards,
Ang Wei Shan
Reply | Threaded
Open this post in threaded view
|

Re: BTree index support prefix compression

Peter Geoghegan-4
On Wed, Jun 13, 2018 at 4:44 AM, Wei Shan <[hidden email]> 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

Reply | Threaded
Open this post in threaded view
|

Re: BTree index support prefix compression

Wei Shan
Thanks Peter!

On Wed, 13 Jun 2018 at 16:24, Peter Geoghegan <[hidden email]> wrote:
On Wed, Jun 13, 2018 at 4:44 AM, Wei Shan <[hidden email]> 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
Reply | Threaded
Open this post in threaded view
|

Re: BTree index support prefix compression

Bruce Momjian
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 <[hidden email]> wrote:
>
>     On Wed, Jun 13, 2018 at 4:44 AM, Wei Shan <[hidden email]> 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  <[hidden email]>        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 +