Schedule - PGConf.EU 2011

Accelerating Local Search with PostgreSQL 9.1

Date: 2011-10-21
Time: 11:50–12:40
Room: Amsterdam 1
Level: Beginner

KNN-GiST indexes in PostgreSQL 9.1 are really cool - I actually try to find scenarios in projects to use them. Some of the queries they are designed to speedup are actually fairly common text search queries. Others are in the realm of geospatial comparisons or text-similarity searches. This presentation will demonstrate the power of KNN-GiST indexes on geospatial and text searching queries, but also their present limitations through some of my experimentations. I will also discuss some of the theory behind KNN (k-nearest neighbor) as well as some of the applications this feature can be applied too.


Jonathan S. Katz

Platinum Sponsor


Gold Sponsors

EMC² Servoy VMWare

Silver Sponsors

2ndQuadrant Cybertec Dalibo Redpill Linpro