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: Plan differences | Anton Melser | 17:13 |
| Thread | Author | Time |
|---|---|---|
| Re: Plan differences | Adam Pearson | 09:04 |
| Proposal for unlogged tables | Mark Zealey | 09:59 |
| Re: Plan differences | Anton Melser | 13:30 |
| Re: Proposal for unlogged tables | Yves Dorfsman | 14:27 |
| Re: Proposal for unlogged tables | Mark Zealey | 14:38 |
| Re: Proposal for unlogged tables | Andres Freund | 16:12 |
| Re: Proposal for unlogged tables | Mark Zealey | 17:12 |
| Re: Proposal for unlogged tables | Andres Freund | 17:16 |
| Thread | Author | Time |
|---|---|---|
| Materialized view performance problems | Tom McLoughlin | 08:08 |
| Re: Materialized view performance problems | Andreas Kretschmer | 11:40 |
| Re: Materialized view performance problems | Tom McLoughlin | 13:27 |
| Queries intermittently slow | Scott Rankin | 14:58 |
| Re: Queries intermittently slow | Tom Lane | 15:19 |
| Re: Queries intermittently slow | Scott Rankin | 15:30 |
| Re: Queries intermittently slow | Tom Lane | 15:38 |
| Re: Queries intermittently slow | Scott Rankin | 15:56 |
| Re: Queries intermittently slow | Tom Lane | 16:14 |
| Re: Queries intermittently slow | Scott Rankin | 16:28 |
| Re: Queries intermittently slow | Tom Lane | 16:32 |
| Re: Materialized view performance problems | Andreas Kretschmer | 17:23 |
| Re: Queries intermittently slow | Scott Rankin | 18:01 |
| Thread | Author | Time |
|---|---|---|
| Re: Queries intermittently slow | Jim Nasby | 04:14 |
| Slow query help | Almir de Oliveira Duarte Junior | 04:17 |
| Re: Queries intermittently slow | Scott Rankin | 15:03 |
| Re: Queries intermittently slow | Tom Lane | 15:19 |
| Re: Queries intermittently slow | Scott Rankin | 15:43 |
| Re: Queries intermittently slow | Scott Rankin | 17:51 |
| Re: Queries intermittently slow | Rick Otten | 18:07 |
| Re: Queries intermittently slow | Tom Lane | 18:34 |
| Re: Slow query help | Rafael Bernard Rodrigues Araujo | 18:55 |
| Re: Slow query help | Marc Mamin | 19:15 |
| Re: Slow query help | Almir de Oliveira Duarte Junior | 19:30 |
| Re: Queries intermittently slow | Andres Freund | 19:47 |
| Re: Queries intermittently slow | Jim Nasby | 21:04 |
| Thread | Author | Time |
|---|---|---|
| How we made Postgres upserts 2-3* quicker than MongoDB | Mark Zealey | 16:37 |
| Re: How we made Postgres upserts 2-3* quicker than MongoDB | Nicolas Paris | 17:07 |
| Re: How we made Postgres upserts 2-3* quicker than MongoDB | Mark Zealey | 17:16 |
| Re: How we made Postgres upserts 2-3* quicker than MongoDB | Scott Marlowe | 17:43 |
| Thread | Author | Time |
|---|---|---|
| insert performance | Jinhua Luo | 05:57 |
| Re: insert performance | Jim Nasby | 21:05 |
| Thread | Author | Time |
|---|---|---|
| Re: insert performance | Jeff Janes | 19:20 |
| Re: Queries getting canceled inside a proc that seems to slow down randomly | Skarsol | 19:32 |
| Re: Queries getting canceled inside a proc that seems to slow down randomly | Jim Nasby | 19:39 |
| Re: Queries getting canceled inside a proc that seems to slow down randomly | Skarsol | 19:41 |
| Thread | Author | Time |
|---|---|---|
| Re: insert performance | Jinhua Luo | 10:03 |
| Re: insert performance | Jinhua Luo | 16:41 |
| Thread | Author | Time |
|---|---|---|
| Query order of magnitude slower with slightly different where clause | Adam Brusselback | 21:41 |
| Re: Query order of magnitude slower with slightly different where clause | David Rowley | 22:42 |
| Thread | Author | Time |
|---|---|---|
| Re: insert performance | Jinhua Luo | 04:50 |
| Thread | Author | Time |
|---|---|---|
| High Planning Time | Phil S | 00:30 |
| Re: insert performance | Jinhua Luo | 05:54 |
| Re: High Planning Time | Albe Laurenz | 07:59 |
| Re: High Planning Time | Vitalii Tymchyshyn | 14:11 |
| Re: High Planning Time | Tom Lane | 14:35 |
| Thread | Author | Time |
|---|---|---|
| Re: insert performance | Jim Nasby | 23:24 |
| Thread | Author | Time |
|---|---|---|
| Primary key index partially used | Florian Gossin | 15:52 |
| Re: Primary key index partially used | Igor Neyman | 16:01 |
| Re: Primary key index partially used | Igor Neyman | 16:02 |
| Thread | Author | Time |
|---|---|---|
| Postgres partitions-query scanning all child tables | rverghese | 22:09 |
| performance issue with inherited foreign table | Dzmitry Nikitsin | 23:46 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgres partitions-query scanning all child tables | Corey Huinker | 04:30 |
| Re: Postgres partitions-query scanning all child tables | rverghese | 06:10 |
| Re: Postgres partitions-query scanning all child tables | Corey Huinker | 07:47 |
| Re: Postgres partitions-query scanning all child tables | rverghese | 19:51 |
| Thread | Author | Time |
|---|---|---|
| Hash join gets slower as work_mem increases? | Albe Laurenz | 15:17 |
| Re: Hash join gets slower as work_mem increases? | Pavel Stehule | 15:21 |
| jsonb_agg performance | jfleming | 22:06 |
| Re: jsonb_agg performance | Andrew Dunstan | 23:34 |
| Thread | Author | Time |
|---|---|---|
| PostgreSQL seems to create inefficient plans in simple conditional joins | Hedayat Vatankhah | 12:30 |
| Re: Hash join gets slower as work_mem increases? | Tomas Vondra | 14:13 |
| Re: PostgreSQL seems to create inefficient plans in simple conditional joins | David Rowley | 15:57 |
| Re: PostgreSQL seems to create inefficient plans in simple conditional joins | Vitalii Tymchyshyn | 17:14 |
| Re: PostgreSQL seems to create inefficient plans in simple conditional joins | David Rowley | 17:31 |
| Re: PostgreSQL seems to create inefficient plans in simple conditional joins | Vitalii Tymchyshyn | 18:52 |
| Re: PostgreSQL seems to create inefficient plans in simple conditional joins | Hedayat Vatankhah | 21:50 |