Re: [PERFORM] postgres not use index, IN statement

2011-05-23 Thread Craig Ringer
On 24/05/2011 5:30 AM, Anibal David Acosta wrote: So, this is some bug? Hard to know with the information provided. Please post EXPLAIN ANALYZE output. http://wiki.postgresql.org/wiki/SlowQueryQuestions -- Craig Ringer Tech-related writing at http://soapyfrogs.blogspot.com/ -- Sent via p

[PERFORM] postgres not use index, IN statement

2011-05-23 Thread Anibal David Acosta
I have a strange situation. I have a table of detail with millones of rows and a table of items with thousands of rows When I do.. select count(*) from wiz_application_response where application_item_id in (select id from wiz_application_item where application_id=110) This query NOT use the inde