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 | 07:01 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 07:16 |
| Thread | Author | Time |
|---|---|---|
| Postgresql 14/15/16/17 partition pruning on dependent table during join | Stepan Yankevych | 13:21 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables | Laurenz Albe | 05:46 |
| Re: proposal: schema variables | Pavel Stehule | 07:36 |
| Re: Postgresql 14/15/16/17 partition pruning on dependent table during join | Vijaykumar Jain | 20:21 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgresql 14/15/16/17 partition pruning on dependent table during join | Andrei Lepikhov | 02:42 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgresql 14/15/16/17 partition pruning on dependent table during join | Stepan Yankevych | 08:23 |
| Performance of Query 2 in TPC-H | Ba Jinsheng | 08:42 |
| Re: proposal: schema variables | Laurenz Albe | 09:24 |
| Re: Postgresql 14/15/16/17 partition pruning on dependent table during join | Andrei Lepikhov | 12:05 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance of Query 2 in TPC-H 📎 | Andrei Lepikhov | 02:22 |
| Re: Bloom filters and the planner / parallel execution | Rafia Sabih | 13:22 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 18:24 |
| Thread | Author | Time |
|---|---|---|
| Major performance degradation with joins in 15.8 or 15.7? | Ed Sabol | 21:54 |
| Re: Major performance degradation with joins in 15.8 or 15.7? | David Rowley | 22:18 |
| Thread | Author | Time |
|---|---|---|
| Re: Major performance degradation with joins in 15.8 or 15.7? | Ed Sabol | 01:21 |
| Re: Major performance degradation with joins in 15.8 or 15.7? | Andrei Lepikhov | 02:27 |
| Re: Major performance degradation with joins in 15.8 or 15.7? | Ed Sabol | 02:45 |
| Re: Major performance degradation with joins in 15.8 or 15.7? | Andrei Lepikhov | 02:54 |
| tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4 | Achilleas Mantzios | 19:32 |
| Re: Major performance degradation with joins in 15.8 or 15.7? | Ed Sabol | 20:32 |
| Thread | Author | Time |
|---|---|---|
| Re: Major performance degradation with joins in 15.8 or 15.7? | Andrei Lepikhov | 01:21 |
| Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4 | Tomas Vondra | 10:49 |
| Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4 | Achilleas Mantzios | 14:05 |
| Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4 | Achilleas Mantzios | 14:08 |
| Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4 | Tomas Vondra | 15:41 |
| Thread | Author | Time |
|---|---|---|
| Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4 | Achilleas Mantzios | 09:45 |
| Re: proposal: schema variables | Dmitry Dolgov | 15:24 |
| Re: proposal: schema variables | Pavel Stehule | 16:19 |
| Re: proposal: schema variables | Dmitry Dolgov | 17:41 |
| Re: proposal: schema variables | Pavel Stehule | 17:51 |
| Re: proposal: schema variables | Pavel Stehule | 18:04 |
| Re: proposal: schema variables | Pavel Stehule | 18:09 |
| Performance of Query 4 on TPC-DS Benchmark | Ba Jinsheng | 19:35 |
| Re: Performance of Query 4 on TPC-DS Benchmark | Thomas Munro | 19:58 |
| Re: Performance of Query 4 on TPC-DS Benchmark | Alena Rybakina | 20:16 |
| Re: Performance of Query 4 on TPC-DS Benchmark | Alena Rybakina | 20:18 |
| Re: proposal: schema variables 📎 | Pavel Stehule | 22:41 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance of Query 4 on TPC-DS Benchmark | Andrei Lepikhov | 09:41 |
| Re: Performance of Query 4 on TPC-DS Benchmark | Ba Jinsheng | 10:49 |
| Re: Performance of Query 4 on TPC-DS Benchmark | Ba Jinsheng | 10:51 |
| Thread | Author | Time |
|---|---|---|
| Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4 📎 | Achilleas Mantzios - cloud | 10:37 |
| Re: Performance of Query 4 on TPC-DS Benchmark 📎 | Andrei Lepikhov | 10:40 |
| Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4 | Tomas Vondra | 13:17 |
| Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4 | Achilleas Mantzios | 18:24 |
| Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4 | Tom Lane | 19:37 |
| Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4 | Tomas Vondra | 21:46 |
| Thread | Author | Time |
|---|---|---|
| Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4 | Achilleas Mantzios - cloud | 07:14 |
| Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4 | Achilleas Mantzios - cloud | 08:45 |
| Re: proposal: schema variables 📎 | Laurenz Albe | 14:24 |
| Re: proposal: schema variables | Pavel Stehule | 15:06 |
| Re: proposal: schema variables | Dmitry Dolgov | 16:34 |
| Re: proposal: schema variables | Pavel Stehule | 18:18 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables | Pavel Stehule | 07:41 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables | Pavel Stehule | 04:45 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables | Pavel Stehule | 06:10 |
| Re: proposal: schema variables | Dmitry Dolgov | 14:27 |
| Re: proposal: schema variables | Pavel Stehule | 14:34 |
| Re: proposal: schema variables | Wolfgang Walther | 14:56 |
| Re: proposal: schema variables | Pavel Stehule | 15:36 |
| Re: proposal: schema variables 📎 | Pavel Stehule | 15:41 |
| Re: proposal: schema variables | Wolfgang Walther | 17:13 |
| Re: proposal: schema variables | Pavel Stehule | 22:07 |
| Re: proposal: schema variables | Pavel Stehule | 22:49 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables | Pavel Stehule | 04:41 |
| Re: proposal: schema variables | Pavel Stehule | 04:53 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 19:14 |
| Re: proposal: schema variables 📎 | Pavel Stehule | 21:30 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 07:25 |
| Re: Has gen_random_uuid() gotten much slower in v17? | Frédéric Yhuel | 10:35 |
| Re: proposal: schema variables | Marcos Pegoraro | 13:29 |
| Re: proposal: schema variables | Pavel Stehule | 13:52 |
| Re: proposal: schema variables | Marcos Pegoraro | 14:14 |
| Re: proposal: schema variables | Pavel Stehule | 14:57 |
| Re: Has gen_random_uuid() gotten much slower in v17? | Tom Lane | 15:46 |
| Re: proposal: schema variables | Dmitry Dolgov | 20:13 |
| Re: Has gen_random_uuid() gotten much slower in v17? | David Mullineux | 22:11 |
| Re: Has gen_random_uuid() gotten much slower in v17? | Tom Lane | 22:26 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables | Pavel Stehule | 04:07 |
| could not send data to client: Connection reset by peer | James Pang | 12:13 |
| Thread | Author | Time |
|---|---|---|
| Performance of Query 60 on TPC-DS Benchmark | Ba Jinsheng | 11:12 |
| Re: Performance of Query 60 on TPC-DS Benchmark | Andrei Lepikhov | 14:32 |
| Cardinality estimate of the inner relation | Frédéric Yhuel | 15:53 |
| Thread | Author | Time |
|---|---|---|
| Re: could not send data to client: Connection reset by peer | Tomas Vondra | 01:38 |
| Re: Cardinality estimate of the inner relation | Andrei Lepikhov | 02:07 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance of Query 60 on TPC-DS Benchmark | Andrei Lepikhov | 12:04 |
| Thread | Author | Time |
|---|---|---|
| Re: Cardinality estimate of the inner relation | Frédéric Yhuel | 12:46 |
| Performance of TPC-DS Query 95 | Ba Jinsheng | 20:54 |
| CTE Inline On TPC-DS Query 95 | Ba Jinsheng | 21:02 |
| Re: Performance of TPC-DS Query 95 | David Rowley | 22:41 |
| Thread | Author | Time |
|---|---|---|
| Re: CTE Inline On TPC-DS Query 95 | David Rowley | 04:03 |
| Re: proposal: schema variables 📎 | Pavel Stehule | 06:21 |
| Re: Has gen_random_uuid() gotten much slower in v17? | David Mullineux | 15:23 |
| Thread | Author | Time |
|---|---|---|
| Reg. Postgres Unique contraint | Sajjad Abid | 04:14 |
| Re: Reg. Postgres Unique contraint | Diomedes Dominguez | 04:18 |
| Re: Reg. Postgres Unique contraint | Sajjad Abid | 04:27 |
| Re: Reg. Postgres Unique contraint | Burcin Yazici | 06:22 |
| Re: Reg. Postgres Unique contraint | Vitalii Tymchyshyn | 07:13 |
| Re: proposal: schema variables 📎 | Pavel Stehule | 18:14 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance of Query 60 on TPC-DS Benchmark | Nikita Malakhov | 07:58 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance of Query 60 on TPC-DS Benchmark 📎 | Nikita Malakhov | 14:27 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 06:51 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables | jian he | 02:13 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 18:32 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables | jian he | 03:32 |
| Re: PostgreSQL and a Catch-22 Issue related to dead rows | Lars Aksel Opsahl | 05:19 |
| Re: PostgreSQL and a Catch-22 Issue related to dead rows | Lars Aksel Opsahl | 05:32 |
| Re: PostgreSQL and a Catch-22 Issue related to dead rows | Lars Aksel Opsahl | 08:55 |
| Re: can a blocked transaction affect the performance of one that is blocking it? | David Mullineux | 09:22 |
| Re: PostgreSQL and a Catch-22 Issue related to dead rows | Greg Sabino Mullane | 13:03 |
| Re: PostgreSQL and a Catch-22 Issue related to dead rows | Lars Aksel Opsahl | 14:03 |
| Re: PostgreSQL and a Catch-22 Issue related to dead rows | Greg Sabino Mullane | 15:31 |
| Re: PostgreSQL and a Catch-22 Issue related to dead rows | Hannu Krosing | 20:26 |
| Thread | Author | Time |
|---|---|---|
| Re: PostgreSQL and a Catch-22 Issue related to dead rows | Lars Aksel Opsahl | 07:32 |
| Re: PostgreSQL and a Catch-22 Issue related to dead rows | Lars Aksel Opsahl | 13:29 |
| Re: proposal: schema variables 📎 | Pavel Stehule | 20:51 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 15:40 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables | jian he | 03:00 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 07:25 |
| Aggressive vacuum | Graham Hay | 13:37 |
| Why a bitmap scan in this case? | Jon Zeppieri | 17:52 |
| Re: Why a bitmap scan in this case? | Greg Sabino Mullane | 18:38 |
| Re: Why a bitmap scan in this case? | Jon Zeppieri | 19:09 |
| Re: Why a bitmap scan in this case? | Jon Zeppieri | 19:19 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: proposal: schema variables | jian he | 07:57 |
| Re: Why a bitmap scan in this case? | Frédéric Yhuel | 08:16 |
| Re: Why a bitmap scan in this case? | Frédéric Yhuel | 09:57 |
| Re: proposal: schema variables 📎 | Pavel Stehule | 12:53 |
| Re: Why a bitmap scan in this case? | Jon Zeppieri | 21:01 |
| Re: Re: proposal: schema variables 📎 | Pavel Stehule | 22:00 |
| Thread | Author | Time |
|---|---|---|
| huge shared_blocks_hit one select but manually run very fast | James Pang | 11:50 |
| Re: huge shared_blocks_hit one select but manually run very fast | David Mullineux | 16:40 |
| Thread | Author | Time |
|---|---|---|
| Re: huge shared_blocks_hit one select but manually run very fast 📎 | James Pang | 03:38 |
| Thread | Author | Time |
|---|---|---|
| Re: huge shared_blocks_hit one select but manually run very fast | David Mullineux | 14:07 |
| Thread | Author | Time |
|---|---|---|
| RE: CTE Inline On TPC-DS Query 95 | msalais | 11:34 |
| Re: CTE Inline On TPC-DS Query 95 | David Rowley | 11:40 |
| RE: Reg. Postgres Unique contraint | msalais | 11:54 |
| Re: Reg. Postgres Unique contraint | shammat | 12:57 |
| Re: Re: proposal: schema variables 📎 | jian he | 15:19 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: proposal: schema variables | jian he | 10:34 |
| Re: Re: proposal: schema variables | Pavel Stehule | 15:32 |
| Re: Re: proposal: schema variables | jian he | 16:46 |
| Re: Re: proposal: schema variables | Pavel Stehule | 17:29 |
| Re: Re: proposal: schema variables 📎 | Pavel Stehule | 21:49 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: proposal: schema variables | jian he | 02:48 |
| Re: Re: proposal: schema variables | Pavel Stehule | 06:24 |
| Re: Re: proposal: schema variables 📎 | Pavel Stehule | 08:42 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: proposal: schema variables 📎 | Pavel Stehule | 06:46 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: proposal: schema variables 📎 | jian he | 07:18 |
| Re: Re: proposal: schema variables 📎 | Pavel Stehule | 22:59 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: proposal: schema variables 📎 | Pavel Stehule | 05:36 |
| Question: consolidating strpos searches? 📎 | James Addison | 17:16 |
| Re: Question: consolidating strpos searches? | Tom Lane | 17:45 |
| Re: Question: consolidating strpos searches? | Greg Sabino Mullane | 19:03 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: proposal: schema variables | jian he | 04:52 |
| Re: Re: proposal: schema variables | jian he | 16:10 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: proposal: schema variables 📎 | jian he | 07:58 |
| Re: Re: proposal: schema variables | Pavel Stehule | 08:39 |
| Re: Re: proposal: schema variables | Pavel Stehule | 10:01 |
| Re: Re: proposal: schema variables 📎 | Pavel Stehule | 12:21 |
| Re: Re: proposal: schema variables 📎 | Pavel Stehule | 19:10 |
| Re: Aggressive vacuum | Slava Mudry | 23:18 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: proposal: schema variables | jian he | 09:07 |
| Re: Aggressive vacuum | Jeff Janes | 19:30 |
| Re: Re: proposal: schema variables 📎 | Pavel Stehule | 21:21 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: proposal: schema variables | jian he | 09:31 |
| Re: Re: proposal: schema variables 📎 | Pavel Stehule | 16:33 |
| Re: Re: proposal: schema variables 📎 | Pavel Stehule | 19:00 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: proposal: schema variables 📎 | Pavel Stehule | 05:57 |
| Unexpected Seq Scan's when using MERGE WHEN NOT MATCHED BY SOURCE 📎 | Feike Steenbergen | 12:25 |
| Re: Unexpected Seq Scan's when using MERGE WHEN NOT MATCHED BY SOURCE | Feike Steenbergen | 12:39 |
| Re: Unexpected Seq Scan's when using MERGE WHEN NOT MATCHED BY SOURCE | David Mullineux | 15:52 |
| Re: Unexpected Seq Scan's when using MERGE WHEN NOT MATCHED BY SOURCE | Tom Lane | 19:39 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: proposal: schema variables 📎 | Pavel Stehule | 07:28 |
| Query planning read a large amount of buffers for partitioned tables | bruno vieira da silva | 18:29 |
| Re: Query planning read a large amount of buffers for partitioned tables | bruno vieira da silva | 18:32 |
| Re: Query planning read a large amount of buffers for partitioned tables | David Rowley | 20:01 |
| Re: Question: consolidating strpos searches? | James Addison | 23:58 |
| Thread | Author | Time |
|---|---|---|
| Re: Query planning read a large amount of buffers for partitioned tables | bruno vieira da silva | 14:56 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: proposal: schema variables 📎 | Pavel Stehule | 07:18 |
| Re: Re: proposal: schema variables | Bruce Momjian | 13:41 |
| Re: Re: proposal: schema variables | Pavel Stehule | 13:48 |
| Re: Re: proposal: schema variables | Bruce Momjian | 14:16 |
| Re: Re: proposal: schema variables | Álvaro Herrera | 14:47 |
| Fwd: Re: proposal: schema variables | Pavel Stehule | 15:32 |
| Re: Fwd: Re: proposal: schema variables | Bruce Momjian | 15:35 |