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 |
|---|---|---|
| Very slow query performance when using CTE | Chris Joysn | 13:37 |
| Re: Very slow query performance when using CTE | Tom Lane | 14:28 |
| Re: Very slow query performance when using CTE | Renan Alves Fonseca | 20:03 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: proposal: schema variables 📎 | Pavel Stehule | 06:46 |
| partition table optimizer join cost misestimation 📎 | James Pang | 10:18 |
| Re: partition table optimizer join cost misestimation | Andrei Lepikhov | 11:03 |
| Thread | Author | Time |
|---|---|---|
| Re: partition table optimizer join cost misestimation 📎 | James Pang | 00:46 |
| Re: partition table optimizer join cost misestimation | Andrei Lepikhov | 06:32 |
| Fwd: Very slow query performance when using CTE | Chris Joysn | 07:20 |
| Fwd: Very slow query performance when using CTE | Chris Joysn | 07:21 |
| Re: Very slow query performance when using CTE | Michael Christofides | 09:10 |
| Re: partition table optimizer join cost misestimation | James Pang | 12:38 |
| Re: Very slow query performance when using CTE | Chris Joysn | 13:34 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: proposal: schema variables 📎 | Pavel Stehule | 10:33 |
| Thread | Author | Time |
|---|---|---|
| Question on what Duration in the log | Vitale, Anthony, Sony Music | 14:27 |
| Re: Question on what Duration in the log | Tom Lane | 15:02 |
| RE: Question on what Duration in the log | Vitale, Anthony, Sony Music | 15:47 |
| Thread | Author | Time |
|---|---|---|
| Re: parallel pg_restore blocks on heavy random read I/O on all children processes | Hannu Krosing | 06:50 |
| Thread | Author | Time |
|---|---|---|
| many sessions wait on LWlock WALWrite suddenly | James Pang | 14:36 |
| Re: many sessions wait on LWlock WALWrite suddenly | Laurenz Albe | 19:59 |
| Re: many sessions wait on LWlock WALWrite suddenly | MichaelDBA | 22:43 |
| Thread | Author | Time |
|---|---|---|
| session waiting IO while background writer writing data | James Pang | 05:30 |
| Thread | Author | Time |
|---|---|---|
| Re: many sessions wait on LWlock WALWrite suddenly | Yura Sokolov | 09:16 |
| Re: many sessions wait on LWlock WALWrite suddenly | Andres Freund | 10:00 |
| Re: many sessions wait on LWlock WALWrite suddenly | Yura Sokolov | 10:44 |
| Re: many sessions wait on LWlock WALWrite suddenly | Andres Freund | 10:53 |
| Re: many sessions wait on LWlock WALWrite suddenly | Yura Sokolov | 10:58 |
| Thread | Author | Time |
|---|---|---|
| Constraints elimination during runtime | Weck, Luis | 11:16 |
| Re: Constraints elimination during runtime | Laurenz Albe | 12:38 |
| Thread | Author | Time |
|---|---|---|
| PostgreSQL Choosing Full Index Over Partial Index | Felipe López Montes | 13:22 |
| Re: PostgreSQL Choosing Full Index Over Partial Index | Laurenz Albe | 13:35 |
| Re: PostgreSQL Choosing Full Index Over Partial Index | Felipe López Montes | 14:54 |
| Re: PostgreSQL Choosing Full Index Over Partial Index | Tom Lane | 15:07 |
| Thread | Author | Time |
|---|---|---|
| Re: PostgreSQL Choosing Full Index Over Partial Index | Felipe López Montes | 09:11 |
| Re: PostgreSQL Choosing Full Index Over Partial Index | Tom Lane | 14:14 |