repeated - Search results in mailing lists
Mailing lists >> pgsql-performance >> Thread
2025-03-20 22:57:45 | Re: parallel pg_restore blocks on heavy random read I/O on all children processes (Dimitrios Apostolou)
repeat for the whole file? Consuming 15K IOPS for an hour. /Maybe/ something to improve
Mailing lists >> pgsql-performance >> Thread
2025-03-01 01:49:38 | Re: Slow performance of collate "en_US.utf8" (Thomas Munro)
repeated traversals, because the cache they ripped out wasn't pulling its own weight
Mailing lists >> pgsql-performance >> Thread
2025-01-07 22:30:33 | Re: Aggressive vacuum (Jeff Janes)
repeatedly) over the years, so this is important to know. Was the change noticeable because
Mailing lists >> pgsql-performance >> Thread
2024-11-08 05:27:28 | Re: Major performance degradation with joins in 15.8 or 15.7? (Andrei Lepikhov)
repeating the execution of the inner subquery. Postgres didn't want Materialize in this
Mailing lists >> pgsql-performance >> Thread
2024-10-24 22:48:57 | Re: Unexpected Performance for the Function simplify_function (Shiv Iyer)
Repeated Computation*: The simplification might be causing PostgreSQL to repeatedly compute certain expressions
Mailing lists >> pgsql-performance >> Thread >> Search in thread (4)
2024-10-05 12:23:56 | Performance degradation in Index searches with special characters (Andrey Stikheev)
repeat('<', 65536); ?column? ---------- (0 rows) Time: 4454.535 ms (00:04.455) testdb=# SELECT 1 FROM test
Mailing lists >> pgsql-performance >> Thread >> Search in thread (3)
2024-07-11 14:59:26 | RE: How to solve my slow disk i/o throughput during index scan (FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT))
repeat('a',128) || x FROM generate_series(1,1E5) AS x; ANALYZE t; SET enable
Mailing lists >> pgsql-performance >> Thread
2023-12-29 04:55:04 | Re: Parallel hints in PostgreSQL with consistent perfromance (Jeff Janes)
repeat them dozens of times in random order, and then do a statistical test to convince
Mailing lists >> pgsql-performance >> Thread >> Search in thread (2)
2023-10-31 21:43:57 | RE: Postgres Locking (Smith, Travis)
repeat(' .', lvl)||' '|| tree.pid as pid_tree, tree.pid, wldomart01a-> (clock_timestamp() - a.xact_start
Mailing lists >> pgsql-performance >> Thread
2023-08-04 15:15:40 | Re: Plan weirdness. A sort produces more rows than the node beneath it (Dane Foster)
repeat a LOT on the merge side. Dane On Fri, Aug 4, 2023 at 11:10 AM Tom Lane
Mailing lists >> pgsql-performance >> Thread
2023-06-25 06:29:00 | Fwd: Helping planner to chose sequential scan when it improves performance (Patrick O'Toole)
repeated ~1.3 million times. PLAN B (enable_indexscan off, effective cache same as before
Mailing lists >> pgsql-performance >> Thread
2023-06-18 20:57:11 | Re: Merge David and Goliath tables efficiently (nicolas paris)
repeated many times, since 2M batched by 500 rows. I add it again
Mailing lists >> pgsql-performance >> Thread
2023-02-14 05:53:54 | Re: For loop execution times in PostgreSQL 12 vs 15 (Pavel Stehule)
repeated). Another question is the cost of v1 calling notation. These functions require
Mailing lists >> pgsql-performance >> Thread
2023-02-08 18:01:23 | Domain check taking place unnecessarily? (Mark Hills)
repeatedly dropping and adding these columns. Reporting in case something is not as expected. I can't even
Mailing lists >> pgsql-performance >> Thread >> Search in thread (2)
2022-12-19 15:01:21 | Re: Fwd: temp_file_limit? (Frits Jalvingh)
with Postgres, but it's not an adventure I'd like to repeat right now ;)