Speed up PostgreSQL® pgvector queries with indexes
Learn the theory and the details of how to speed up PostgreSQL® pgvector queries using indexes IVFFlat, HNSW and traditional indexes
Tag: performance
How to speed up COUNT(DISTINCT)
While counting is common in every application, sometimes it is not enough: when we need to display the amount of unique users generating traffic in our website or provide the number of disparate items included in an order we need to apply a distinct count. Compared to a classical count, the distinct one is usually… Continue reading How to speed up COUNT(DISTINCT)
5 Ways to implement NOT EXISTS in PostgreSQL
When building an application, usually we query our database to retrieve the things we already know: what orders a client made or, more generally, what steps in the app flow have already been taken. However, to correctly address the user journey, it is often more important to query the database and retrieve data that informs… Continue reading 5 Ways to implement NOT EXISTS in PostgreSQL