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

Поиск
Список
Период
Сортировка
От Joshua D. Drake
Тема Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...)
Дата
Msg-id 513688B9.5080504@commandprompt.com
обсуждение исходный текст
Ответ на Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...)  (Niels Kristian Schjødt <nielskristian@autouncle.com>)
Ответы Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...)  (Jeff Janes <jeff.janes@gmail.com>)
Список 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Niels Kristian Schjødt
Дата:
Сообщение: Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...)
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: sniff test on some PG 8.4 numbers