Skip to content
Snippets Groups Projects
Select Git revision
  • benchmark-tools
  • postgres-lambda
  • master default
  • REL9_4_25
  • REL9_5_20
  • REL9_6_16
  • REL_10_11
  • REL_11_6
  • REL_12_1
  • REL_12_0
  • REL_12_RC1
  • REL_12_BETA4
  • REL9_4_24
  • REL9_5_19
  • REL9_6_15
  • REL_10_10
  • REL_11_5
  • REL_12_BETA3
  • REL9_4_23
  • REL9_5_18
  • REL9_6_14
  • REL_10_9
  • REL_11_4
23 results

postgres-lambda-diff

  • Clone with SSH
  • Clone with HTTPS
  • user avatar
    Alexander Korotkov authored
    Similarly to B-tree, GiST index access method gets support of INCLUDE
    attributes.  These attributes aren't used for tree navigation and aren't
    present in non-leaf pages.  But they are present in leaf pages and can be
    fetched during index-only scan.
    
    The point of having INCLUDE attributes in GiST indexes is slightly different
    from the point of having them in B-tree.  The main point of INCLUDE attributes
    in B-tree is to define UNIQUE constraint over part of attributes enabled for
    index-only scan.  In GiST the main point of INCLUDE attributes is to use
    index-only scan for attributes, whose data types don't have GiST opclasses.
    
    Discussion: https://postgr.es/m/73A1A452-AD5F-40D4-BD61-978622FF75C1%40yandex-team.ru
    Author: Andrey Borodin, with small changes by me
    Reviewed-by: Andreas Karlsson
    f2e40380
    History
    Name Last commit Last update