Thread

  1. Re: WIP: Fast GiST index build

    Alexander Korotkov <aekorotkov@gmail.com> — 2011-07-18T18:00:34Z

    Hi!
    
    New version of patch is attached. There are following changes.
    1) Since proposed tchnique is not always a "fast" build, it was renamed
    everywhere in the patch to "buffering" build.
    2) Parameter "buffering" now has 3 possible values "yes", "no" and "auto".
    "auto" means automatic switching from regular index build to buffering one.
    Currently it just switch when index size exceeds maintenance_work_mem.
    3) Holding of many buffers pinned is avoided.
    4) Rebased with head.
    
    TODO:
    1) Take care about ordered datasets in automatic switching.
    2) Take care about concurrent backends in automatic switching.
    
    ------
    With best regards,
    Alexander Korotkov.