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 |
|---|---|---|
| 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 |