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 |
|---|---|---|
| PSQL performance - TPS | Shital A | 03:10 |
| Re: PSQL performance - TPS | Gavin Flower | 05:15 |
| Re: PSQL performance - TPS | Shital A | 05:18 |
| Partial join 📎 | Arne Roland | 08:07 |
| Re: Partial join | Richard Guo | 11:14 |
| Re: Partial join | Arne Roland | 11:46 |
| Re: Partial join | Tom Lane | 14:14 |
| Re: Partial join | Arne Roland | 16:29 |
| Re: PSQL performance - TPS | Andres Freund | 17:21 |
| Re: PSQL performance - TPS | Purav Chovatia | 18:06 |
| Re: PSQL performance - TPS | Andres Freund | 18:14 |
| Re: PSQL performance - TPS | Rick Otten | 18:27 |
| Thread | Author | Time |
|---|---|---|
| Re: PSQL performance - TPS | Shital A | 04:59 |
| Re: Partial join | Richard Guo | 09:33 |
| Re: Partial join | Richard Guo | 10:00 |
| Re: PSQL performance - TPS | Imre Samu | 11:04 |
| Strange runtime partition pruning behaviour with 11.4 | Thomas Kellerer | 13:58 |
| Thread | Author | Time |
|---|---|---|
| Re: Strange runtime partition pruning behaviour with 11.4 | MichaelDBA | 13:16 |
| Re: Strange runtime partition pruning behaviour with 11.4 | Andreas Kretschmer | 13:42 |
| Re: Strange runtime partition pruning behaviour with 11.4 | Thomas Kellerer | 14:06 |
| Re: Strange runtime partition pruning behaviour with 11.4 | Andreas Kretschmer | 15:18 |
| Re: Strange runtime partition pruning behaviour with 11.4 | Tom Lane | 16:05 |
| Re: Strange runtime partition pruning behaviour with 11.4 | MichaelDBA | 16:49 |
| Thread | Author | Time |
|---|---|---|
| Re: Strange runtime partition pruning behaviour with 11.4 | Thomas Kellerer | 07:29 |
| improving windows functions performance | Mariel Cherkassky | 20:47 |
| Re: improving windows functions performance | Andreas Kretschmer | 21:15 |
| Thread | Author | Time |
|---|---|---|
| Postgres not using correct indices for views. | Thomas Rosenstein | 12:02 |
| Re: Postgres not using correct indices for views. | Tom Lane | 16:05 |
| Re: Postgres not using correct indices for views. | Thomas Rosenstein | 20:04 |
| Re: Postgres not using correct indices for views. | Thomas Rosenstein | 20:30 |
| Re: Postgres not using correct indices for views. | Tom Lane | 22:45 |
| Thread | Author | Time |
|---|---|---|
| Bitmap heap scan performance 📎 | Rob Emery | 08:41 |
| Re: Bitmap heap scan performance | Jeff Janes | 12:30 |
| Re: Postgres not using correct indices for views. | Tom Lane | 15:16 |
| Thread | Author | Time |
|---|---|---|
| Re: [HACKERS] proposal: schema variables 📎 | Pavel Stehule | 07:10 |
| Re: Postgres not using correct indices for views. | Thomas Rosenstein | 10:05 |
| Re: Postgres not using correct indices for views. | [email protected] | 11:11 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgres not using correct indices for views. | Tom Lane | 20:31 |
| Thread | Author | Time |
|---|---|---|
| Planner performance in partitions | Piotr Włodarczyk | 12:37 |
| Re: Bitmap heap scan performance | Rob Emery | 13:00 |
| Re: Bitmap heap scan performance | Jeremy Finzel | 13:29 |
| Re: Planner performance in partitions | Michael Lewis | 19:05 |
| Re: Planner performance in partitions | MichaelDBA | 19:24 |
| ODP: Planner performance in partitions | Piotr Włodarczyk | 20:03 |
| Re: Planner performance in partitions | Michael Lewis | 20:25 |
| Last event per user | Luís Roberto Weck | 20:57 |
| Re: Last event per user | Michael Lewis | 21:56 |
| Re: Planner performance in partitions | David Rowley | 22:25 |
| Re: Last event per user | Luís Roberto Weck | 22:28 |
| Re: Last event per user | Michael Lewis | 22:35 |
| Re: Planner performance in partitions | Michael Lewis | 22:37 |
| Re: | Luís Roberto Weck | 22:43 |
| Re: | Michael Lewis | 22:53 |
| Re: Last event per user | Luís Roberto Weck | 23:03 |
| Re: Last event per user | Michael Lewis | 23:09 |
| Thread | Author | Time |
|---|---|---|
| ODP: Planner performance in partitions | Piotr Włodarczyk | 06:29 |
| Re: Strange runtime partition pruning behaviour with 11.4 | Sverre Boschman | 07:02 |
| ORA-24345: A Truncation or null fetch error occurred -ora2pg | Daulat Ram | 08:23 |
| Re: zabbix on postgresql - very slow delete of events | Kristian Ejvind | 11:08 |
| Re: Last event per user | Luís Roberto Weck | 11:34 |
| performance bottlenecks on lock transactionid 📎 | 王若楠 | 14:15 |
| Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg | Luca Ferrari | 15:02 |
| RE: ORA-24345: A Truncation or null fetch error occurred -ora2pg | Daulat Ram | 17:34 |
| Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg | Adrian Klaver | 17:57 |
| Thread | Author | Time |
|---|---|---|
| Re: performance bottlenecks on lock transactionid | Laurenz Albe | 07:31 |
| re:Re: performance bottlenecks on lock transactionid | 王若楠 | 07:57 |
| RE: ORA-24345: A Truncation or null fetch error occurred -ora2pg | Daulat Ram | 09:39 |
| Re: Re: performance bottlenecks on lock transactionid | Laurenz Albe | 10:25 |
| Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg | Adrian Klaver | 14:13 |
| Continuous Performance Test | Jean Baro | 16:18 |
| Continuous Performance Test | Jean Baro | 17:56 |
| Re: Continuous Performance Test | Nasby, Jim | 20:57 |
| Re: [UNVERIFIED SENDER] Re: Continuous Performance Test | Nasby, Jim | 20:59 |
| Thread | Author | Time |
|---|---|---|
| Re: [UNVERIFIED SENDER] Re: Continuous Performance Test | Jean Baro | 01:33 |
| Thread | Author | Time |
|---|---|---|
| UPGRADE TO PG11 CAUSED DEGREDATION IN PERFORMANCE | Mariel Cherkassky | 06:56 |
| Re: UPGRADE TO PG11 CAUSED DEGREDATION IN PERFORMANCE | Pavel Stehule | 08:41 |
| Thread | Author | Time |
|---|---|---|
| pg11 list partitions vs hash partitions | Mariel Cherkassky | 12:32 |
| Re: Partial join | Arne Roland | 15:17 |
| Thread | Author | Time |
|---|---|---|
| Erratically behaving query needs optimization | Barbu Paul - Gheorghe | 13:54 |
| Re: Erratically behaving query needs optimization | Luís Roberto Weck | 14:58 |
| Re: Erratically behaving query needs optimization | MichaelDBA | 15:07 |
| Extremely slow HashAggregate in simple UNION query | Felix Geisendörfer | 15:11 |
| Re: Extremely slow HashAggregate in simple UNION query | Michael Lewis | 16:19 |
| Re: Extremely slow HashAggregate in simple UNION query | Pavel Stehule | 16:57 |
| Re: Extremely slow HashAggregate in simple UNION query | Andres Freund | 17:32 |
| Re: Extremely slow HashAggregate in simple UNION query | Felix Geisendörfer | 17:55 |
| Re: Extremely slow HashAggregate in simple UNION query | Andres Freund | 18:27 |
| Thread | Author | Time |
|---|---|---|
| Re: Erratically behaving query needs optimization | Barbu Paul - Gheorghe | 07:30 |
| Re: Erratically behaving query needs optimization | Luís Roberto Weck | 11:30 |
| Re: Extremely slow HashAggregate in simple UNION query 📎 | Jeff Janes | 18:26 |
| Thread | Author | Time |
|---|---|---|
| Re: Out of Memory errors are frustrating as heck! | Gunther | 13:17 |
| Re: Out of Memory errors are frustrating as heck! | Gunther | 14:19 |
| Re: Out of Memory errors are frustrating as heck! | Tom Lane | 14:20 |
| Thread | Author | Time |
|---|---|---|
| pg_basebackup is taking an unusually long time with Postgres 11.3 | andy andy | 03:24 |
| Re: Out of Memory errors are frustrating as heck! | Gunther | 15:40 |
| Re: Extremely slow HashAggregate in simple UNION query | Jeff Janes | 19:16 |
| Re: Extremely slow HashAggregate in simple UNION query | Tom Lane | 19:41 |
| Re: Extremely slow HashAggregate in simple UNION query | Andres Freund | 19:54 |
| Thread | Author | Time |
|---|---|---|
| Re: Erratically behaving query needs optimization | Jeff Janes | 14:50 |
| Thread | Author | Time |
|---|---|---|
| Re: Erratically behaving query needs optimization | Barbu Paul - Gheorghe | 08:25 |
| Re: Erratically behaving query needs optimization | Justin Pryzby | 11:51 |