kimaidou <kimai...@gmail.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
