Re: Query Performance question

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Re: Query Performance question
Дата
Msg-id lpvviu$en3$1@ger.gmane.org
обсуждение исходный текст
Ответ на Re: Query Performance question  ("Magers, James" <James.Magers@turner.com>)
Ответы Re: Query Performance question  ("Magers, James" <James.Magers@turner.com>)
Список pgsql-performance
Magers, James, 14.07.2014 04:20:

> Thank you for your feedback.  I am attaching the requested information.
> While I do not think the query is necessarily inefficient, I believe  a sequence scan would be more efficient.

You can try

set enable_indexscan = off;
set enable_bitmapscan = off;

and then run your query.

But I would be very surprised if a seq scan (which reads through the whole table) was faster than those 4ms you have
now


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

Предыдущее
От: "Magers, James"
Дата:
Сообщение: Re: Query Performance question
Следующее
От: "Magers, James"
Дата:
Сообщение: Re: Query Performance question