Re: Query Performance question

Поиск
Список
Период
Сортировка
От Magers, James
Тема Re: Query Performance question
Дата
Msg-id 1bd268ebd99945d6b16d12cca39893c8@CO2PR07MB601.namprd07.prod.outlook.com
обсуждение исходный текст
Ответ на Re: Query Performance question  (Thomas Kellerer <spam_eater@gmx.net>)
Ответы Re: Query Performance question  ("Tomas Vondra" <tv@fuzzy.cz>)
Список pgsql-performance
Thomas,

I would have to agree that the current results do indicate that.  However, I have run this explain analyze multiple
timesand the timing varies from about 4ms to 35ms using the Bitmap Heap Scan.  Here is an explain plan from Thursday of
lastweek that shows about 21ms.  Part of the issue in trying to isolate if the query can be faster is that once the
datais cached any way that the query is executed appears to be quicker.
 

http://explain.depesz.com/s/SIX1

Thank you,
James

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

Предыдущее
От: Thomas Kellerer
Дата:
Сообщение: Re: Query Performance question
Следующее
От: "Tomas Vondra"
Дата:
Сообщение: Re: Query Performance question