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 |
|---|---|---|
| Performance degradation in Index searches with special characters | Andrey Stikheev | 09:23 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance degradation in Index searches with special characters | Tom Lane | 16:39 |
| Re: Performance degradation in Index searches with special characters | Andrey Stikheev | 17:28 |
| Re: Performance degradation in Index searches with special characters | Joe Conway | 17:45 |
| Re: Performance degradation in Index searches with special characters | Tom Lane | 18:13 |
| Re: Performance degradation in Index searches with special characters | Shiv Iyer | 20:02 |
| Re: Performance degradation in Index searches with special characters | Thomas Munro | 20:24 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance degradation in Index searches with special characters | Joe Conway | 16:48 |
| Re: Performance degradation in Index searches with special characters | Andrey Stikheev | 17:16 |
| Thread | Author | Time |
|---|---|---|
| Bloom filters and the planner / parallel execution | Daniel Westermann (DWE) | 11:56 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 04:24 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Laurenz Albe | 04:11 |
| Thread | Author | Time |
|---|---|---|
| Adding exclusion constraint in a big table | Marcelo Fernandes | 06:43 |
| Re: proposal: schema variables 📎 | Laurenz Albe | 08:29 |
| Unexpected Performance for the Function simplify_function | Ba Jinsheng | 19:43 |
| Re: Unexpected Performance for the Function simplify_function | Shiv Iyer | 19:48 |
| Re: Unexpected Performance for the Function simplify_function | Tom Lane | 20:49 |
| Re: Unexpected Performance for the Function simplify_function | Tom Lane | 20:51 |
| Re: Unexpected Performance for the Function simplify_function | David G. Johnston | 21:05 |
| Re: Unexpected Performance for the Function simplify_function | Greg Sabino Mullane | 23:09 |
| Thread | Author | Time |
|---|---|---|
| Re: Unexpected Performance for the Function simplify_function | Andrei Lepikhov | 02:13 |
| Re: proposal: schema variables | Pavel Stehule | 05:21 |
| lwlock:LockManager wait_events | James Pang | 06:36 |
| Re: lwlock:LockManager wait_events | Laurenz Albe | 07:36 |
| Re: proposal: schema variables | Laurenz Albe | 07:41 |
| Re: proposal: schema variables | James Pang | 07:58 |
| Re: proposal: schema variables | James Pang | 07:59 |
| Re: lwlock:LockManager wait_events | Sean Massey | 08:37 |
| Re: Unexpected Performance for the Function simplify_function | Ba Jinsheng | 09:26 |
| Re: Unexpected Performance for the Function simplify_function | Ba Jinsheng | 09:29 |
| Re: Unexpected Performance for the Function simplify_function | Andrei Lepikhov | 09:38 |
| Re: Unexpected Performance for the Function simplify_function | David Rowley | 10:20 |
| Re: lwlock:LockManager wait_events | SAMEER KUMAR | 12:09 |
| Re: proposal: schema variables 📎 | Pavel Stehule | 20:38 |
| Thread | Author | Time |
|---|---|---|
| Re: Unexpected Performance for the Function simplify_function | Tom Lane | 06:28 |
| Re: Unexpected Performance for the Function simplify_function | Ba Jinsheng | 07:31 |
| 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 |