cursor - Search results in mailing lists
Mailing lists >> pgsql-performance >> Thread >> Search in thread (3)
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
Mailing lists >> pgsql-performance >> Thread >> Search in thread (6)
2025-02-26 17:27:53 | Efficient pagination using multi-column cursors (large.goose2829@salomvary.com)
cursors" aka. the "seek method" (as described in detail here: https:///sql/partial-results/fetch-next-page). The table (drastically
Mailing lists >> pgsql-performance >> Thread
2024-07-26 13:25:44 | Outer cost higher than the inner cost (Stanisław Skonieczny)
cursor_tuple_fraction is 1. The query is similar to: (there were more joins, but they
Mailing lists >> pgsql-performance >> Thread
2024-02-20 07:29:14 | Re: "not related" code blocks for removal of dead rows when using vacuum and this (Laurenz Albe)
modifying transactions, cursors or long-running queries open that constitutes a problem. Yours, Laurenz Albe
Mailing lists >> pgsql-performance >> Thread
2023-11-06 09:24:43 | Re: [EXTERNAL] Performance down with JDBC 42 (Frits Hoogland)
cursor. (Warning: shameless promotion) I did a writeup on JDBC clientside/serverside prepared statements and custom
Mailing lists >> pgsql-performance >> Thread >> Search in thread (2)
2023-05-23 11:42:53 | PostgreSQL performance on ARM i.MX6 (Druckenmueller, Marc)
cursor() while True: cur.execute("call dummy_call(%s,%s,%s, ARRAY[%s, %s, %s]::real
Mailing lists >> pgsql-performance >> Thread >> Search in thread (4)
2022-04-15 06:13:00 | RE: Query Tunning related to function (Kumar, Mukesh)
cursor. The view (we know it just by its name) used in the function is a black
Mailing lists >> pgsql-performance >> Thread
2022-02-24 03:37:59 | Slow plan choice with prepared query (Mark Saward)
cursor_row AS ( SELECT base.test_id FROM (select test_id::text, data from test
Mailing lists >> pgsql-performance >> Thread
2022-01-06 16:50:13 | Re: Same query 10000x More Time (Vijaykumar Jain)
cursor everytime for each matching id) and is still the *slowest.* 2022-01-06 22:10:48.665 IST [2318] LOG: execute
Mailing lists >> pgsql-performance >> Thread
2021-09-23 13:00:22 | hashjoins, index loops to retrieve pk/ux constrains in pg12 (Arturas Mazeika)
cursor_tuple_fraction 0.1 Sets the planner's estimate of the fraction of a cursor
Mailing lists >> pgsql-performance >> Thread
2021-08-29 16:03:02 | RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 (ldh@laurent-hasson.com)
cursor_tuple_fraction 0.1 [NULL] data_checksums off [NULL] data_directory C:/Program Files/PostgreSQL/13/data [NULL
Mailing lists >> pgsql-performance >> Thread
2021-07-22 11:32:51 | Partitioned table statistics vs autoanalyze (Kamil Frydel)
cursor thus, in order to avoid parallel query, I set max_parallel_workers_per_gather
Mailing lists >> pgsql-performance >> Thread
2021-07-08 21:19:48 | Re: Strange execution plan (Manuel Weitzman)
cursor pagination as the general concept. I'm not talking about Postgres cursors. Best regards
Mailing lists >> pgsql-performance >> Thread
2021-07-08 13:49:12 | Re: ETL - sql orchestrator is stuck when there is not sleep() between queries (Allan Barrielle)
cursor_tuple_fraction,0.1 DateStyle,"ISO, MDY" db_user_namespace,off deadlock_timeout,1s debug
Mailing lists >> pgsql-performance >> Thread >> Search in thread (8)
2021-07-02 14:30:13 | Re: slow performance with cursor (Tomas Vondra)
cursor, and which of them is the slow one. I suggest you identify which of the cursors