cursor - Search results

Mailing lists  >>  pgsql-sql  >>  Thread

2024-03-22 17:57:33 | Re: Cursor with hold for select takes too long (Tom Lane)

cursor execution as regular? Compare EXPLAIN SELECT ... versus EXPLAIN DECLARE x CURSOR FOR SELECT ... (I'm not sure

Mailing lists  >>  pgsql-sql  >>  Thread

2024-03-22 17:47:11 | Re: Cursor with hold for select takes too long (Bindra Bambharoliya)

Hi team, There is no order by, query returns 5341 rows. Query is like Select

Mailing lists  >>  pgsql-sql  >>  Thread

2024-03-22 17:39:39 | Re: Cursor with hold for select takes too long (Erik Brandsberg)

What is the actual query being done, and how many rows are being returned? Depending

Mailing lists  >>  pgsql-sql  >>  Thread

2024-03-22 16:50:04 | Cursor with hold for select takes too long (Bindra Bambharoliya)

cursor with hold for select. If I execute select quaery without cursor it takes 13 seconds