Conference Schedule - PGConf.EU 2011

Fast GiST index build

Date: 2011-10-20
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

EMC² Servoy VMWare

Silver Sponsors

2ndQuadrant Cybertec Dalibo Redpill Linpro