#partial index

Advanced PostgreSQL Indexes for Real Performance — GIN, GiST, BRIN and Partial Indexes

If your PostgreSQL database slows down on full-text search, JSON data, geometries, or date ranges, the problem isn't the...