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
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.
Manually run this sql only show <100 shared_blks_hit and very small reads, but
for these 2