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: pg_xlog dir not getting swept | Niels Kristian Schjødt | 09:36 |
| Thread | Author | Time |
|---|---|---|
| less than 2 sec for response - possible? | trafdev | 00:54 |
| Re: less than 2 sec for response - possible? | Tom Lane | 01:23 |
| Re: less than 2 sec for response - possible? | trafdev | 02:48 |
| Thread | Author | Time |
|---|---|---|
| Re: Random slow queries | devel.brain99 | 12:19 |
| Re: [HACKERS] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6 | Vladimir Borodin | 13:30 |
| DELETE takes too much memory | Kouber Saparev | 16:35 |
| Re: DELETE takes too much memory | Alvaro Herrera | 17:04 |
| Re: DELETE takes too much memory | Kouber Saparev | 17:10 |
| Thread | Author | Time |
|---|---|---|
| Re: less than 2 sec for response - possible? | Pujol Mathieu | 10:10 |
| Re: less than 2 sec for response - possible? | Torsten Zuehlsdorff | 11:39 |
| Seeing execution plan of foreign key constraint check? | Robert Klemme | 12:14 |
| Tuning guidelines for server with 256GB of RAM and SSDs? | Kaixi Luo | 14:50 |
| Re: less than 2 sec for response - possible? | trafdev | 15:35 |
| Re: DELETE takes too much memory | Josh Berkus | 18:51 |
| Re: Tuning guidelines for server with 256GB of RAM and SSDs? 📎 | Mkrtchyan, Tigran | 19:17 |
| Re: DELETE takes too much memory | Kouber Saparev | 21:03 |
| Thread | Author | Time |
|---|---|---|
| Re: less than 2 sec for response - possible? | Torsten Zuehlsdorff | 08:35 |
| Re: less than 2 sec for response - possible? | trafdev | 15:06 |
| Re: less than 2 sec for response - possible? | Torsten Zuehlsdorff | 15:27 |
| Re: DELETE takes too much memory | Merlin Moncure | 16:12 |
| Re: less than 2 sec for response - possible? | trafdev | 16:46 |
| Re: Tuning guidelines for server with 256GB of RAM and SSDs? | Merlin Moncure | 18:13 |
| Re: Tuning guidelines for server with 256GB of RAM and SSDs? | Scott Marlowe | 21:48 |
| Re: Tuning guidelines for server with 256GB of RAM and SSDs? | Wes Vaske (wvaske) | 22:34 |
| Thread | Author | Time |
|---|---|---|
| Re: Tuning guidelines for server with 256GB of RAM and SSDs? | Mark Kirkwood | 04:59 |
| Re: DELETE takes too much memory | Kouber Saparev | 07:39 |
| Re: Tuning guidelines for server with 256GB of RAM and SSDs? | Kaixi Luo | 07:49 |
| Re: Tuning guidelines for server with 256GB of RAM and SSDs? | Wes Vaske (wvaske) | 14:09 |
| Re: Tuning guidelines for server with 256GB of RAM and SSDs? | Merlin Moncure | 16:27 |
| Re: Tuning guidelines for server with 256GB of RAM and SSDs? | Scott Marlowe | 17:00 |
| Re: Tuning guidelines for server with 256GB of RAM and SSDs? | Kaixi Luo | 21:06 |
| Thread | Author | Time |
|---|---|---|
| Re: Tuning guidelines for server with 256GB of RAM and SSDs? | Mark Kirkwood | 03:13 |
| Capacitors, etc., in hard drives and SSD for DBMS machines... | Jean-David Beyer | 10:23 |
| Re: Capacitors, etc., in hard drives and SSD for DBMS machines... | Levente Birta | 10:36 |
| Re: Capacitors, etc., in hard drives and SSD for DBMS machines... | Thomas Samson | 10:45 |
| Re: Capacitors, etc., in hard drives and SSD for DBMS machines... | vincent | 11:44 |
| Re: Capacitors, etc., in hard drives and SSD for DBMS machines... | Karl Denninger | 13:27 |
| Re: Capacitors, etc., in hard drives and SSD for DBMS machines... | Wes Vaske (wvaske) | 14:50 |
| Re: Capacitors, etc., in hard drives and SSD for DBMS machines... | Jean-David Beyer | 14:56 |
| Thread | Author | Time |
|---|---|---|
| Re: less than 2 sec for response - possible? | trafdev | 17:26 |
| Thread | Author | Time |
|---|---|---|
| pgtune or similar to assist in initial settings | Tory M Blue | 00:34 |
| Re: pgtune or similar to assist in initial settings | Imre Samu | 20:03 |
| Thread | Author | Time |
|---|---|---|
| Re: [PERFORM] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6 | Andres Freund | 18:48 |
| Re: [PERFORM] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6 | Andres Freund | 18:53 |
| Thread | Author | Time |
|---|---|---|
| Re: [HACKERS] [PERFORM] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6 📎 | Dmitriy Sarafannikov | 09:24 |
| Thread | Author | Time |
|---|---|---|
| Re: slony rpm help slony1-95-2.2.2-1.rhel6.x86_64 | Jan Wieck | 01:14 |
| Thread | Author | Time |
|---|---|---|
| Re: less than 2 sec for response - possible? | Jim Nasby | 14:10 |
| Re: DELETE takes too much memory | Jim Nasby | 14:28 |
| Re: less than 2 sec for response - possible? | trafdev | 14:28 |
| Re: less than 2 sec for response - possible? | Jim Nasby | 14:41 |
| Re: Seeing execution plan of foreign key constraint check? | Jim Nasby | 14:47 |
| Re: Random slow queries | Jim Nasby | 14:51 |
| Re: less than 2 sec for response - possible? | trafdev | 14:56 |
| Re: Seeing execution plan of foreign key constraint check? | Tom Lane | 20:10 |
| Thread | Author | Time |
|---|---|---|
| Poor choice of backward scan | Jim Nasby | 20:56 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance problems with 9.2.15 | Johan Fredriksson | 14:48 |
| Re: Performance problems with 9.2.15 | Claudio Freire | 18:24 |
| Re: Performance problems with 9.2.15 | David G. Johnston | 18:29 |
| Re: Performance problems with 9.2.15 | Claudio Freire | 21:12 |
| Re: Seeing execution plan of foreign key constraint check? | Jim Nasby | 21:42 |
| Re: Seeing execution plan of foreign key constraint check? | Tom Lane | 21:59 |
| Re: Seeing execution plan of foreign key constraint check? | Jim Nasby | 22:14 |
| Re: less than 2 sec for response - possible? | Jim Nasby | 22:20 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance problems with 9.2.15 | Johan Fredriksson | 00:59 |
| Re: Performance problems with 9.2.15 | Johan Fredriksson | 01:07 |
| Re: Performance problems with 9.2.15 | Mark Kirkwood | 07:08 |
| Re: Performance problems with 9.2.15 | Johan Fredriksson | 07:20 |
| Re: Seeing execution plan of foreign key constraint check? | Robert Klemme | 08:37 |
| [PERFORMANCE] Performance index and table | Oscar Camuendo | 13:34 |
| Re: [PERFORMANCE] Performance index and table | Tom Lane | 14:29 |
| Thread | Author | Time |
|---|---|---|
| Re: Seeing execution plan of foreign key constraint check? | Jim Nasby | 01:57 |
| Thread | Author | Time |
|---|---|---|
| Very slow query (3-4mn) on a table with 25millions rows | Abadie Lana | 15:26 |
| Re: Very slow query (3-4mn) on a table with 25millions rows | Tom Lane | 18:06 |
| Thread | Author | Time |
|---|---|---|
| Re: Very slow query (3-4mn) on a table with 25millions rows | Abadie Lana | 09:01 |
| Re: Very slow query (3-4mn) on a table with 25millions rows | Martín Marqués | 10:34 |
| Thread | Author | Time |
|---|---|---|
| Re: Very slow query (3-4mn) on a table with 25millions rows | Abadie Lana | 06:03 |
| Re: Very slow query (3-4mn) on a table with 25millions rows | Félix GERZAGUET | 09:15 |
| Re: Very slow query (3-4mn) on a table with 25millions rows | Félix GERZAGUET | 09:36 |
| Re: Very slow query (3-4mn) on a table with 25millions rows | Abadie Lana | 14:55 |
| Thread | Author | Time |
|---|---|---|
| Re: Very slow query (3-4mn) on a table with 25millions rows | Abadie Lana | 09:55 |
| Thread | Author | Time |
|---|---|---|
| PostgreSQL on ZFS: performance tuning | trafdev | 06:04 |
| Re: PostgreSQL on ZFS: performance tuning | Tomas Vondra | 06:30 |
| Re: PostgreSQL on ZFS: performance tuning | trafdev | 06:47 |
| Thread | Author | Time |
|---|---|---|
| Very poor performance with Nested Loop Anti Join | Andreas Joseph Krogh | 13:33 |
| Re: Very poor performance with Nested Loop Anti Join | Andreas Joseph Krogh | 13:40 |
| Re: Very poor performance with Nested Loop Anti Join | Tom Lane | 23:15 |
| Thread | Author | Time |
|---|---|---|
| Create language plperlu Error | Om Prakash Jaiswal | 05:47 |
| Re: Create language plperlu Error | John R Pierce | 06:05 |
| Re: Create language plperlu Error | Ranjeet Dhumal | 06:45 |
| Re: Create language plperlu Error | John R Pierce | 07:21 |
| Re: Very poor performance with Nested Loop Anti Join | Andreas Joseph Krogh | 11:30 |
| Re: Create language plperlu Error | Luca Ferrari | 12:00 |
| Thread | Author | Time |
|---|---|---|
| Need Beta Users for New Database Monitoring Solution! | jonescam | 16:27 |
| Thread | Author | Time |
|---|---|---|
| Re: [PERFORM] Create language plperlu Error | Johan Fredriksson | 07:26 |
| Re: Create language plperlu Error | Om Prakash Jaiswal | 10:30 |
| Re: [PERFORM] Create language plperlu Error | Gerardo Herzig | 11:21 |
| Thread | Author | Time |
|---|---|---|
| what's the slowest part in the SQL | Suya Huang | 23:27 |
| Re: what's the slowest part in the SQL | Claudio Freire | 23:52 |
| Thread | Author | Time |
|---|---|---|
| Re: what's the slowest part in the SQL | Suya Huang | 00:12 |
| Re: what's the slowest part in the SQL | Claudio Freire | 00:28 |
| Re: what's the slowest part in the SQL | Suya Huang | 00:34 |
| Re: what's the slowest part in the SQL | Tom Lane | 00:45 |
| Re: what's the slowest part in the SQL | Claudio Freire | 00:46 |
| Re: what's the slowest part in the SQL | Claudio Freire | 00:49 |
| Re: what's the slowest part in the SQL | Suya Huang | 01:43 |
| Re: what's the slowest part in the SQL | Suya Huang | 01:46 |
| Re: what's the slowest part in the SQL | Tom Lane | 01:57 |
| Re: what's the slowest part in the SQL | Suya Huang | 02:02 |
| Logging queries using sequential scans | Ivan Voras | 11:13 |
| Re: Logging queries using sequential scans | Pavel Stehule | 11:39 |
| Re: what's the slowest part in the SQL | Claudio Freire | 18:10 |
| Thread | Author | Time |
|---|---|---|
| Planner do seq scan on empty master partitioned table | Andrey Zhidenkov | 10:46 |
| Re: Planner do seq scan on empty master partitioned table | Tom Lane | 13:50 |
| Re: Planner do seq scan on empty master partitioned table | Vladimir Borodin | 13:55 |
| Thread | Author | Time |
|---|---|---|
| Re: index fragmentation on insert-only table with non-unique column | Justin Pryzby | 18:54 |
| Thread | Author | Time |
|---|---|---|
| Re: index fragmentation on insert-only table with non-unique column | Claudio Freire | 17:42 |
| Thread | Author | Time |
|---|---|---|
| Re: what's the slowest part in the SQL | Merlin Moncure | 13:56 |
| Thread | Author | Time |
|---|---|---|
| Big data INSERT optimization - ExclusiveLock on extension of the table | pinker | 11:45 |
| Thread | Author | Time |
|---|---|---|
| Estimates on partial index | Victor Yegorov | 13:52 |
| Re: Estimates on partial index | Tom Lane | 13:56 |
| Re: Estimates on partial index | Jeff Janes | 15:59 |
| Re: Estimates on partial index | Victor Yegorov | 18:40 |
| Re: Estimates on partial index | Victor Yegorov | 18:55 |
| Re: Estimates on partial index | Jeff Janes | 20:06 |
| Re: Big data INSERT optimization - ExclusiveLock on extension of the table | Jim Nasby | 21:50 |
| Re: Estimates on partial index | Jim Nasby | 22:01 |
| Re: Big data INSERT optimization - ExclusiveLock on extension of the table | pinker | 22:26 |
| Thread | Author | Time |
|---|---|---|
| Re: Estimates on partial index | Ashish Kumar Singh | 04:21 |
| Re: Estimates on partial index | Victor Yegorov | 11:31 |
| Re: Estimates on partial index | Victor Yegorov | 12:50 |
| Re: Re: Big data INSERT optimization - ExclusiveLock on extension of the table | Jim Nasby | 14:13 |
| Re: Big data INSERT optimization - ExclusiveLock on extension of the table | Merlin Moncure | 15:01 |
| Thread | Author | Time |
|---|---|---|
| pgsql-performance issue | debasis.moharana | 08:27 |
| pgsql-performance issue | debasis.moharana | 08:38 |
| Re: pgsql-performance issue | Pavel Stehule | 08:58 |
| Re: pgsql-performance issue | debasis.moharana | 11:31 |
| Re: pgsql-performance issue | Pavel Stehule | 11:42 |
| Re: pgsql-performance issue 📎 | debasis.moharana | 11:59 |
| Re: pgsql-performance issue | Pavel Stehule | 12:05 |
| Re: pgsql-performance issue | debasis.moharana | 12:17 |
| Re: pgsql-performance issue | Pavel Stehule | 12:19 |
| Thread | Author | Time |
|---|---|---|
| Re: pgsql-performance issue | debasis.moharana | 06:01 |
| Thread | Author | Time |
|---|---|---|
| Slow query with big tables | Tommi Kaksonen | 11:35 |
| Thread | Author | Time |
|---|---|---|
| Re: Slow query with big tables | Andreas Kretschmer | 10:36 |
| Thread | Author | Time |
|---|---|---|
| Re: Slow query with big tables | Tommi K | 13:17 |
| Re: Slow query with big tables | Craig James | 13:40 |
| Re: Slow query with big tables | Tommi K | 14:25 |
| Re: Slow query with big tables | Mike Sofen | 20:26 |
| Thread | Author | Time |
|---|---|---|
| Re: Slow query with big tables | Jim Nasby | 04:11 |
| Re: Slow query with big tables | Pavel Stehule | 04:55 |
| Re: Slow query with big tables | Craig James | 14:13 |
| Re: Slow query with big tables | Tom Lane | 16:36 |
| Re: Slow query with big tables | Jeff Janes | 18:12 |
| Re: Slow query with big tables | Jeff Janes | 18:33 |
| Thread | Author | Time |
|---|---|---|
| Re: Slow query with big tables | Tommi Kaksonen | 07:00 |
| Re: pgsql-performance issue | Andres Freund | 20:14 |
| Thread | Author | Time |
|---|---|---|
| Possible to find disk IOs for a Query? | Bobby Mozumder | 22:01 |
| Re: Possible to find disk IOs for a Query? | Ben Chobot | 22:10 |
| Re: Possible to find disk IOs for a Query? | Lukas Fittl | 22:17 |
| 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: query against single partition uses index, against master table does seq scan | Tom Lane | 02:11 |
| Re: query against single partition uses index, against master table does seq scan | Mike Broers | 04:09 |
| Re: Problem with performance using query with unnest after migrating from V9.1 to V9.2 and higher | Knels, Udo | 12:39 |
| Multiple-Table-Spanning Joins with ORs in WHERE Clause | Sven R. Kunze | 13:24 |
| Re: Multiple-Table-Spanning Joins with ORs in WHERE Clause | Madusudanan.B.N | 13:37 |
| Re: Problem with performance using query with unnest after migrating from V9.1 to V9.2 and higher | Igor Neyman | 13:38 |