Re: WIP: Covering + unique indexes.

Erik Rijkers <er@xs4all.nl>

From: Erik Rijkers <er@xs4all.nl>

To: Anastasia Lubennikova <a.lubennikova@postgrespro.ru>

Cc: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>, Michael Paquier <michael.paquier@gmail.com>, Amit Kapila <amit.kapila16@gmail.com>, Andrey Borodin <amborodin@acm.org>, pgsql-hackers <pgsql-hackers@postgresql.org>, Anastasia Lubennikova <lubennikovaav@gmail.com>, Brad.Dejong@infor.com, pgsql-hackers-owner@postgresql.org

Date: 2017-01-10T03:08:18Z

Lists: pgsql-hackers

Attachments

catalogs.sgml.diff (text/x-diff) patch
create_index.sgml.diff (text/x-diff) patch
create_table.sgml.diff (text/x-diff) patch
(unnamed) (text/plain)

On 2017-01-09 16:02, Anastasia Lubennikova wrote:
>  include_columns_10.0_v1.patch

The patch applies, compiles, and make check is OK.

It yields nice perfomance gains and I haven't been able to break 
anything (yet).

Some edits of the sgml-changes are attached.

Thank you for this very useful improvement.

Erik Rijkers

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