pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedare there any expectations about pg indexes having prefix compression?
3+ messages / 3 participants
[nested] [flat]
* are there any expectations about pg indexes having prefix compression?
@ 2019-07-06 05:35 Alexandre hadjinlian guerra <alexhguerra@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Alexandre hadjinlian guerra @ 2019-07-06 05:35 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hi
i cant find any info about PG using btree prefix compression or dictionary
based compression. May i ask the status for these features?
Thanks
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: are there any expectations about pg indexes having prefix compression?
@ 2019-07-08 00:27 Peter Geoghegan <pg@bowt.ie>
parent: Alexandre hadjinlian guerra <alexhguerra@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Peter Geoghegan @ 2019-07-08 00:27 UTC (permalink / raw)
To: Alexandre hadjinlian guerra <alexhguerra@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
On Fri, Jul 5, 2019 at 10:35 PM Alexandre hadjinlian guerra
<alexhguerra@gmail.com> wrote:
> i cant find any info about PG using btree prefix compression or dictionary based compression. May i ask the status for these features?
Optional prefix compression would make sense, but there are currently
no active plans to add on it that I'm aware of.
--
Peter Geoghegan
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: are there any expectations about pg indexes having prefix compression?
@ 2019-07-10 10:42 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
parent: Alexandre hadjinlian guerra <alexhguerra@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Peter Eisentraut @ 2019-07-10 10:42 UTC (permalink / raw)
To: Alexandre hadjinlian guerra <alexhguerra@gmail.com>; pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2019-07-10 10:42 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-07-06 05:35 are there any expectations about pg indexes having prefix compression? Alexandre hadjinlian guerra <alexhguerra@gmail.com>
2019-07-08 00:27 ` Peter Geoghegan <pg@bowt.ie>
2019-07-10 10:42 ` Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox