Schedule - PGConf.EU 2011
Accelerating Local Search with PostgreSQL 9.1
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.
SpeakerJonathan S. Katz