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: Slow update on column that is part of exclusion constraint | Adam Brusselback | 17:14 |
| Re: Slow update on column that is part of exclusion constraint | Evgeniy Shishkin | 18:54 |
| Thread | Author | Time |
|---|---|---|
| Re: Slow update on column that is part of exclusion constraint 📎 | Adam Brusselback | 04:17 |
| Thread | Author | Time |
|---|---|---|
| Re: Slow update on column that is part of exclusion constraint | Evgeniy Shishkin | 09:31 |
| Thread | Author | Time |
|---|---|---|
| Hash join seq scan slow | Aldo Sarmiento | 08:07 |
| Thread | Author | Time |
|---|---|---|
| Re: Hash join seq scan slow | Jeff Janes | 00:04 |
| Re: Clarification on using pg_upgrade | Tory M Blue | 04:01 |
| Performant queries on table with many boolean columns | Rob Imig | 18:41 |
| Re: Performant queries on table with many boolean columns | Teodor Sigaev | 18:54 |
| Re: Performant queries on table with many boolean columns | Rick Otten | 21:07 |
| Re: Performant queries on table with many boolean columns | David G. Johnston | 21:49 |
| Thread | Author | Time |
|---|---|---|
| Performance problems with postgres and null Values? | Sven Kerkling | 09:49 |
| Re: Performant queries on table with many boolean columns | Teodor Sigaev | 10:04 |
| Re: Performant queries on table with many boolean columns | David G. Johnston | 16:12 |
| Re: Performant queries on table with many boolean columns | Jeff Janes | 16:36 |
| Re: Performant queries on table with many boolean columns | Jeff Janes | 16:45 |
| Re: Performant queries on table with many boolean columns | Rob Imig | 19:34 |
| Thread | Author | Time |
|---|---|---|
| Re: Performant queries on table with many boolean columns | Rob Imig | 13:57 |
| Re: Performance problems with postgres and null Values? | Merlin Moncure | 22:10 |
| Thread | Author | Time |
|---|---|---|
| Re: Performant queries on table with many boolean columns | bricklen | 20:10 |
| Re: Performant queries on table with many boolean columns | bricklen | 20:14 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance problems with postgres and null Values? | Sven Kerkling | 07:22 |
| Re: Performance problems with postgres and null Values? | Albe Laurenz | 08:08 |
| Re: Performant queries on table with many boolean columns | Merlin Moncure | 16:28 |
| Re: Performant queries on table with many boolean columns | Adam Brusselback | 17:23 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance problems with postgres and null Values? | Sven Kerkling | 10:13 |
| Poor disk (virtio) Performance Inside KVM virt-machine vs host machine | Artem Tomyuk | 14:03 |
| Re: Poor disk (virtio) Performance Inside KVM virt-machine vs host machine | Imre Samu | 14:32 |
| Re: Poor disk (virtio) Performance Inside KVM virt-machine vs host machine | Michael Nolan | 15:21 |
| Re: Poor disk (virtio) Performance Inside KVM virt-machine vs host machine | Artem Tomyuk | 15:27 |
| Re: Poor disk (virtio) Performance Inside KVM virt-machine vs host machine | Alan Hodgson | 20:47 |
| Re: Poor disk (virtio) Performance Inside KVM virt-machine vs host machine | Merlin Moncure | 20:52 |
| Thread | Author | Time |
|---|---|---|
| testing - please ignore | George Neuner | 02:41 |
| Thread | Author | Time |
|---|---|---|
| LIKE pattern | Владимир | 09:48 |
| Thread | Author | Time |
|---|---|---|
| Re: LIKE pattern | SoDupuDupu | 21:41 |
| Thread | Author | Time |
|---|---|---|
| Re: LIKE pattern | Robert Klemme | 15:13 |
| Re: LIKE pattern | Jeff Janes | 17:02 |
| Re: LIKE pattern | Tom Lane | 17:25 |
| Thread | Author | Time |
|---|---|---|
| Database transaction with intermittent slow responses | John Gorman | 19:59 |
| Re: Database transaction with intermittent slow responses | Gerardo Herzig | 21:05 |
| Re: Database transaction with intermittent slow responses | John Gorman | 21:25 |
| Re: Database transaction with intermittent slow responses | Gerardo Herzig | 23:11 |
| Thread | Author | Time |
|---|---|---|
| Re: Database transaction with intermittent slow responses | Robert Klemme | 09:47 |
| Thread | Author | Time |
|---|---|---|
| Re: Database transaction with intermittent slow responses | John Gorman | 18:24 |
| Thread | Author | Time |
|---|---|---|
| Locks when launching function across schemata | Christian Castelli | 11:10 |
| Thread | Author | Time |
|---|---|---|
| index fragmentation on insert-only table with non-unique column | Justin Pryzby | 17:39 |
| Thread | Author | Time |
|---|---|---|
| Re: index fragmentation on insert-only table with non-unique column | Peter Geoghegan | 04:16 |
| Re: index fragmentation on insert-only table with non-unique column | Stephen Frost | 04:26 |
| Re: index fragmentation on insert-only table with non-unique column | Tom Lane | 04:43 |
| Re: index fragmentation on insert-only table with non-unique column | Peter Geoghegan | 05:18 |
| Re: index fragmentation on insert-only table with non-unique column | Jeff Janes | 06:23 |
| Re: index fragmentation on insert-only table with non-unique column | Justin Pryzby | 13:45 |
| Re: index fragmentation on insert-only table with non-unique column | Justin Pryzby | 14:00 |
| 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6 | Vladimir Borodin | 14:33 |
| Testing in AWS, EBS | Tory M Blue | 22:34 |
| Re: Testing in AWS, EBS | Rayson Ho | 23:02 |
| Re: Testing in AWS, EBS | Yves Dorfsman | 23:56 |
| Thread | Author | Time |
|---|---|---|
| Re: Testing in AWS, EBS | Rayson Ho | 01:08 |
| Re: Testing in AWS, EBS | Artem Tomyuk | 08:41 |
| Re: Testing in AWS, EBS | Yves Dorfsman | 12:53 |
| Re: Testing in AWS, EBS | Artem Tomyuk | 13:00 |
| Re: Testing in AWS, EBS | Rayson Ho | 13:50 |
| Re: Testing in AWS, EBS | Artem Tomyuk | 14:00 |
| Re: Testing in AWS, EBS | Rayson Ho | 14:47 |
| Re: Testing in AWS, EBS | Artem Tomyuk | 14:52 |
| Re: Testing in AWS, EBS | Rayson Ho | 14:54 |
| Re: Testing in AWS, EBS | Artem Tomyuk | 15:03 |
| Re: Testing in AWS, EBS | Yves Dorfsman | 15:41 |
| Re: Testing in AWS, EBS | Rayson Ho | 21:26 |
| Thread | Author | Time |
|---|---|---|
| Performance problems with 9.2.15 | Johan Fredriksson | 12:10 |
| Re: Performance problems with 9.2.15 | Tom Lane | 13:46 |
| Re: Performance problems with 9.2.15 | Johan Fredriksson | 14:13 |
| Re: Performance problems with 9.2.15 | Steve Crawford | 14:45 |
| Re: 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6 | Vladimir Borodin | 16:57 |
| Planner chooses slow index heap scan despite accurate row estimates | Jake Magner | 19:08 |
| Re: 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6 | Andres Freund | 21:56 |
| Re: Planner chooses slow index heap scan despite accurate row estimates | Tom Lane | 23:17 |
| Re: Planner chooses slow index heap scan despite accurate row estimates | Jake Magner | 23:30 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: Planner chooses slow index heap scan despite accurate row estimates | Tom Lane | 00:16 |
| Thread | Author | Time |
|---|---|---|
| Re: Planner chooses slow index heap scan despite accurate row estimates | Jake Magner | 00:38 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance problems with 9.2.15 | Johan Fredriksson | 07:35 |
| Re: Performance problems with 9.2.15 | Johan Fredriksson | 13:56 |
| Re: 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6 | Vladimir Borodin | 14:53 |
| Re: 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6 | Vladimir Borodin | 17:03 |
| similarity and operator '%' | Volker Boehm | 17:53 |
| Re: similarity and operator '%' | David G. Johnston | 18:20 |
| Re: Re: Planner chooses slow index heap scan despite accurate row estimates | Jeff Janes | 19:34 |
| Re: similarity and operator '%' | Jeff Janes | 20:05 |
| Thread | Author | Time |
|---|---|---|
| Re: 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6 | Vladimir Borodin | 09:06 |
| Thread | Author | Time |
|---|---|---|
| Re: 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6 | Антон Бушмелев | 11:18 |
| Thread | Author | Time |
|---|---|---|
| Re: index fragmentation on insert-only table with non-unique column | Claudio Freire | 21:26 |
| slony rpm help slony1-95-2.2.2-1.rhel6.x86_64 | avi Singh | 23:03 |
| Re: index fragmentation on insert-only table with non-unique column | Justin Pryzby | 23:54 |
| Thread | Author | Time |
|---|---|---|
| Re: index fragmentation on insert-only table with non-unique column | Claudio Freire | 02:05 |
| pg_database_size | sangeetha | 07:35 |
| Re: pg_database_size | Venkata Balaji N | 08:10 |
| Re: index fragmentation on insert-only table with non-unique column | Kevin Grittner | 13:39 |
| Thread | Author | Time |
|---|---|---|
| Re: index fragmentation on insert-only table with non-unique column | Tom Lane | 16:03 |
| Re: index fragmentation on insert-only table with non-unique column | Jeff Janes | 19:28 |
| Thread | Author | Time |
|---|---|---|
| Performance of LIKE/NOT LIKE when used in single query | Ed Felstein | 04:57 |
| Re: Performance of LIKE/NOT LIKE when used in single query | David G. Johnston | 05:33 |
| Re: array size exceeds the maximum allowed (1073741823) when building a json | Michael Paquier | 05:56 |
| Re: array size exceeds the maximum allowed (1073741823) when building a json | Tom Lane | 06:04 |
| Re: Combination of partial and full indexes | Rafał Gutkowski | 08:52 |
| Re: Combination of partial and full indexes | Rafał Gutkowski | 09:01 |
| Thread | Author | Time |
|---|---|---|
| Re: array size exceeds the maximum allowed (1073741823) when building a json | Merlin Moncure | 13:31 |
| Re: array size exceeds the maximum allowed (1073741823) when building a json | Nicolas Paris | 13:43 |
| Re: slony rpm help slony1-95-2.2.2-1.rhel6.x86_64 | Glyn Astill | 15:32 |
| Re: Performance of LIKE/NOT LIKE when used in single query | Jeff Janes | 16:37 |
| Re: array size exceeds the maximum allowed (1073741823) when building a json | Merlin Moncure | 20:36 |
| Re: 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6 | Andres Freund | 22:28 |
| Thread | Author | Time |
|---|---|---|
| Many-to-many performance problem | Rowan Seymour | 13:04 |
| Re: Many-to-many performance problem | Tom Lane | 14:13 |
| Re: Many-to-many performance problem | Yves Dorfsman | 14:27 |
| Re: Many-to-many performance problem | Tom Lane | 15:23 |
| Re: Many-to-many performance problem | Alex Ignatov | 16:11 |
| Thread | Author | Time |
|---|---|---|
| Re: [PERFORM] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6 | Vladimir Borodin | 21:42 |
| Re: [PERFORM] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6 | Andres Freund | 21:51 |
| Thread | Author | Time |
|---|---|---|
| Re: [PERFORM] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6 | Vladimir Borodin | 18:58 |
| Thread | Author | Time |
|---|---|---|
| Re: pg_database_size | Jim Nasby | 21:00 |
| Re: Clarification on using pg_upgrade | Jim Nasby | 21:03 |
| Re: Clarification on using pg_upgrade | Tory M Blue | 21:08 |
| Thread | Author | Time |
|---|---|---|
| Indexes for hashes | Ivan Voras | 09:34 |
| Re: Clarification on using pg_upgrade | Glyn Astill | 10:14 |
| Re: Indexes for hashes | Torsten Zuehlsdorff | 12:45 |
| Re: Indexes for hashes | [email protected] | 13:03 |
| Re: Indexes for hashes | Ivan Voras | 13:09 |
| Re: Indexes for hashes | [email protected] | 13:16 |
| Re: Indexes for hashes | hubert depesz lubaczewski | 13:38 |
| Re: Indexes for hashes | Ivan Voras | 13:54 |
| Re: Indexes for hashes | julyanto SUTANDANG | 13:58 |
| Re: Indexes for hashes | Ivan Voras | 14:00 |
| Re: Indexes for hashes | Ivan Voras | 14:20 |
| Re: Indexes for hashes | Joshua D. Drake | 14:36 |
| Re: Indexes for hashes | [email protected] | 14:53 |
| Re: Indexes for hashes | Jeff Janes | 15:14 |
| pg_restore seems very slow | Adrian Myers | 22:00 |
| Re: pg_restore seems very slow | David G. Johnston | 22:08 |
| Re: pg_restore seems very slow | Adrian Myers | 23:41 |
| Thread | Author | Time |
|---|---|---|
| Re: pg_restore seems very slow | Adam Scott | 01:43 |
| Index not used | meike.talbach | 07:58 |
| Re: Many-to-many performance problem | Rowan Seymour | 08:29 |
| Re: Index not used | John Gorman | 12:27 |
| Re: Index not used | Tom Lane | 15:05 |
| Re: Index not used | David G. Johnston | 15:53 |
| Thread | Author | Time |
|---|---|---|
| 9.6 query slower than 9.5.3 | Adam Brusselback | 01:56 |
| Re: 9.6 query slower than 9.5.3 | Tom Lane | 02:04 |
| Re: 9.6 query slower than 9.5.3 | Adam Brusselback | 02:09 |
| Re: 9.6 query slower than 9.5.3 | Adam Brusselback | 02:14 |
| Re: 9.6 query slower than 9.5.3 | Tom Lane | 02:45 |
| Re: 9.6 query slower than 9.5.3 | Adam Brusselback | 03:36 |
| Re: Indexes for hashes | Claudio Freire | 03:51 |
| Re: 9.6 query slower than 9.5.3 | Tom Lane | 03:57 |
| Re: 9.6 query slower than 9.5.3 | Adam Brusselback | 04:07 |
| Re: Indexes for hashes | julyanto SUTANDANG | 04:09 |
| Re: Indexes for hashes | Claudio Freire | 04:18 |
| Re: Indexes for hashes | Ivan Voras | 08:32 |
| Re: Indexes for hashes | julyanto SUTANDANG | 08:48 |
| Re: 9.6 query slower than 9.5.3 | Adam Brusselback | 15:18 |
| Savepoint and Releasepoint in Logs | e.ratnakar.shetty | 15:19 |
| Re: 9.6 query slower than 9.5.3 | Tom Lane | 15:22 |
| Thread | Author | Time |
|---|---|---|
| Re: Index not used 📎 | meike.talbach | 09:59 |
| Re: Savepoint and Releasepoint in Logs | Jeff Janes | 16:55 |
| Thread | Author | Time |
|---|---|---|
| Looking for more Beta Users! | jonescam | 14:00 |
| Thread | Author | Time |
|---|---|---|
| Can't get two index scans | Craig James | 16:03 |
| Re: Can't get two index scans | Jeff Janes | 18:36 |
| Thread | Author | Time |
|---|---|---|
| Re: Can't get two index scans | Craig James | 04:36 |
| Re: Can't get two index scans | Jeff Janes | 15:47 |
| Re: Can't get two index scans | Craig James | 19:52 |
| Thread | Author | Time |
|---|---|---|
| can't explain commit performance win7 vs linux : 8000/s vs 419/s | [email protected] | 16:19 |
| Re: can't explain commit performance win7 vs linux : 8000/s vs 419/s | Tom Lane | 18:08 |
| Re: can't explain commit performance win7 vs linux : 8000/s vs 419/s | Jeff Janes | 19:23 |
| Re: can't explain commit performance win7 vs linux : 8000/s vs 419/s | Imre Samu | 22:27 |
| Thread | Author | Time |
|---|---|---|
| [PERFORM] Cache performance decreases | Suren Arustamyan | 11:43 |
| Thread | Author | Time |
|---|---|---|
| testing - ignore | George Neuner | 14:10 |
| Thread | Author | Time |
|---|---|---|
| Random slow queries | devel.brain99 | 01:24 |
| pg_xlog dir not getting swept | Niels Kristian Schjødt | 10:00 |
| Re: Random slow queries | Kevin Grittner | 12:45 |
| Re: Random slow queries | Igor Neyman | 14:32 |
| Re: Random slow queries | devel.brain99 | 18:01 |
| Re: Random slow queries | devel.brain99 | 18:04 |
| Re: pg_xlog dir not getting swept | Jeff Janes | 19:19 |
| Re: Random slow queries | Tom Lane | 20:20 |
| Re: Random slow queries | Jeff Janes | 21:30 |
| Re: Random slow queries | Tom Lane | 21:44 |