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: query of partitioned object doesnt use index in qa | Tom Lane | 20:42 |
| Indexing an array of two separate columns | Jeremy Finzel | 20:51 |
| Re: query of partitioned object doesnt use index in qa | Mike Broers | 20:59 |
| Re: query of partitioned object doesnt use index in qa | Andres Freund | 21:03 |
| Re: query of partitioned object doesnt use index in qa | Tom Lane | 22:05 |
| Re: query of partitioned object doesnt use index in qa | Tomas Vondra | 22:26 |
| Thread | Author | Time |
|---|---|---|
| Partitioning perfomance issue | Konstantin Kivi | 08:34 |
| Pageinspect bt_metap help | Neto pr | 21:52 |
| Re: Pageinspect bt_metap help | Peter Geoghegan | 21:59 |
| Thread | Author | Time |
|---|---|---|
| max partitions behind a view? | Rick Otten | 11:25 |
| Re: max partitions behind a view? | Tom Lane | 13:55 |
| Re: Pageinspect bt_metap help | Neto pr | 14:31 |
| Thread | Author | Time |
|---|---|---|
| https://stackoverflow.com/questions/28844170/how-to-limit-the-memory-that-is-available-for-postgressql-server | 園田祥平 | 00:49 |
| Re: Pageinspect bt_metap help | Peter Geoghegan | 01:07 |
| Re: https://stackoverflow.com/questions/28844170/how-to-limit-the-memory-that-is-available-for-postgressql-server | George Neuner | 02:44 |
| Re: Pageinspect bt_metap help | Tom Lane | 03:28 |
| Re: https://stackoverflow.com/questions/28844170/how-to-limit-the-memory-that-is-available-for-postgressql-server | Jonathan Rogers | 03:30 |
| Re: https://stackoverflow.com/questions/28844170/how-to-limit-the-memory-that-is-available-for-postgressql-server | Tomas Vondra | 13:08 |
| repeated subplan execution | Jeff Janes | 23:30 |
| Thread | Author | Time |
|---|---|---|
| Re: repeated subplan execution | monika yadav | 02:31 |
| Re: query of partitioned object doesnt use index in qa | Mike Broers | 16:15 |
| Re: repeated subplan execution | Jeff Janes | 16:46 |
| Re: query of partitioned object doesnt use index in qa | David Rowley | 23:05 |
| Thread | Author | Time |
|---|---|---|
| Re: repeated subplan execution | monika yadav | 10:35 |
| Query regarding EXPLAIN (ANALYZE,BUFFERS) | Subramaniam C | 10:52 |
| Re: Query regarding EXPLAIN (ANALYZE,BUFFERS) | Pavel Stehule | 18:37 |
| Thread | Author | Time |
|---|---|---|
| Parallel sequential scan not supported for stored procedure with RETURN QUERY EXECUTE ? | Tobias Gierke | 11:10 |
| Re: query of partitioned object doesnt use index in qa | Mike Broers | 16:21 |
| Thread | Author | Time |
|---|---|---|
| Slow query in JDBC | Subramaniam C | 08:19 |
| Re: Slow query in JDBC | Julien Rouhaud | 08:48 |
| Re: Slow query in JDBC | Subramaniam C | 08:58 |
| Re: Slow query in JDBC | Julien Rouhaud | 09:20 |
| Re: Slow query in JDBC | Pavy Philippe | 09:26 |
| Re: Slow query in JDBC | Subramaniam C | 09:59 |
| Re: Slow query in JDBC | Dave Cramer | 13:59 |
| Re: Slow query in JDBC | Subramaniam C | 16:32 |
| Re: Slow query in JDBC | Dave Cramer | 19:04 |
| Thread | Author | Time |
|---|---|---|
| Re: Slow query in JDBC | Subramaniam C | 05:57 |
| Re: Slow query in JDBC | Jeff Janes | 06:49 |
| Re: Slow query in JDBC | Subramaniam C | 10:44 |
| Re: Slow query in JDBC | Dave Cramer | 13:04 |
| BDR, wal sender, high system cpu, mutex_lock_common | milist ujang | 23:07 |
| Thread | Author | Time |
|---|---|---|
| Re: BDR, wal sender, high system cpu, mutex_lock_common | milist ujang | 01:36 |
| select with max functions | Mariel Cherkassky | 12:41 |
| Re: select with max functions | Gerardo Herzig | 13:35 |
| Re: select with max functions | Andreas Kretschmer | 18:48 |
| Thread | Author | Time |
|---|---|---|
| Re: select with max functions | Mariel Cherkassky | 13:25 |
| Re: select with max functions | Gerardo Herzig | 13:45 |
| Re: select with max functions | Mariel Cherkassky | 14:45 |
| Re: select with max functions | Tom Lane | 15:29 |
| Thread | Author | Time |
|---|---|---|
| Stored Procedure Performance | Purav Chovatia | 14:33 |
| Re: Stored Procedure Performance | Laurenz Albe | 14:54 |
| Re: Stored Procedure Performance | Adam Brusselback | 15:17 |
| Re: Stored Procedure Performance | Pavel Stehule | 15:28 |
| How does max_parallel_workers_per_gather change load averages? | Ben Nachtrieb | 19:48 |
| Re: select with max functions | Mark Kirkwood | 21:16 |
| Re: How does max_parallel_workers_per_gather change load averages? | David Rowley | 21:44 |
| Thread | Author | Time |
|---|---|---|
| Regression from 9.4-9.6 | Jim Nasby | 19:25 |
| Re: Regression from 9.4-9.6 | Tom Lane | 19:34 |
| Re: Regression from 9.4-9.6 | Jim Nasby | 20:02 |
| Re: Regression from 9.4-9.6 | Jim Nasby | 20:33 |
| Re: Regression from 9.4-9.6 | Tom Lane | 20:37 |
| Re: Regression from 9.4-9.6 | Jim Nasby | 21:07 |
| Thread | Author | Time |
|---|---|---|
| Cursor With_Hold Performance Workarounds/Optimization | Leon Winter | 12:20 |
| Thread | Author | Time |
|---|---|---|
| Rowcount estimation changes based on from clause order | Ants Aasma | 09:33 |
| performance drop after upgrade (9.6 > 10) | johannes graën | 11:06 |
| Re: performance drop after upgrade (9.6 > 10) | Pavel Stehule | 11:11 |
| Re: performance drop after upgrade (9.6 > 10) | johannes graën | 12:19 |
| blocking index creation | Neto pr | 12:58 |
| Re: blocking index creation | Laurenz Albe | 13:46 |
| Re: Stored Procedure Performance | Purav Chovatia | 13:59 |
| Re: Stored Procedure Performance | Purav Chovatia | 14:11 |
| Re: blocking index creation | Neto pr | 14:11 |
| Re: Stored Procedure Performance | Pavel Stehule | 14:20 |
| Re: Stored Procedure Performance | Purav Chovatia | 16:05 |
| Re: Stored Procedure Performance | Adam Brusselback | 16:37 |
| Re: Stored Procedure Performance | Purav Chovatia | 16:52 |
| Re: Stored Procedure Performance | Adam Brusselback | 16:54 |
| Re: Stored Procedure Performance | Pavel Stehule | 19:06 |
| Re: blocking index creation | Tomas Vondra | 21:08 |
| Re: blocking index creation | Neto pr | 22:54 |
| Thread | Author | Time |
|---|---|---|
| Wrong plane for limit after group by | Денис Смирнов | 00:18 |
| Re: blocking index creation | Neto pr | 01:35 |
| Re: blocking index creation | Scott Marlowe | 02:25 |
| synchronization between PostgreSQL and Oracle | ROS Didier | 09:13 |
| Re: synchronization between PostgreSQL and Oracle | Rick Otten | 10:01 |
| Re: synchronization between PostgreSQL and Oracle | Laurenz Albe | 10:04 |
| Re: Rowcount estimation changes based on from clause order | Tom Lane | 20:50 |
| Thread | Author | Time |
|---|---|---|
| Re: Rowcount estimation changes based on from clause order | Ants Aasma | 02:32 |
| Thread | Author | Time |
|---|---|---|
| Re: Stored Procedure Performance | phb07 | 10:21 |
| Thread | Author | Time |
|---|---|---|
| 99% time spent in WAL wait events | Purav Chovatia | 13:34 |
| Re: 99% time spent in WAL wait events | Purav Chovatia | 15:31 |
| Thread | Author | Time |
|---|---|---|
| memory allocation | nijam J | 09:28 |
| Row level security policy policy versus SQL constraints. Any performance difference? | Joe Carlson | 20:44 |
| Re: Row level security policy policy versus SQL constraints. Any performance difference? | Tomas Vondra | 21:35 |
| Re: Row level security policy policy versus SQL constraints. Any performance difference? | Tom Lane | 22:06 |
| Re: Row level security policy policy versus SQL constraints. Any performance difference? | Joe Carlson | 22:18 |
| Thread | Author | Time |
|---|---|---|
| Re: memory allocation | Laurenz Albe | 12:51 |
| Low priority batch insert | Jean Baro | 16:10 |
| Re: Low priority batch insert | Michael Paquier | 22:54 |
| Thread | Author | Time |
|---|---|---|
| postgresql tuning with perf | Purav Chovatia | 19:19 |
| Re: postgresql tuning with perf | legrand legrand | 20:29 |
| Re: postgresql tuning with perf | Tomas Vondra | 20:55 |
| Re: postgresql tuning with perf | Steve Atkins | 21:59 |
| Thread | Author | Time |
|---|---|---|
| Row-level security performance | Jason Borg | 02:51 |
| Re: postgresql tuning with perf | Purav Chovatia | 07:36 |
| Re: postgresql tuning with perf 📎 | Purav Chovatia | 11:33 |
| Re: postgresql tuning with perf | Purav Chovatia | 11:39 |
| Re: performance drop after upgrade (9.6 > 10) | johannes graën | 14:15 |
| Re: postgresql tuning with perf | legrand legrand | 14:51 |
| Re: postgresql tuning with perf | Purav Chovatia | 15:06 |
| Re: postgresql tuning with perf | Purav Chovatia | 15:08 |
| Re: performance drop after upgrade (9.6 > 10) | Justin Pryzby | 15:18 |
| Re: postgresql tuning with perf | legrand legrand | 15:21 |
| Re: performance drop after upgrade (9.6 > 10) | Johannes Graën | 15:57 |
| Re: performance drop after upgrade (9.6 > 10) | Alvaro Herrera | 16:17 |
| Thread | Author | Time |
|---|---|---|
| proposal: schema variables | Pavel Stehule | 07:21 |
| Re: performance drop after upgrade (9.6 > 10) | Justin Pryzby | 19:45 |
| Re: proposal: schema variables | Nico Williams | 22:07 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables | Pavel Stehule | 05:08 |
| Re: proposal: schema variables | Tatsuo Ishii | 05:30 |
| Re: proposal: schema variables | Tsunakawa, Takayuki | 05:47 |
| Re: proposal: schema variables | Pavel Stehule | 06:16 |
| WAL still kept in pg_xlog even long after heavy workload is done | Stefan Petrea | 11:28 |
| Re: WAL still kept in pg_xlog even long after heavy workload is done | MichaelDBA | 12:50 |
| Re: proposal: schema variables | Gilles Darold | 13:38 |
| Re: proposal: schema variables | Pavel Stehule | 14:09 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables | Chris Travers | 14:24 |
| Re: proposal: schema variables | Pavel Stehule | 14:56 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables | Chris Travers | 08:51 |
| Re: proposal: schema variables | Hannu Krosing | 10:47 |
| Cheaper subquery scan not considered unless offset 0 | Benjamin Coutu | 11:24 |
| Re: Cheaper subquery scan not considered unless offset 0 | David Rowley | 11:46 |
| Re: Cheaper subquery scan not considered unless offset 0 | Benjamin Coutu | 13:17 |
| Re: Cheaper subquery scan not considered unless offset 0 | Benjamin Coutu | 14:41 |
| Re: Cheaper subquery scan not considered unless offset 0 | Tom Lane | 14:58 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables | srielau | 21:42 |
| Cursor vs Set Operation | patibandlakoshal | 22:51 |
| Thread | Author | Time |
|---|---|---|
| Massive insert vs heavy contention in LWLock:buffer_content | luisfpg | 16:30 |
| Index-Advisor Tools | Neto pr | 17:12 |
| Re: Index-Advisor Tools | Anthony Sotolongo | 17:19 |
| Re: Index-Advisor Tools | Neto pr | 17:25 |
| Re: Index-Advisor Tools | Alexandre de Arruda Paes | 19:25 |
| Re: Index-Advisor Tools | Yves Dorfsman | 20:04 |
| Re: Index-Advisor Tools | Julien Rouhaud | 20:04 |
| Re: proposal: schema variables | Pavel Stehule | 20:33 |
| Re: proposal: schema variables | Serge Rielau | 21:08 |
| Re: proposal: schema variables | Pavel Stehule | 21:10 |
| Re: proposal: schema variables | srielau | 21:28 |
| Re: proposal: schema variables | Gilles Darold | 22:36 |
| Re: proposal: schema variables | Gilles Darold | 23:02 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables | Pavel Stehule | 04:15 |
| Re: proposal: schema variables | Serge Rielau | 05:07 |
| Re: proposal: schema variables | Pavel Stehule | 05:56 |
| Re: Cursor vs Set Operation | Merlin Moncure | 16:28 |
| Re: proposal: schema variables | Mark Dilger | 18:03 |
| Re: proposal: schema variables | Pavel Stehule | 19:19 |
| Re: proposal: schema variables | Gilles Darold | 22:13 |
| Thread | Author | Time |
|---|---|---|
| Unnecessary DISTINCT while primary key in SQL | 刘瑞 | 15:20 |
| Thread | Author | Time |
|---|---|---|
| Re: Unnecessary DISTINCT while primary key in SQL | David Rowley | 00:34 |
| Performance loss upgrading from 9.3 to 9.6 | Adam Torres | 13:18 |
| Re: Performance loss upgrading from 9.3 to 9.6 | Justin Pryzby | 14:21 |
| Re: Index-Advisor Tools | Baron Schwartz | 18:52 |
| Dynamic performance issues 📎 | Arne Roland | 20:05 |
| Re: Performance loss upgrading from 9.3 to 9.6 | Adam Torres | 21:12 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance loss upgrading from 9.3 to 9.6 | Adam Brusselback | 02:59 |
| Re: Performance loss upgrading from 9.3 to 9.6 | Justin Pryzby | 05:11 |
| Slow execution of SET ROLE, SET search_path and RESET ROLE | Ulf Lohbrügge | 10:11 |
| Re: Slow execution of SET ROLE, SET search_path and RESET ROLE | Andres Freund | 15:11 |
| Re: Slow execution of SET ROLE, SET search_path and RESET ROLE | Ulf Lohbrügge | 17:48 |
| Re: Slow execution of SET ROLE, SET search_path and RESET ROLE | Andres Freund | 19:45 |
| Re: Slow execution of SET ROLE, SET search_path and RESET ROLE | Ulf Lohbrügge | 21:25 |
| Re: Slow execution of SET ROLE, SET search_path and RESET ROLE | Scott Marlowe | 21:39 |
| Re: Slow execution of SET ROLE, SET search_path and RESET ROLE | Ulf Lohbrügge | 23:04 |
| Re: Slow execution of SET ROLE, SET search_path and RESET ROLE | Tom Lane | 23:45 |
| Thread | Author | Time |
|---|---|---|
| Re: Slow execution of SET ROLE, SET search_path and RESET ROLE | Ulf Lohbrügge | 09:31 |