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

README.intarray

  • Tom Lane's avatar
    f933766b
    Restructure pg_opclass, pg_amop, and pg_amproc per previous discussions in · f933766b
    Tom Lane authored
    pgsql-hackers.  pg_opclass now has a row for each opclass supported by each
    index AM, not a row for each opclass name.  This allows pg_opclass to show
    directly whether an AM supports an opclass, and furthermore makes it possible
    to store additional information about an opclass that might be AM-dependent.
    pg_opclass and pg_amop now store "lossy" and "haskeytype" information that we
    previously expected the user to remember to provide in CREATE INDEX commands.
    Lossiness is no longer an index-level property, but is associated with the
    use of a particular operator in a particular index opclass.
    
    Along the way, IndexSupportInitialize now uses the syscaches to retrieve
    pg_amop and pg_amproc entries.  I find this reduces backend launch time by
    about ten percent, at the cost of a couple more special cases in catcache.c's
    IndexScanOK.
    
    Initial work by Oleg Bartunov and Teodor Sigaev, further hacking by Tom Lane.
    
    initdb forced.
    f933766b
    History
    Restructure pg_opclass, pg_amop, and pg_amproc per previous discussions in
    Tom Lane authored
    pgsql-hackers.  pg_opclass now has a row for each opclass supported by each
    index AM, not a row for each opclass name.  This allows pg_opclass to show
    directly whether an AM supports an opclass, and furthermore makes it possible
    to store additional information about an opclass that might be AM-dependent.
    pg_opclass and pg_amop now store "lossy" and "haskeytype" information that we
    previously expected the user to remember to provide in CREATE INDEX commands.
    Lossiness is no longer an index-level property, but is associated with the
    use of a particular operator in a particular index opclass.
    
    Along the way, IndexSupportInitialize now uses the syscaches to retrieve
    pg_amop and pg_amproc entries.  I find this reduces backend launch time by
    about ten percent, at the cost of a couple more special cases in catcache.c's
    IndexScanOK.
    
    Initial work by Oleg Bartunov and Teodor Sigaev, further hacking by Tom Lane.
    
    initdb forced.