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 |
|---|---|---|
| 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 | [email protected] | 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 | [email protected] | 23:19 |
| RE: Big performance slowdown from 11.2 to 13.3 | [email protected] | 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 | [email protected] | 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 | [email protected] | 23:44 |
| RE: Big performance slowdown from 11.2 to 13.3 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 | [email protected] | 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 |