Know the Postgres index types such as multicolumn indexes and partial indexes,
use more joins,
prefer INNER JOINs,
understand the EXPLAIN output,
and don’t try to optimize on your development machine.
How to use ajax in search and filter features on your web site.
Thoughts on safe indexes to add to Rails app databases.
If you have any moderately old rails applications in production, and you find...
Problems with NULL in Rails associations.