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: Performance Issue -- "Materialize" | Carlos Augusto Machado | 18:46 |
| Re: Performance Issue -- "Materialize" | Carlos Augusto Machado | 19:19 |
| Re: Performance Issue -- "Materialize" | Jeff Janes | 20:28 |
| Re: Query plan for views and WHERE clauses, Luke is not using the index | kimaidou | 20:34 |
| Re: Query plan for views and WHERE clauses, Luke is not using the index | David Rowley | 21:52 |
| Thread | Author | Time |
|---|---|---|
| Re: Odd sudden performance degradation related to temp object churn | Mark Kirkwood | 01:04 |
| Re: Query plan for views and WHERE clauses, Luke is not using the index | kimaidou | 07:24 |
| query runs for more than 24 hours! | Mariel Cherkassky | 14:23 |
| Re: query runs for more than 24 hours! | Tomas Vondra | 21:02 |
| Thread | Author | Time |
|---|---|---|
| Re: performance problem on big tables | Claudio Freire | 23:15 |
| Thread | Author | Time |
|---|---|---|
| Re: performance problem on big tables | Mariel Cherkassky | 07:51 |
| printing results of query to file in different times | Mariel Cherkassky | 13:15 |
| Re: performance problem on big tables | Claudio Freire | 16:14 |
| latest perf tuning info | Sam Gendler | 23:32 |
| Thread | Author | Time |
|---|---|---|
| Re: Hi | Daulat Ram | 06:49 |
| Re: query runs for more than 24 hours! | vinny | 07:06 |
| Execution plan analysis | Neto pr | 08:31 |
| Re: Execution plan analysis | Neto pr | 13:06 |
| 10x faster sort performance on Skylake CPU vs Ivy Bridge | Felix Geisendörfer | 14:12 |
| Re: Hi | David G. Johnston | 14:42 |
| Re: 10x faster sort performance on Skylake CPU vs Ivy Bridge | Tom Lane | 15:07 |
| Re: Execution plan analysis | Tomas Vondra | 15:33 |
| Partitioned table - scans through every partitions | Aniko Belim | 15:36 |
| Re: 10x faster sort performance on Skylake CPU vs Ivy Bridge | Peter Geoghegan | 15:43 |
| Re: Partitioned table - scans through every partitions | Justin Pryzby | 15:44 |
| Re: Partitioned table - scans through every partitions | Aniko Belim | 16:08 |
| Thread | Author | Time |
|---|---|---|
| Re: 10x faster sort performance on Skylake CPU vs Ivy Bridge | Felix Geisendörfer | 10:56 |
| Re: performance problem on big tables | Mariel Cherkassky | 16:34 |
| Thread | Author | Time |
|---|---|---|
| Re: performance problem on big tables | Claudio Freire | 05:47 |
| Re: performance problem on big tables | Claudio Freire | 05:51 |
| Re: performance problem on big tables | Mariel Cherkassky | 06:05 |
| Thread | Author | Time |
|---|---|---|
| Re: printing results of query to file in different times | Mariel Cherkassky | 08:07 |
| Fwd: printing results of query to file in different times | Mariel Cherkassky | 08:44 |
| Re: printing results of query to file in different times | Roman Konoval | 12:26 |
| Re: printing results of query to file in different times | George Neuner | 13:24 |
| Thread | Author | Time |
|---|---|---|
| Handling small inserts from many connections. 📎 | 우성민 | 08:14 |
| Re: Handling small inserts from many connections. 📎 | Michael Vitale | 11:57 |
| Re: Handling small inserts from many connections. | Scott Marlowe | 18:15 |
| Re: Handling small inserts from many connections. | Michaeldba@sqlexec.com | 22:06 |
| Re: Handling small inserts from many connections. | Jeff Janes | 22:27 |
| Re: Handling small inserts from many connections. | 우성민 | 22:54 |
| Thread | Author | Time |
|---|---|---|
| Re: printing results of query to file in different times | Mariel Cherkassky | 11:28 |
| slow index scan performance | Soni M | 13:24 |
| Re: slow index scan performance | Soni M | 13:46 |
| Re: slow index scan performance | Soni M | 13:58 |
| Re: printing results of query to file in different times | George Neuner | 14:23 |
| Re: printing results of query to file in different times | George Neuner | 17:12 |
| Thread | Author | Time |
|---|---|---|
| OS cache management | Soni M | 08:12 |
| Slow vacuum of GIST indexes, because of random reads on PostgreSQL 9.6 | Marcin Barczynski | 11:57 |
| Re: OS cache management | Gerardo Herzig | 14:13 |
| Re: [SPAM] OS cache management | Moreno Andreo | 14:45 |
| Re: printing results of query to file in different times | George Neuner | 16:55 |
| Thread | Author | Time |
|---|---|---|
| Poor perfomance of update (and select) on partitioned tables | Konstantin Kivi | 15:13 |
| Re: printing results of query to file in different times | George Neuner | 17:26 |
| Thread | Author | Time |
|---|---|---|
| Explain Analyze - actual time in loops | Neto pr | 03:17 |
| Re: Explain Analyze - actual time in loops | Igor Neyman | 12:46 |
| Re: Explain Analyze - actual time in loops | Neto pr | 13:08 |
| Re: Explain Analyze - actual time in loops | Tom Lane | 13:44 |
| Re: Explain Analyze - actual time in loops | Neto pr | 14:02 |
| Re: Explain Analyze - actual time in loops | Tom Lane | 14:07 |
| Thread | Author | Time |
|---|---|---|
| Re: OS cache management | Soni M | 05:48 |
| Re: [SPAM] OS cache management | Soni M | 05:49 |
| Thread | Author | Time |
|---|---|---|
| postgresql 9.6 data directory fs becomes full | Mariel Cherkassky | 09:42 |
| Re: postgresql 9.6 data directory fs becomes full | Tom Lane | 12:02 |
| Re: postgresql 9.6 data directory fs becomes full | Jerry Sievers | 17:07 |
| Thread | Author | Time |
|---|---|---|
| query of partitioned object doesnt use index in qa | Mike Broers | 20:28 |
| Re: query of partitioned object doesnt use index in qa | David Rowley | 21:57 |
| Thread | Author | Time |
|---|---|---|
| Store/Retrieve time series data from PostgreSQL | Subramaniam C | 11:51 |
| Re: Store/Retrieve time series data from PostgreSQL | vinny | 12:03 |
| Re: Store/Retrieve time series data from PostgreSQL | Subramaniam C | 12:33 |
| Re: Store/Retrieve time series data from PostgreSQL | Subramaniam C | 12:38 |
| Re: query of partitioned object doesnt use index in qa | Mike Broers | 13:25 |
| Thread | Author | Time |
|---|---|---|
| Re: query of partitioned object doesnt use index in qa | Mike Broers | 20:18 |
| 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 |
|---|---|---|
| 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 |