Sped up site wide search from 8s to <0.2s
Eager.app uses Postgres on the backend. Instead of having a separate search stack like Elasticsearch, we simply use the built-in full text search functionality provided by the database (to keep the stack simple). This morning, I added an extra column to have pre-calculated values for the search vectors. Sped up the whole thing by... a lot.