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

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...)
Дата
Msg-id CAMkU=1zz9Rc=TU5ee+x9BtWD7z1kYsSYJ3Jbp0f4_rTqJN+Cpg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...)  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-performance
Дерево обсуждения
On Tue, Mar 5, 2013 at 4:07 PM, Joshua D. Drake <jd@commandprompt.com> wrote:

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.


Better yet, "explain (analyze, buffers)" with track_io_timing turned on.

Cheers,

Jeff

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

Предыдущее
От: David Leverton
Дата:
Сообщение: Poor plan when joining against a union containing a join
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Poor plan when joining against a union containing a join