cursor - Search results

Mailing lists  >>  pgsql-bugs  >>  Thread

2025-05-04 01:30:19 | Re: BUG #18909: Query creates millions of temporary files and stalls (Sergey Koposov)

cursor_tuple_fraction TO 1; SET wsdb=> EXPLAIN DECLARE c CURSOR FOR select phot_g_mean

Mailing lists  >>  pgsql-bugs  >>  Thread

2025-05-04 01:03:26 | Re: BUG #18909: Query creates millions of temporary files and stalls (Tom Lane)

choice in a parallel hash join. EXPLAIN DECLARE c CURSOR FOR SELECT ... regards, tom lane

Mailing lists  >>  pgsql-bugs  >>  Thread

2025-05-04 00:50:04 | Re: BUG #18909: Query creates millions of temporary files and stalls (Sergey Koposov)

cursor query. So summarizing: the query produces millions of files in 1) query through cursor

Mailing lists  >>  pgsql-bugs  >>  Thread

2025-05-03 19:11:35 | Re: BUG #18909: Query creates millions of temporary files and stalls (Sergey Koposov)

cursor = 42 } local_sigjmp_buf = {{ __jmpbuf = {0, -1720014361601319045, 94651820578848, 140737409496096, 0, 0, -1720014361379020933, -4902996912041042053}, __mask

Mailing lists  >>  pgsql-bugs  >>  Thread

2025-05-02 21:45:48 | BUG #18909: Query creates millions of temporary files and stalls (PG Bug reporting form)

cursor 2) set cursor_tuple_fraction TO 1 3) FETCH the result in 100,000 row chunks