Unlike MySQL PostgreSQL often skips indexes and does (unwanted) full table scan. I spent much time tuning PostgreSQL to make it use indexes. The following works for me: Continue reading How to configure PostgreSQL in such a way that it uses indexes