cursor - Search results

Mailing lists  >>  pgsql-performance  >>  Thread

2025-03-18 10:48:53 | Re: Bad perf when using DECLARE CURSOR on big table (kimaidou)

cursor_tuple_fraction TO 0.2 did the trick. Thanks for the hint Tom ! Le lun. 17 mars

Mailing lists  >>  pgsql-performance  >>  Thread

2025-03-17 18:22:57 | Re: Bad perf when using DECLARE CURSOR on big table (Tom Lane)

kimaidou writes: Raising cursor_tuple_fraction would probably help this case. regards, tom lane

Mailing lists  >>  pgsql-performance  >>  Thread

2025-03-17 17:41:07 | Bad perf when using DECLARE CURSOR on big table (kimaidou)

CURSOR query, then fetch data 2000 by 2000. I have seen that this DECLARE has bad perf