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(at)sss(dot)pgh(dot)pa(dot)us> a écrit :
> kimaidou <kimaidou(at)gmail(dot)com> 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
>