Re: Query runtime differences- trying to understand why.

Поиск
Список
Период
Сортировка
От Andreas Kretschmer
Тема Re: Query runtime differences- trying to understand why.
Дата
Msg-id 8c86407b-a9c3-2e21-afeb-b948fe240fe7@a-kretschmer.de
обсуждение исходный текст
Ответ на Query runtime differences- trying to understand why.  ("Dirschel, Steve" <steve.dirschel@thomsonreuters.com>)
Ответы RE: [EXT] Re: Query runtime differences- trying to understand why.
Список pgsql-general
Дерево обсуждения 

Am 29.11.23 um 21:25 schrieb Dirschel, Steve:
>
> I have a question on the execution time of a query and the 
> fluctuations I'm seeing.  I enabled auto_trace to capture some actual 
> executions of a query by an app.  Below are 2 executions of it.  The 
> top one took 1.697 milliseconds. The 2nd one took 31.241 
> milliseconds.  Note the query has hints in it
>

what database are you using? PostgreSQL doesn't hav hints...

Regards, Andreas

-- 
Andreas Kretschmer - currently still (garden leave)
Technical Account Manager (TAM)
www.enterprisedb.com

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

Предыдущее
От: "Dirschel, Steve"
Дата:
Сообщение: Query runtime differences- trying to understand why.
Следующее
От: "Dirschel, Steve"
Дата:
Сообщение: RE: [EXT] Re: Query runtime differences- trying to understand why.