Slow query

From: Nicholas Wieland <ngw(at)nofeed(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Slow query
Date: 2012-08-09 15:47:19
Message-ID: 3D2E85F3-7D39-4C9F-8967-C1C3106128C8@nofeed.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, I've tried to post on stackoverflow, but nobody is apparently able to help me.
I'm not going to repeat everything here, there's quite some code in there that is nicely formatted, but if this is a problem I can repost it in here.

http://stackoverflow.com/questions/11865504/postgresql-slow-query-with-activerecord

What seems incredibly strange to me is that postgres is not using the indexes I've set.

Someone has any idea?

TIA,
ngw

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2012-08-09 16:11:15 Re: Slow query
Previous Message Merlin Moncure 2012-08-09 13:58:00 Re: JSON in 9.2: limitations