Re: are there any expectations about pg indexes having prefix compression?

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: Alexandre hadjinlian guerra <alexhguerra(at)gmail(dot)com>, pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: are there any expectations about pg indexes having prefix compression?
Date: 2019-07-10 10:42:55
Message-ID: 701f1e55-db3d-162d-392f-9d1b73cba9ec@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Holger Jakobs 2019-07-10 12:20:28 Names of encodings, lc_collate, lc_ctype
Previous Message Keith 2019-07-09 18:02:47 Re: How to install pgstattuple extension in postgres 10.6?