Théo’s blog
Not groundbreaking stuff here – just practical tech tips and recipes.
-
Slow Query with “LIMIT 1” in Postgresql
Recently I had issues on a production database running slow on tables with more than 1M rows. This is a complex Ruby on Rails app connected to a Postgresql database, I went through the whole stack to figure out that it’s a simple index problem. Very few or no related doc was found about this…