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

View all 155 sessions

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.

Read More

Sponsored by