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: Possible to find disk IOs for a Query? | Mark Kirkwood | 05:56 |
| Re: Possible to find disk IOs for a Query? | Mark Kirkwood | 09:08 |
| Thread | Author | Time |
|---|---|---|
| Postgres bulk insert/ETL performance on high speed servers - test results | Mike Sofen | 02:30 |
| Re: Postgres bulk insert/ETL performance on high speed servers - test results | Claudio Freire | 20:26 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgres bulk insert/ETL performance on high speed servers - test results | Mike Sofen | 12:34 |
| Thread | Author | Time |
|---|---|---|
| debug_assertions is enabled in official 9.6rc1 build | Mkrtchyan, Tigran | 14:32 |
| Re: Postgres bulk insert/ETL performance on high speed servers - test results | Jim Nasby | 19:22 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgres bulk insert/ETL performance on high speed servers - test results | Mike Sofen | 02:28 |
| Thread | Author | Time |
|---|---|---|
| How to reduce IOWAIT and CPU idle time? | Samir Magar | 10:49 |
| Thread | Author | Time |
|---|---|---|
| Re: How to reduce IOWAIT and CPU idle time? | Venkata B Nagothi | 00:34 |
| Re: How to reduce IOWAIT and CPU idle time? | Jeff Janes | 01:46 |
| Re: How to reduce IOWAIT and CPU idle time? | Samir Magar | 07:10 |
| Re: How to reduce IOWAIT and CPU idle time? | Pavan Deolasee | 07:40 |
| Re: How to reduce IOWAIT and CPU idle time? | Samir Magar | 08:04 |
| Thread | Author | Time |
|---|---|---|
| Strange nested loop for an INSERT 📎 | phb07 | 14:15 |
| Re: Strange nested loop for an INSERT | Tom Lane | 14:41 |
| Re: Strange nested loop for an INSERT | phb07 | 18:05 |
| Thread | Author | Time |
|---|---|---|
| Disk filled-up issue after a lot of inserts and drop schema | Pietro Pugni | 13:53 |
| Re: Disk filled-up issue after a lot of inserts and drop schema | Rick Otten | 14:17 |
| Re: Disk filled-up issue after a lot of inserts and drop schema | Tom Lane | 14:44 |
| Re: Disk filled-up issue after a lot of inserts and drop schema | Pietro Pugni | 17:45 |
| Re: Disk filled-up issue after a lot of inserts and drop schema | Tom Lane | 17:55 |
| Re: Disk filled-up issue after a lot of inserts and drop schema | Pietro Pugni | 18:00 |
| Thread | Author | Time |
|---|---|---|
| Problem with performance using query with unnest after migrating from V9.1 to V9.2 and higher | Knels, Udo | 07:29 |
| Postgresql 8.4 optimize for heavy select load | Job | 07:40 |
| Re: Postgresql 8.4 optimize for heavy select load | Mark Kirkwood | 08:23 |
| Re: Postgresql 8.4 optimize for heavy select load | Torsten Zuehlsdorff | 09:09 |
| Re: Postgresql 8.4 optimize for heavy select load | julyanto SUTANDANG | 10:05 |
| Thread | Author | Time |
|---|---|---|
| query against single partition uses index, against master table does seq scan | Mike Broers | 16:53 |
| Re: query against single partition uses index, against master table does seq scan | Ganesh Kannan | 17:15 |
| Re: query against single partition uses index, against master table does seq scan | Mike Broers | 17:37 |
| Re: query against single partition uses index, against master table does seq scan | Mike Broers | 21:00 |
| Re: Strange nested loop for an INSERT | Jim Nasby | 21:42 |
| Re: Problem with performance using query with unnest after migrating from V9.1 to V9.2 and higher | Jim Nasby | 21:48 |
| Thread | Author | Time |
|---|---|---|
| Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause | Sven R. Kunze | 06:35 |
| Storing large documents - one table or partition by doc? | Dev Nop | 10:12 |
| Re: Storing large documents - one table or partition by doc? | Mike Sofen | 12:14 |
| Re: Strange nested loop for an INSERT | phb07 | 17:59 |
| Re: Strange nested loop for an INSERT | Jim Nasby | 18:51 |
| Re: Storing large documents - one table or partition by doc? | Jim Nasby | 18:59 |
| Thread | Author | Time |
|---|---|---|
| Re: Storing large documents - one table or partition by doc? | Dev Nop | 11:33 |
| Re: Storing large documents - one table or partition by doc? | Jim Nasby | 21:30 |
| Thread | Author | Time |
|---|---|---|
| Re: Millions of tables | Craig James | 14:30 |
| Re: Millions of tables | Mike Sofen | 15:10 |
| Re: Millions of tables | Mike Sofen | 15:42 |
| Re: Millions of tables | Greg Spiegelberg | 15:46 |
| Re: Millions of tables | Greg Spiegelberg | 15:49 |
| Re: PostgreSQL on ZFS: performance tuning | Torsten Zuehlsdorff | 16:00 |
| Re: Millions of tables | Terry Schmitt | 16:15 |
| Re: Millions of tables | Greg Spiegelberg | 16:27 |
| Re: PostgreSQL on ZFS: performance tuning | Tomas Vondra | 21:38 |
| Re: PostgreSQL on ZFS: performance tuning | Karl Denninger | 22:15 |
| Thread | Author | Time |
|---|---|---|
| Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause | Sven R. Kunze | 11:22 |
| Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause 📎 | Sven R. Kunze | 11:29 |
| MYSQL Stats | Joe Proietti | 12:03 |
| Re: MYSQL Stats | Joe Proietti | 13:44 |
| Re: Unexpected expensive index scan | Jim Nasby | 22:19 |
| Re: Millions of tables | Jim Nasby | 22:49 |
| Thread | Author | Time |
|---|---|---|
| Re: Millions of tables | Jeff Janes | 17:54 |
| Thread | Author | Time |
|---|---|---|
| Understanding BRIN index performance | Ivan Voras | 09:00 |
| Re: Understanding BRIN index performance | Madusudanan.B.N | 09:26 |
| Re: Understanding BRIN index performance | Simon Riggs | 09:40 |
| Re: Understanding BRIN index performance | Ivan Voras | 09:58 |
| Re: Understanding BRIN index performance | Simon Riggs | 10:05 |
| Re: Understanding BRIN index performance | Ivan Voras | 11:29 |
| Thread | Author | Time |
|---|---|---|
| Re: MYSQL Stats | Gavin Flower | 04:20 |
| Thread | Author | Time |
|---|---|---|
| Re: Millions of tables | Greg Spiegelberg | 12:34 |
| Thread | Author | Time |
|---|---|---|
| Re: Millions of tables | Jim Nasby | 21:42 |
| Thread | Author | Time |
|---|---|---|
| Why query plan is different? 📎 | Andrzej Zawadzki | 15:31 |
| Re: Why query plan is different? | Pavel Stehule | 17:09 |
| Re: Why query plan is different? 📎 | Andrzej Zawadzki | 20:51 |
| Re: Why query plan is different? 📎 | Andrzej Zawadzki | 21:17 |
| Thread | Author | Time |
|---|---|---|
| Re: Why query plan is different? | Pavel Stehule | 01:47 |
| Re: Why query plan is different? 📎 | Andrzej Zawadzki | 11:19 |
| Re: Why query plan is different? | Pavel Stehule | 11:21 |
| Thread | Author | Time |
|---|---|---|
| Delay in converting logs from ready state to done state | Samir Magar | 05:26 |
| Re: Delay in converting logs from ready state to done state | Julien Rouhaud | 06:03 |
| Fwd: Delay in converting logs from ready state to done state | Samir Magar | 07:04 |
| Thread | Author | Time |
|---|---|---|
| pg_basebackup running slow | Swapnil Vaze | 12:35 |
| Re: pg_basebackup running slow | Samir Magar | 13:21 |
| Re: pg_basebackup running slow | Michael Paquier | 13:37 |
| Re: pg_basebackup running slow | Stephen Frost | 13:37 |
| Hibernate generated query slow compared to 'equivalent' hand written one | Kyle Moser | 17:27 |
| Re: Hibernate generated query slow compared to 'equivalent' hand written one | Tom Lane | 17:46 |
| Re: Hibernate generated query slow compared to 'equivalent' hand written one | Kyle Moser | 18:09 |
| Re: Hibernate generated query slow compared to 'equivalent' hand written one | Tom Lane | 18:37 |
| Thread | Author | Time |
|---|---|---|
| Should I generate strings in Postgres of Python? | Bobby Mozumder | 20:35 |
| Re: Should I generate strings in Postgres of Python? | Sam Gendler | 22:53 |
| Thread | Author | Time |
|---|---|---|
| Performance of a nested loop, whose inner loop uses an index scan. | negora | 10:54 |
| Re: Performance of a nested loop, whose inner loop uses an index scan. | Matheus de Oliveira | 11:15 |
| Re: Performance of a nested loop, whose inner loop uses an index scan. 📎 | negora | 17:07 |
| Thread | Author | Time |
|---|---|---|
| Fast insert, but slow join and updates for table with 4 billion rows | Lars Aksel Opsahl | 08:11 |
| Re: Fast insert, but slow join and updates for table with 4 billion rows | Tom Lane | 12:52 |
| Re: Fast insert, but slow join and updates for table with 4 billion rows | Lars Aksel Opsahl | 20:07 |
| Re: Fast insert, but slow join and updates for table with 4 billion rows | Scott Marlowe | 20:23 |
| Re: Fast insert, but slow join and updates for table with 4 billion rows | Lars Aksel Opsahl | 20:44 |
| Thread | Author | Time |
|---|---|---|
| Re: Fast insert, but slow join and updates for table with 4 billion rows | Lars Aksel Opsahl | 20:52 |
| Thread | Author | Time |
|---|---|---|
| query slowdown after 9.0 -> 9.4 migration | Filip Rembiałkowski | 13:48 |
| Re: query slowdown after 9.0 -> 9.4 migration | Tomas Vondra | 22:55 |
| Thread | Author | Time |
|---|---|---|
| Re: query slowdown after 9.0 -> 9.4 migration | Andreas Kretschmer | 05:38 |
| limit 1 on view never finishes | Craig James | 20:46 |
| Thread | Author | Time |
|---|---|---|
| Re: query slowdown after 9.0 -> 9.4 migration | Filip Rembiałkowski | 01:37 |
| Big Memory Boxes and pgtune | Warner, Gary, Jr | 15:44 |
| Re: Big Memory Boxes and pgtune | Kevin Grittner | 17:09 |
| Re: Big Memory Boxes and pgtune | Joshua D. Drake | 19:33 |
| Thread | Author | Time |
|---|---|---|
| Tuning Checkpoints | Andre Henry | 19:19 |
| Re: Tuning Checkpoints | Tomas Vondra | 21:59 |
| Thread | Author | Time |
|---|---|---|
| Refresh materialized view vs recreate | Антон Мазунин | 06:26 |
| Re: Refresh materialized view vs recreate | Kevin Grittner | 15:25 |
| Thread | Author | Time |
|---|---|---|
| Perf decreased although server is better | Benjamin Toueg | 13:26 |
| Re: Perf decreased although server is better | Tomas Vondra | 14:36 |
| Re: Perf decreased although server is better | Kevin Grittner | 14:38 |
| Re: Perf decreased although server is better | Rick Otten | 14:55 |
| no MCV list of tiny table with unique columns | Justin Pryzby | 18:53 |
| archive_command too slow. | Joao Junior | 19:06 |
| Re: no MCV list of tiny table with unique columns | Tom Lane | 20:05 |
| Re: no MCV list of tiny table with unique columns | Justin Pryzby | 20:19 |
| Re: limit 1 on view never finishes | Jim Nasby | 23:37 |
| Re: query slowdown after 9.0 -> 9.4 migration | Jim Nasby | 23:43 |
| Re: Big Memory Boxes and pgtune | Jim Nasby | 23:46 |
| Re: no MCV list of tiny table with unique columns | Tom Lane | 23:48 |
| Thread | Author | Time |
|---|---|---|
| Re: Perf decreased although server is better | Benjamin Toueg | 14:51 |
| Hot migration of tables | YueLi | 18:07 |
| Thread | Author | Time |
|---|---|---|
| Re: Perf decreased although server is better | Kevin Grittner | 00:05 |
| Re: Big Memory Boxes and pgtune | Scott Marlowe | 02:24 |