Re: simple query running long time within a long transaction. - Mailing list pgsql-performance

From Andreas Kretschmer
Subject Re: simple query running long time within a long transaction.
Date
Msg-id e3320d41-1c26-b8f6-f7c1-f40768fc53e7@a-kretschmer.de
Whole thread Raw
In response to simple query running long time within a long transaction.  ("James Pang (chaolpan)" <chaolpan@cisco.com>)
Responses RE: simple query running long time within a long transaction.  ("James Pang (chaolpan)" <chaolpan@cisco.com>)
List 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 by date:

Previous
From: "James Pang (chaolpan)"
Date:
Subject: simple query running long time within a long transaction.
Next
From: "James Pang (chaolpan)"
Date:
Subject: RE: simple query running long time within a long transaction.