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 |