Sql
-
Reading a Postgres Query Plan
Take a guided tour through a query plan for a “simple” SQL query.
-
Advanced Postgres Performance Tips
What do you do when indexes aren’t enough?
-
Multi-Table Full Text Search with Postgres
Easily searching across an application’s data is a pervasive need. If you are lucky, you can get away with simple sorting or searching on a single column, but it is more likely that you need full text search across multiple models, all from a single search field.