Re: Query Performance question

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

Thank you for the recommendation.  In this case, The bitmap scan runs quite quickly, however in production were data
mayor may not be cached and at higher volumes I am trying to ensure the process will continue to execute efficiently
andreduce the impact of the process on other processes running against the database.  
 

My assessment is based on my experiences with the scans.  Does your experience provide you with a different assessment
ofthe scan types and how efficient they may be?
 

Thank you,
James




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

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