February 28 - March 1, 2013
Montreal, Canada
Local search - Find nearest neighbours fast using PostgreSQL
PostgreSQL 9.1 arrived with a new featured called KNN-GiST, or fast K-Nearest-Neighbour searching. Many people don't realize what that means, and what they're good for. This walk will look into both the more obvious geometrical and geographical cases, as well as the more surprising use-cases such as string matching and similarity
Magnus Hagander
Redpill Linpro
Magnus Hagander is a member of the PostgreSQL Core Team and a developer and code committer in the PostgreSQL Global Development Group.
He mostly works on different parts of the PostgreSQL backend, recently with a focus on security features such as authentication and encryption, and backup/availability.
To pay the bills, he is an open source software consultant, primarily on PostgreSQL and Varnish at Redpill Linpro in Stockholm, Sweden, where he works with consulting, support and training.
Sponsored by
Media
