Postgres Pro
Downloads
Home   >   mailing lists

Re: are there any expectations about pg indexes having prefixcompression? - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: are there any expectations about pg indexes having prefixcompression?
Date
Msg-id 701f1e55-db3d-162d-392f-9d1b73cba9ec@2ndquadrant.com
Whole thread Raw
In response to are there any expectations about pg indexes having prefix compression?  (Alexandre hadjinlian guerra <alexhguerra@gmail.com>)
List pgsql-admin
Tree view 
On 2019-07-06 07:35, Alexandre hadjinlian guerra wrote:
> i cant find any info about PG using btree prefix compression or
> dictionary based compression. May i ask the status for these features?

spgist indexes give you a kind of prefix de-duplication, so maybe this
would help in some use cases.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-admin by date:

Previous
From: Keith
Date:
Subject: Re: How to install pgstattuple extension in postgres 10.6?
Next
From: Holger Jakobs
Date:
Subject: Names of encodings, lc_collate, lc_ctype