Conference Schedule - PGConf.EU 2011

Back

Fast GiST index build

Date: Oct. 20, 2011
Time: 11:50 - 12:40
Room: Amsterdam 1
Level: Advanced

Currently GiST index don't have any bulk load functionality. It have to create new index by entry insertion one by one. Thus, GiST index build can be very slow when index doesn't fit to cache. This talk presents application of buffer tree to GiST index build. This application allows to dramatically reduce IO load during GiST index build. Also tradeoffs between CPU and IO load and index quality is planned to being discussed.

Speaker

Alexander Korotkov

Platinum Sponsor

EnterpriseDB

Gold Sponsors

VMWare Servoy EMC²

Silver Sponsors

Redpill Linpro 2ndQuadrant Cybertec Dalibo