Re: [WIP] Effective storage of duplicates in B-tree index.

From: Anastasia Lubennikova <a(dot)lubennikova(at)postgrespro(dot)ru>
To: David Steele <david(at)pgmasters(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [WIP] Effective storage of duplicates in B-tree index.
Date: 2016-03-18 17:19:37
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

Please, find the new version of the patch attached. Now it has WAL

Detailed description of the feature you can find in README draft

This patch is pretty complicated, so I ask everyone, who interested in
this feature,
to help with reviewing and testing it. I will be grateful for any feedback.
But please, don't complain about code style, it is still work in progress.

Next things I'm going to do:
1. More debugging and testing. I'm going to attach in next message
couple of sql scripts for testing.
2. Fix NULLs processing
3. Add a flag into pg_index, that allows to enable/disable compression
for each particular index.
4. Recheck locking considerations. I tried to write code as less
invasive as possible, but we need to make sure that algorithm is still
5. Change BTMaxItemSize
6. Bring back microvacuum functionality.

Anastasia Lubennikova
Postgres Professional:
The Russian Postgres Company

Attachment Content-Type Size
btree_compression_4.0.patch text/x-patch 51.2 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Teodor Sigaev 2016-03-18 17:24:35 Re: [PATCH] we have added support for box type in SP-GiST index
Previous Message Pavel Stehule 2016-03-18 17:19:14 Re: proposal: function parse_ident