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