Re: simple query running long time within a long transaction.

Поиск
Список
Период
Сортировка
От Andreas Kretschmer
Тема Re: simple query running long time within a long transaction.
Дата
Msg-id e3320d41-1c26-b8f6-f7c1-f40768fc53e7@a-kretschmer.de
обсуждение исходный текст
Ответ на simple query running long time within a long transaction.  ("James Pang (chaolpan)" <chaolpan@cisco.com>)
Ответы RE: simple query running long time within a long transaction.  ("James Pang (chaolpan)" <chaolpan@cisco.com>)
Список pgsql-performance
Дерево обсуждения 

Am 17.11.23 um 09:10 schrieb James Pang (chaolpan):
>
> Hi,
>
>    We found one simple query manually run very fast(finished in 
> several milliseconds), but there are 2 sessions within long 
> transaction to run same sql with same bind variables took tens of seconds.
>
you try to set plan_cache_mode to force_custom_plan, default is auto and 
with that and bind variables pg will use a generic plan.


Regards, Andreas

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

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

Предыдущее
От: "James Pang (chaolpan)"
Дата:
Сообщение: simple query running long time within a long transaction.
Следующее
От: "James Pang (chaolpan)"
Дата:
Сообщение: RE: simple query running long time within a long transaction.