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: proposal: schema variables 📎 | Pavel Stehule | 19:25 |
| Thread | Author | Time |
|---|---|---|
| A serious change in performance between PG 15 and PG 16, 17, 18. | Clive Boughton | 03:49 |
| Re: A serious change in performance between PG 15 and PG 16, 17, 18. | Tom Lane | 04:03 |
| Re: A serious change in performance between PG 15 and PG 16, 17, 18. | David Rowley | 04:04 |
| Re: A serious change in performance between PG 15 and PG 16, 17, 18. | David G. Johnston | 04:04 |
| Re: A serious change in performance between PG 15 and PG 16, 17, 18. | Andrei Lepikhov | 09:05 |
| Re: Postgres IO sweet spot | Riaan Stander | 14:57 |
| Re: Postgres IO sweet spot | Greg Sabino Mullane | 15:34 |
| Re: A serious change in performance between PG 15 and PG 16, 17, 18. | Joe Conway | 15:42 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgres IO sweet spot | Riaan Stander | 23:42 |
| Thread | Author | Time |
|---|---|---|
| Re: A serious change in performance between PG 15 and PG 16, 17, 18. | David Rowley | 00:01 |
| Re: A serious change in performance between PG 15 and PG 16, 17, 18. | Clive Boughton | 01:05 |
| Thread | Author | Time |
|---|---|---|
| unstable query plan on pg 16,17,18 | Attila Soki | 09:37 |
| Re: unstable query plan on pg 16,17,18 | Laurenz Albe | 09:41 |
| Re: LATERAL subquery predicate pushdown: filter applied after JSON construction instead of inside join (PG 18) | Nyasha Chigwamba | 10:52 |
| MERGE INTO... WHEN NOT MATCHED BY SOURCE index usage | Lea Führer | 14:18 |
| Re: unstable query plan on pg 16,17,18 | Attila Soki | 15:10 |
| Re: unstable query plan on pg 16,17,18 | Andrei Lepikhov | 15:54 |
| Re: unstable query plan on pg 16,17,18 | Attila Soki | 17:03 |
| Re: unstable query plan on pg 16,17,18 | Laurenz Albe | 19:59 |
| Re: unstable query plan on pg 16,17,18 | Andrei Lepikhov | 20:25 |
| Re: unstable query plan on pg 16,17,18 | Attila Soki | 20:42 |
| Re: unstable query plan on pg 16,17,18 | Laurenz Albe | 20:54 |
| Re: unstable query plan on pg 16,17,18 | Attila Soki | 21:19 |
| Re: unstable query plan on pg 16,17,18 | Laurenz Albe | 21:44 |
| Thread | Author | Time |
|---|---|---|
| Re: unstable query plan on pg 16,17,18 | Andrei Lepikhov | 09:11 |
| Re: unstable query plan on pg 16,17,18 | Attila Soki | 09:16 |
| Re: unstable query plan on pg 16,17,18 | Andrei Lepikhov | 11:09 |
| Re: unstable query plan on pg 16,17,18 | Attila Soki | 11:37 |
| Re: unstable query plan on pg 16,17,18 | Attila Soki | 15:50 |
| Re: unstable query plan on pg 16,17,18 | Andrei Lepikhov | 15:57 |
| Re: unstable query plan on pg 16,17,18 | Attila Soki | 16:48 |
| Re: unstable query plan on pg 16,17,18 📎 | Andrei Lepikhov | 19:20 |
| Thread | Author | Time |
|---|---|---|
| Re: MERGE INTO... WHEN NOT MATCHED BY SOURCE index usage | Feike Steenbergen | 16:35 |
| Thread | Author | Time |
|---|---|---|
| Re: unstable query plan on pg 16,17,18 | Attila Soki | 16:15 |
| Re: unstable query plan on pg 16,17,18 | Attila Soki | 16:22 |
| Re: unstable query plan on pg 16,17,18 | Laurenz Albe | 20:53 |
| Thread | Author | Time |
|---|---|---|
| Re: unstable query plan on pg 16,17,18 | Andrei Lepikhov | 08:15 |
| Re: unstable query plan on pg 16,17,18 | Attila Soki | 15:00 |
| Re: unstable query plan on pg 16,17,18 | Andrei Lepikhov | 15:35 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables | Haritabh Gupta | 10:02 |
| Re: proposal: schema variables | Pavel Stehule | 19:15 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 12:54 |
| Planner join order regression from PG 15 to PG 16+: 70ms -> 1440ms (self-contained reproducer included) 📎 | Mauro Gatti | 16:25 |
| Re: Planner join order regression from PG 15 to PG 16+: 70ms -> 1440ms (self-contained reproducer included) 📎 | Andrei Lepikhov | 19:09 |
| Re: Planner join order regression from PG 15 to PG 16+: 70ms -> 1440ms (self-contained reproducer included) | Tom Lane | 21:44 |
| Thread | Author | Time |
|---|---|---|
| Re: Planner join order regression from PG 15 to PG 16+: 70ms -> 1440ms (self-contained reproducer included) | Mauro Gatti | 08:24 |
| Re: Planner join order regression from PG 15 to PG 16+: 70ms -> 1440ms (self-contained reproducer included) | Andrei Lepikhov | 09:05 |
| Re: proposal: schema variables 📎 | Pavel Stehule | 09:06 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgres IO sweet spot | Merlin Moncure | 23:07 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 07:54 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 19:29 |
| postgres chooses objectively wrong index | Merlin Moncure | 21:01 |
| Re: postgres chooses objectively wrong index | Alexey Ermakov | 22:16 |
| Re: postgres chooses objectively wrong index | Tom Lane | 22:24 |
| Re: postgres chooses objectively wrong index | Merlin Moncure | 22:52 |
| Thread | Author | Time |
|---|---|---|
| Re: postgres chooses objectively wrong index | Alexey Ermakov | 05:27 |
| Re: proposal: schema variables 📎 | Pavel Stehule | 06:35 |
| Re: postgres chooses objectively wrong index | Merlin Moncure | 18:38 |
| Re: postgres chooses objectively wrong index | Alexey Ermakov | 20:12 |
| Re: postgres chooses objectively wrong index | Merlin Moncure | 22:42 |
| Thread | Author | Time |
|---|---|---|
| Re: postgres chooses objectively wrong index | Andrei Lepikhov | 07:09 |
| Thread | Author | Time |
|---|---|---|
| Re: postgres chooses objectively wrong index | Merlin Moncure | 21:58 |
| Thread | Author | Time |
|---|---|---|
| Re: postgres chooses objectively wrong index | Andrei Lepikhov | 09:21 |
| Thread | Author | Time |
|---|---|---|
| Re: postgres chooses objectively wrong index | Merlin Moncure | 16:53 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 05:18 |
| Thread | Author | Time |
|---|---|---|
| Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 | Scott Carey | 09:28 |
| Re: proposal: schema variables 📎 | Pavel Stehule | 11:07 |
| Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 | David Rowley | 12:03 |
| Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 | Scott Carey | 17:55 |
| Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 | Scott Carey | 18:06 |
| Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 | Tom Lane | 19:26 |
| Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 | David Rowley | 22:48 |
| Thread | Author | Time |
|---|---|---|
| Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 | Scott Carey | 07:04 |
| Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 | Scott Carey | 07:18 |
| Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 | David Rowley | 11:12 |
| Potential partition pruning regression on PostgreSQL 18 | Cándido Antonio Martínez Descalzo | 11:56 |
| Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 | Tom Lane | 13:44 |
| Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 | Scott Carey | 17:50 |
| Re: Potential partition pruning regression on PostgreSQL 18 | David Rowley | 23:00 |
| Thread | Author | Time |
|---|---|---|
| Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 | Scott Carey | 07:23 |
| Re: Potential partition pruning regression on PostgreSQL 18 📎 | Richard Guo | 07:34 |
| Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 📎 | Tom Lane | 17:38 |
| Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 | Scott Carey | 19:08 |
| Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 | Tom Lane | 22:03 |
| Thread | Author | Time |
|---|---|---|
| Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 📎 | Frank Heikens | 04:19 |
| Re: proposal: schema variables 📎 | Pavel Stehule | 05:15 |
| Re: proposal: schema variables 📎 | Pavel Stehule | 19:10 |
| Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 | Tom Lane | 19:24 |
| Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 | Jeff Davis | 19:24 |
| Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 | Jeff Davis | 19:36 |
| Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 | Tom Lane | 19:56 |
| Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 | Jeff Davis | 20:01 |
| Thread | Author | Time |
|---|---|---|
| Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 | David Rowley | 00:21 |
| Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 | Tomas Vondra | 12:18 |
| Thread | Author | Time |
|---|---|---|
| Linux 7.0 performance degradation | Rick Otten | 14:12 |
| Re: Linux 7.0 performance degradation | Andreas Karlsson | 14:59 |
| Thread | Author | Time |
|---|---|---|
| Re: Potential partition pruning regression on PostgreSQL 18 📎 | Richard Guo | 08:00 |
| Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 | Jeff Davis | 21:58 |
| Thread | Author | Time |
|---|---|---|
| Re: Potential partition pruning regression on PostgreSQL 18 | Richard Guo | 08:05 |
| Async standby lag + physical slot + hot_standby_feedback=on appeared to degrade primary performance | Priya V | 22:39 |
| Thread | Author | Time |
|---|---|---|
| Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 | David Rowley | 02:09 |
| Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 | David Rowley | 02:42 |
| how to switch user in postgres | ikramuddin | 17:55 |
| Re: how to switch user in postgres | Pavel Stehule | 18:00 |
| Re: how to switch user in postgres | David G. Johnston | 18:33 |
| Re: how to switch user in postgres | Tom Lane | 19:29 |
| Thread | Author | Time |
|---|---|---|
| Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 📎 | Jeff Davis | 20:42 |
| Thread | Author | Time |
|---|---|---|
| table bloat very fast and free space can not be reused | James Pang | 01:28 |
| Re: table bloat very fast and free space can not be reused | Christophe Pettus | 03:56 |
| Re: table bloat very fast and free space can not be reused | James Pang | 07:22 |
| Re: table bloat very fast and free space can not be reused | Kristjan Mustkivi | 11:43 |
| Thread | Author | Time |
|---|---|---|
| Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 | David Rowley | 04:40 |
| Re: table bloat very fast and free space can not be reused | Rick Otten | 14:39 |
| Thread | Author | Time |
|---|---|---|
| Re: table bloat very fast and free space can not be reused | Kristjan Mustkivi | 08:33 |
| feature request: index supported REINDEX for partial indexes on needle/haystack tables | Merlin Moncure | 17:22 |
| Thread | Author | Time |
|---|---|---|
| Query performance | Dirschel, Steve-CW | 15:52 |
| Thread | Author | Time |
|---|---|---|
| Re: Query performance | Laurenz Albe | 05:33 |
| Thread | Author | Time |
|---|---|---|
| Re: Unexpected Seq Scan's when using MERGE WHEN NOT MATCHED BY SOURCE | Viktor Holmberg | 11:47 |
| Thread | Author | Time |
|---|---|---|
| Postgres DB backup is taking too much time | masheed ullah | 09:42 |
| Re: Postgres DB backup is taking too much time | manish yadav | 17:16 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgres DB backup is taking too much time | Greg Sabino Mullane | 00:20 |
| Re: Postgres DB backup is taking too much time | Ilya Anfimov | 09:29 |
| Re: Postgres DB backup is taking too much time | masheed ullah | 09:58 |
| Re: Postgres DB backup is taking too much time 📎 | Gerald Drouillard | 10:10 |
| Re: Postgres DB backup is taking too much time | Ilya Anfimov | 11:11 |
| Re: Improving PostgreSQL insert performance | Русинов Семен | 18:03 |
| Improving insert performance | Русинов Семен | 19:01 |
| Re: Improving insert performance | Laurenz Albe | 20:49 |
| Thread | Author | Time |
|---|---|---|
| Re: Significant performance issues with array_agg() + HashAggregate plans on Postgres 17 📎 | Jeff Davis | 01:27 |
| Re: Improving insert performance | Greg Sabino Mullane | 03:05 |
| Thread | Author | Time |
|---|---|---|
| Re: Improving insert performance | Roland Müller | 03:31 |
| Thread | Author | Time |
|---|---|---|
| Unexpected seq scan on table with JSONB column | Jan Jongen | 08:33 |
| Re: Improving insert performance | Merlin Moncure | 17:59 |