Re: WIP: Covering + unique indexes.

Teodor Sigaev <teodor@sigaev.ru>

From: Teodor Sigaev <teodor@sigaev.ru>

To: pgsql-hackers@postgresql.org, Anastasia Lubennikova <lubennikovaav@gmail.com>, Peter Geoghegan <pg@heroku.com>, David Steele <david@pgmasters.net>, Peter Eisentraut <peter.eisentraut@2ndquadrant.com>

Cc: Aleksander Alekseev <a.alekseev@postgrespro.ru>

Date: 2017-03-30T15:26:05Z

Lists: pgsql-hackers

Attachments

0001-covering-core.patch (binary/octet-stream) patch 0001
0002-covering-btree.patch (binary/octet-stream) patch 0002

I had a look on patch and played with it, seems, it looks fine. I splitted it to 
two patches: core changes (+bloom index fix) and btree itself. All docs are left 
in first patch - I'm too lazy to rewrite documentation which is changed in 
second patch.
Any objection from reviewers to push both patches?


-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/

Commits

Adjust INCLUDE index truncation comments and code.
- 075aade4361b 11.0 landed
Add commentary explaining why MaxIndexTuplesPerPage calculation is safe.
- 2a67d6440db4 11.0 cited
Indexes with INCLUDE columns and their support in B-tree
- 8224de4f42cc 11.0 landed
Add amcheck verification of heap relations belonging to btree indexes.
- 7f563c09f890 11.0 cited
Doc: move info for btree opclass implementors into main documentation.
- 3785f7eee3d9 11.0 cited
Doc: mention that you can't PREPARE TRANSACTION after NOTIFY.
- e4fbf22831c2 11.0 cited
Remove dedicated B-tree root-split record types.
- 0c504a80cf2e 11.0 cited
Restructure index access method API to hide most of it at the C level.
- 65c5fcd353a8 9.6.0 cited
Split _bt_insertonpg to two functions.
- bc292937ae6a 8.3.0 cited
Major overhaul of btree index code. Eliminate special BTP_CHAIN logic for
- 9e85183bfc31 7.1.1 cited