Thread: BTree index support prefix compression
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
Ang Wei Shan
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
Thanks Peter!
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
Ang Wei Shan
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 +