Tag: postgresql

  • 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…