Discussion of PostgreSQL's performance issues. Please see Guide to reporting problems and Slow Query Questions for some tips on how to write your performance question.
| Thread | Author | Time |
|---|---|---|
| PostgreSQL V13 Replication Issue | Haseeb Khan | 16:25 |
| Re: PostgreSQL V13 Replication Issue | Dean Gibson (DB Administrator) | 16:30 |
| Thread | Author | Time |
|---|---|---|
| Estimating wal_keep_size | Dean Gibson (DB Administrator) | 00:36 |
| Re: Estimating wal_keep_size | Julien Rouhaud | 01:02 |
| Re: PostgreSQL V13 Replication Issue | Michael Paquier | 01:02 |
| Thread | Author | Time |
|---|---|---|
| Re: Estimating wal_keep_size | Dean Gibson (DB Administrator) | 18:13 |
| Re: Estimating wal_keep_size | Julien Rouhaud | 18:27 |
| Re: Estimating wal_keep_size | Vijaykumar Jain | 18:40 |
| Thread | Author | Time |
|---|---|---|
| Re: Planning performance problem (67626.278ms) 📎 | Manuel Weitzman | 00:09 |
| Re: Planning performance problem (67626.278ms) | Tom Lane | 21:06 |
| Re: Planning performance problem (67626.278ms) | Ranier Vilela | 23:23 |
| Re: Estimating wal_keep_size | Dean Gibson (DB Administrator) | 23:53 |
| Thread | Author | Time |
|---|---|---|
| Re: Planning performance problem (67626.278ms) | Tom Lane | 00:17 |
| Thread | Author | Time |
|---|---|---|
| Partition column should be part of PK | Nagaraj Raj | 03:10 |
| Re: Partition column should be part of PK | Justin Pryzby | 04:22 |
| slow performance with cursor | Ayub Khan | 16:09 |
| Re: slow performance with cursor | Justin Pryzby | 16:21 |
| Re: slow performance with cursor | Ayub Khan | 16:37 |
| Re: slow performance with cursor | Tom Lane | 18:04 |
| Thread | Author | Time |
|---|---|---|
| Re: Planning performance problem (67626.278ms) | Manuel Weitzman | 19:26 |
| Re: Planning performance problem (67626.278ms) | Tom Lane | 19:43 |
| Re: Planning performance problem (67626.278ms) 📎 | Manuel Weitzman | 21:35 |
| Re: Planning performance problem (67626.278ms) | Tom Lane | 22:31 |
| Thread | Author | Time |
|---|---|---|
| Re: Planning performance problem (67626.278ms) | Manuel Weitzman | 20:56 |
| Thread | Author | Time |
|---|---|---|
| Re: slow performance with cursor | Ayub Khan | 16:29 |
| Re: slow performance with cursor | Justin Pryzby | 16:32 |
| Re: slow performance with cursor | Ayub Khan | 20:25 |
| Re: Planning performance problem (67626.278ms) 📎 | Manuel Weitzman | 20:49 |
| Thread | Author | Time |
|---|---|---|
| Re: Planning performance problem (67626.278ms) | David Rowley | 09:55 |
| Re: slow performance with cursor | Tomas Vondra | 14:30 |
| Thread | Author | Time |
|---|---|---|
| Re: hint in determining effective_io_concurrency | Merlin Moncure | 21:42 |
| ETL - sql orchestrator is stuck when there is not sleep() between queries | Allan Barrielle | 23:00 |
| Thread | Author | Time |
|---|---|---|
| Re: Strange execution plan | Manuel Weitzman | 02:00 |
| Re: Partition column should be part of PK | Nagaraj Raj | 03:32 |
| Re: Partition column should be part of PK | Christophe Pettus | 03:52 |
| Thread | Author | Time |
|---|---|---|
| Re: Partition column should be part of PK | Nagaraj Raj | 00:36 |
| Re: Partition column should be part of PK | Justin Pryzby | 00:38 |
| Re: Partition column should be part of PK | Christophe Pettus | 00:47 |
| Re: Partition column should be part of PK | David Rowley | 00:57 |
| Re: Partition column should be part of PK | Thomas Kellerer | 06:00 |
| RE: Partition column should be part of PK | Michel SALAIS | 09:56 |
| Re: temporary file log lines | Laurenz Albe | 12:01 |
| Re: temporary file log lines | MichaelDBA | 12:13 |
| Thread | Author | Time |
|---|---|---|
| Re: temporary file log lines | Guillaume Lelarge | 07:29 |
| Re: temporary file log lines | Tomas Vondra | 18:01 |
| Thread | Author | Time |
|---|---|---|
| Linear slow-down while inserting into a table with an ON INSERT trigger ? | Tobias Gierke | 21:27 |
| Thread | Author | Time |
|---|---|---|
| Re: Linear slow-down while inserting into a table with an ON INSERT trigger ? | Justin Pryzby | 04:40 |
| Re: Linear slow-down while inserting into a table with an ON INSERT trigger ? | Benjamin Scherrey | 06:48 |
| Re: Linear slow-down while inserting into a table with an ON INSERT trigger ? | David Rowley | 07:02 |
| Re: Linear slow-down while inserting into a table with an ON INSERT trigger ? | Tom Lane | 14:33 |
| Thread | Author | Time |
|---|---|---|
| Re: Linear slow-down while inserting into a table with an ON INSERT trigger ? | Ninad Shah | 06:52 |
| Re: Linear slow-down while inserting into a table with an ON INSERT trigger ? | Tobias Gierke | 07:19 |
| Re: Linear slow-down while inserting into a table with an ON INSERT trigger ? | Tobias Gierke | 07:25 |
| Re: Linear slow-down while inserting into a table with an ON INSERT trigger ? | Tobias Gierke | 07:36 |
| Thread | Author | Time |
|---|---|---|
| Re: Linear slow-down while inserting into a table with an ON INSERT trigger ? | Laurenz Albe | 05:45 |
| Performance benchmark of PG | Manish Lad | 10:09 |
| Re: Performance benchmark of PG | Laurenz Albe | 11:04 |
| Re: Performance benchmark of PG | Manish Lad | 11:09 |
| Re: Performance benchmark of PG | Hüseyin Demir | 11:17 |
| Re: Performance benchmark of PG | Thomas Kellerer | 11:19 |
| Re: Performance benchmark of PG | Manish Lad | 11:23 |
| Re: Performance benchmark of PG | Ninad Shah | 16:48 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance benchmark of PG | Manish Lad | 07:56 |
| Thread | Author | Time |
|---|---|---|
| Query Performance 📎 | Dirschel, Steve | 17:13 |
| Re: Query Performance | Tom Lane | 18:03 |
| Big performance slowdown from 11.2 to 13.3 | ldh@laurent-hasson.com | 18:50 |
| Re: Big performance slowdown from 11.2 to 13.3 | Justin Pryzby | 19:15 |
| Re: Big performance slowdown from 11.2 to 13.3 | Michael Lewis | 22:12 |
| RE: Big performance slowdown from 11.2 to 13.3 | ldh@laurent-hasson.com | 23:19 |
| RE: Big performance slowdown from 11.2 to 13.3 | ldh@laurent-hasson.com | 23:31 |
| Re: Big performance slowdown from 11.2 to 13.3 | Peter Geoghegan | 23:33 |
| Re: Big performance slowdown from 11.2 to 13.3 | Tom Lane | 23:35 |
| RE: Big performance slowdown from 11.2 to 13.3 | ldh@laurent-hasson.com | 23:37 |
| Re: Big performance slowdown from 11.2 to 13.3 | Tom Lane | 23:43 |
| RE: Big performance slowdown from 11.2 to 13.3 | ldh@laurent-hasson.com | 23:44 |
| RE: Big performance slowdown from 11.2 to 13.3 | ldh@laurent-hasson.com | 23:45 |
| Thread | Author | Time |
|---|---|---|
| Re: Big performance slowdown from 11.2 to 13.3 | Vijaykumar Jain | 14:45 |
| RE: Big performance slowdown from 11.2 to 13.3 | ldh@laurent-hasson.com | 17:17 |
| Re: Performance Issue on a table | Justin Pryzby | 18:18 |
| Thread | Author | Time |
|---|---|---|
| Re: Big performance slowdown from 11.2 to 13.3 | Tom Lane | 18:08 |
| Thread | Author | Time |
|---|---|---|
| RE: Big performance slowdown from 11.2 to 13.3 | ldh@laurent-hasson.com | 05:12 |
| Performance of lateral join | Simen Andreas Andreassen Lønsethagen | 13:56 |
| Re: Performance of lateral join | Justin Pryzby | 18:17 |
| Query performance ! 📎 | kenny a | 23:59 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance of lateral join 📎 | Simen Andreas Andreassen Lønsethagen | 09:08 |
| Query performance ! | kenny a | 17:14 |
| Re: Query performance ! | Bruce Momjian | 17:18 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance of lateral join | Justin Pryzby | 02:27 |
| RE: Big performance slowdown from 11.2 to 13.3 | ldh@laurent-hasson.com | 02:57 |
| Re: Big performance slowdown from 11.2 to 13.3 | David G. Johnston | 03:06 |
| Re: Big performance slowdown from 11.2 to 13.3 | Tom Lane | 03:15 |
| Re: Big performance slowdown from 11.2 to 13.3 | Tom Lane | 03:31 |
| RE: Big performance slowdown from 11.2 to 13.3 | ldh@laurent-hasson.com | 20:12 |
| Thread | Author | Time |
|---|---|---|
| Re: Query performance ! | Justin Pryzby | 15:10 |
| Thread | Author | Time |
|---|---|---|
| Performance issue with thousands of calls to procedures and functions? 📎 | Daniel Westermann (DWE) | 07:12 |
| Re: Performance issue with thousands of calls to procedures and functions? | Imre Samu | 08:01 |
| Re: Performance issue with thousands of calls to procedures and functions? | Pavel Stehule | 08:04 |
| Re: Performance issue with thousands of calls to procedures and functions? | Pavel Stehule | 08:07 |
| Re: Performance issue with thousands of calls to procedures and functions? | Pavel Stehule | 08:11 |
| Re: Performance issue with thousands of calls to procedures and functions? | Daniel Westermann (DWE) | 08:12 |
| Re: Performance issue with thousands of calls to procedures and functions? | Pavel Stehule | 08:21 |
| Re: Performance issue with thousands of calls to procedures and functions? | Daniel Westermann (DWE) | 11:15 |
| Thread | Author | Time |
|---|---|---|
| Logical Replication speed-up initial data | Nikhil Shetty | 15:06 |
| Re: Logical Replication speed-up initial data | Hüseyin Demir | 15:24 |
| Re: Logical Replication speed-up initial data | Stefano Amoroso | 15:55 |
| Re: Logical Replication speed-up initial data | Christophe Pettus | 16:28 |
| Thread | Author | Time |
|---|---|---|
| Re: Logical Replication speed-up initial data | Nikhil Shetty | 04:56 |
| Re: Logical Replication speed-up initial data | Nikhil Shetty | 04:57 |
| Re: Logical Replication speed-up initial data | Rick Otten | 13:25 |
| Re: Logical Replication speed-up initial data | Vijaykumar Jain | 14:27 |
| Re: Logical Replication speed-up initial data | Avinash Kumar | 15:11 |
| Re: Logical Replication speed-up initial data | Nikhil Shetty | 18:41 |
| Re: Logical Replication speed-up initial data | Nikhil Shetty | 18:45 |
| Re: Logical Replication speed-up initial data | Vijaykumar Jain | 19:20 |
| Re: Logical Replication speed-up initial data | Jeff Janes | 20:03 |
| Thread | Author | Time |
|---|---|---|
| Slow query because lexeme index not used | Alex | 19:35 |
| Thread | Author | Time |
|---|---|---|
| Re: Slow query because lexeme index not used | Justin Pryzby | 00:35 |
| Re: Slow query because lexeme index not used | Alex | 09:43 |
| Thread | Author | Time |
|---|---|---|
| Postgres using the wrong index index | Matt Dupree | 16:47 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgres using the wrong index index | Justin Pryzby | 12:38 |
| difference between pg_triggers and information_schema.triggers | aditya desai | 18:28 |
| Re: difference between pg_triggers and information_schema.triggers | David G. Johnston | 18:37 |
| Re: difference between pg_triggers and information_schema.triggers | aditya desai | 18:54 |
| PostgreSQL equivalent of UTL_HTTP | aditya desai | 18:56 |
| Re: PostgreSQL equivalent of UTL_HTTP | Pavel Stehule | 19:13 |
| Re: Postgres using the wrong index index | Matt Dupree | 19:56 |
| Re: Postgres using the wrong index index | Mladen Gogala | 21:45 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgres using the wrong index index | Justin Pryzby | 03:45 |
| Re: Postgres using the wrong index index | Matt Dupree | 13:38 |
| Re: Postgres using the wrong index index | Justin Pryzby | 23:20 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgres using the wrong index index | Matt Dupree | 15:22 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgres using the wrong index index | Justin Pryzby | 18:52 |
| Thread | Author | Time |
|---|---|---|
| RE: Big performance slowdown from 11.2 to 13.3 | ldh@laurent-hasson.com | 05:42 |
| Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 | ldh@laurent-hasson.com | 07:56 |
| RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 | ldh@laurent-hasson.com | 08:55 |
| Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 | Tom Lane | 15:04 |
| Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 | Mladen Gogala | 15:29 |
| RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 | ldh@laurent-hasson.com | 16:01 |
| Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 | Tom Lane | 18:04 |
| Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 | Tom Lane | 18:17 |
| Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 | Justin Pryzby | 19:19 |
| Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 | Maciek Sakrejda | 20:58 |