Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...)

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Niels Kristian Schjødt <nielskristian(at)autouncle(dot)com>
Cc: Julien Cigar <jcigar(at)ulb(dot)ac(dot)be>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...)
Date: 2013-03-06 00:07:21
Message-ID: 513688B9.5080504@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


On 03/05/2013 03:51 PM, Niels Kristian Schjødt wrote:

>> 3ms isn't slow
>>
> Sorry, it's 3323ms!
>
>>> Can I do anything to optimize that query or maybe the index or something?
>>
>> your index is already used
>
> Okay this leaves me with - "get better hardware" or?

What does explain analyze say versus just explain.

JD
--
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC
@cmdpromptinc - 509-416-6579

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2013-03-06 01:02:07 Re: sniff test on some PG 8.4 numbers
Previous Message Niels Kristian Schjødt 2013-03-05 23:51:42 Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1, key2, key3, key4...)