K-nearest neighbor answers the question of “What is the closest match?”. PostgreSQL 12 can answer this question, and use indexes while doing it.
About Kirk Roybal
Kirk Roybal is a PostgreSQL enthusiast and contributes regularly to 2ndQuadrant blog.
Entries by Kirk Roybal
Declarative partitioning got some attention in the PostgreSQL 12 release, with some very handy features. There has been some pretty dramatic improvement in partition selection (especially when selecting from a few partitions out of a large set), referential integrity improvements, and introspection. In this article, we’re going to tackle the referential integrity improvement first. This […]
Computed columns in PostgreSQL 12 are here, but still have a ways to go.