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 |
|---|---|---|
| Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan | Fred Habash | 14:17 |
| Re: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan | Sergei Kornilov | 14:26 |
| Re: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan | Matthew Hall | 14:42 |
| Re: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan | Tom Lane | 14:42 |
| RE: Simple Query Elapsed Time ~ 3 hrs Using Bitmap Index/Heap Scan | Fd Habash | 17:18 |
| Thread | Author | Time |
|---|---|---|
| Re: Client Server performance & UDS | e-blokos | 09:40 |
| Thread | Author | Time |
|---|---|---|
| pg_upgrade 10.2 | Murthy Nunna | 20:34 |
| Re: pg_upgrade 10.2 | Adrian Klaver | 20:47 |
| RE: pg_upgrade 10.2 | Murthy Nunna | 20:58 |
| Re: pg_upgrade 10.2 | Adrian Klaver | 21:13 |
| RE: pg_upgrade 10.2 | Murthy Nunna | 21:18 |
| Re: pg_upgrade 10.2 | Adrian Klaver | 21:34 |
| RE: pg_upgrade 10.2 | Murthy Nunna | 21:49 |
| Re: pg_upgrade 10.2 | Jerry Sievers | 23:24 |
| RE: pg_upgrade 10.2 | Murthy Nunna | 23:41 |
| Re: pg_upgrade 10.2 | Adrian Klaver | 23:50 |
| Re: pg_upgrade 10.2 | Jerry Sievers | 23:56 |
| Re: pg_upgrade 10.2 | Jerry Sievers | 23:59 |
| Thread | Author | Time |
|---|---|---|
| Re: [PERFORM] Dissuade the use of exclusion constraint index | Adam Brusselback | 15:59 |
| Thread | Author | Time |
|---|---|---|
| Small query plan change, big performance difference | Michael Sacket | 18:02 |
| Re: Small query plan change, big performance difference | Adam Brusselback | 18:24 |
| Re: Small query plan change, big performance difference | Michael Sacket | 18:49 |
| Thread | Author | Time |
|---|---|---|
| Re: [PERFORM] Dissuade the use of exclusion constraint index | Adam Brusselback | 19:50 |
| Thread | Author | Time |
|---|---|---|
| Slow query when pg_trgm is in inner lopp | Sasa Vilic | 13:21 |
| Re: Slow query when pg_trgm is in inner lopp | Matthew Hall | 13:29 |
| Re: Slow query when pg_trgm is in inner lopp | Sasa Vilic | 14:13 |
| Re: Slow query when pg_trgm is in inner lopp | Jeff Janes | 14:53 |
| Re: add default parallel query to v10 release notes? (Re: [PERFORM] performance drop after upgrade (9.6 > 10)) 📎 | Bruce Momjian | 15:13 |
| Re: Slow query when pg_trgm is in inner lopp | Sasa Vilic | 15:38 |
| Thread | Author | Time |
|---|---|---|
| Re: add default parallel query to v10 release notes? (Re: [PERFORM] performance drop after upgrade (9.6 > 10)) | Amit Kapila | 09:23 |
| Thread | Author | Time |
|---|---|---|
| Slow join | Roman Kushnir | 15:55 |
| Re: Slow join | Justin Pryzby | 16:45 |
| Re: Slow join | Roman Kushnir | 19:39 |
| Thread | Author | Time |
|---|---|---|
| Queue table that quickly grows causes query planner to choose poor plan | David Wheeler | 03:45 |
| Re: Slow join | Laurenz Albe | 08:19 |
| Re: Slow join | Roman Kushnir | 09:02 |
| Re: [HACKERS] proposal: schema variables | Gilles Darold | 10:21 |
| Re: [HACKERS] proposal: schema variables | Pavel Stehule | 11:22 |
| Bug in PostgreSQL | Rambabu V | 15:30 |
| Re: Bug in PostgreSQL | Steve Crawford | 15:50 |
| Re: Bug in PostgreSQL | Joseph Curtin | 15:53 |
| Re: [HACKERS] proposal: schema variables | Gilles Darold | 17:15 |
| Re: [HACKERS] proposal: schema variables | Pavel Stehule | 17:17 |
| Re: Queue table that quickly grows causes query planner to choose poor plan | Justin Pryzby | 18:05 |
| Re: Queue table that quickly grows causes query planner to choose poor plan | Tom Lane | 18:27 |
| Thread | Author | Time |
|---|---|---|
| Re: Queue table that quickly grows causes query planner to choose poor plan | David Wheeler | 00:00 |
| Re: Bug in PostgreSQL | Laurenz Albe | 06:55 |
| Re: Bug in PostgreSQL | Andres Freund | 16:13 |