Indeed, increasing cursor_tuple_fraction TO 0.2 did the trick.
Thanks for the hint Tom !
Le lun. 17 mars 2025 à 16:22, Tom Lane <tgl@xxxxxxxxxxxxx> a écrit :
kimaidou <kimaidou@xxxxxxxxx> writes:
> I have seen that this DECLARE has bad perf compared to a simple SQL query :
> Simple SQL query
> =====
> https://explain.dalibo.com/plan/042bc4dc2449adfe
> 96ms
> DECLARE CURSOR for the same query
> =====
> https://explain.dalibo.com/plan/bh83fc0db500a79g#
> 171 031 ms !!
Raising cursor_tuple_fraction would probably help this case.
regards, tom lane
