How We Made 100M Vector Indexing in 20 Minutes Possible on PostgreSQL
1. Introduction In the past few months, we’ve heard consistent feedback from users and partners: while our goal of providing a scalable, high-performa...
Summary
The article outlines unconventional PostgreSQL optimizations.
It covers using constraint_exclusion=on to skip full table scans on invalid values via check constraints. It also discusses function-based indexes with virtual generated columns for lower cardinality queries and hash indexes for uniqueness enforcement.