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: PostgreSQL 9.3.2 Performance tuning for 32 GB server | Julien Cigar | 13:55 |
| Thread | Author | Time |
|---|---|---|
| Re: [PERFORM] encouraging index-only scans | Bruce Momjian | 03:22 |
| Thread | Author | Time |
|---|---|---|
| Re: PostgreSQL 9.3.2 Performance tuning for 32 GB server | Tom Kincaid | 23:52 |
| Thread | Author | Time |
|---|---|---|
| Re: [PERFORM] encouraging index-only scans | Robert Haas | 16:55 |
| Planner estimates and VACUUM/autovacuum | Artur Zając CFI | 18:57 |
| Planner estimates and VACUUM/autovacuum | Artur Zając | 19:29 |
| Re: Planner estimates and VACUUM/autovacuum | Tom Lane | 21:03 |
| Postgres Query Plan Live Lock | Pweaver (Paul Weaver) | 21:35 |
| Thread | Author | Time |
|---|---|---|
| Re: [PERFORM] encouraging index-only scans | Jeff Janes | 00:14 |
| Re: Re: Increased memory utilization by pgsql backend after upgrade from 9.1.3 to 9.2.6 | Claudio Freire | 01:32 |
| Re: Postgres Query Plan Live Lock | Peter Geoghegan | 02:03 |
| increasing query time after analyze | Katharina Koobs | 11:50 |
| Re: increasing query time after analyze | Pavel Stehule | 12:15 |
| Postgres Query Plan Live Lock | Jeff Janes | 14:52 |
| Re: increasing query time after analyze | Claudio Freire | 15:28 |
| Re: Postgres Query Plan Live Lock | bricklen | 16:39 |
| Re: Postgres Query Plan Live Lock | Pweaver (Paul Weaver) | 19:36 |
| Re: Postgres Query Plan Live Lock | Pweaver (Paul Weaver) | 19:47 |
| Re: [PERFORM] encouraging index-only scans | Robert Haas | 21:19 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgres Query Plan Live Lock | Claudio Freire | 02:42 |
| Thread | Author | Time |
|---|---|---|
| Bloated tables and why is vacuum full the only option | Claudio Freire | 18:47 |
| Thread | Author | Time |
|---|---|---|
| Performance Benchmarking for data-warehousing instance? | Huy Nguyen | 03:36 |
| Re: Performance Benchmarking for data-warehousing instance? | Peter Geoghegan | 04:12 |
| Re: Performance Benchmarking for data-warehousing instance? | Huy Nguyen | 06:41 |
| Re: Performance Benchmarking for data-warehousing instance? | Wattana Hinchaisri | 08:24 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance Benchmarking for data-warehousing instance? | Tomas Vondra | 15:42 |
| Re: Bloated tables and why is vacuum full the only option | Tomas Vondra | 15:50 |
| Re: Bloated tables and why is vacuum full the only option | Claudio Freire | 19:13 |
| Re: Bloated tables and why is vacuum full the only option | Tom Lane | 19:40 |
| Re: Bloated tables and why is vacuum full the only option | Claudio Freire | 19:48 |
| Re: Bloated tables and why is vacuum full the only option | Sergey Konoplev | 22:32 |
| Re: Bloated tables and why is vacuum full the only option | Claudio Freire | 22:58 |
| Re: Bloated tables and why is vacuum full the only option | Sergey Konoplev | 23:29 |
| Thread | Author | Time |
|---|---|---|
| Strange performance boost with random() | M Putz | 19:52 |
| Re: Strange performance boost with random() | Heikki Linnakangas | 20:03 |
| Thread | Author | Time |
|---|---|---|
| increasing query time after analyze | Katharina Koobs | 08:58 |
| Re: increasing query time after analyze | Pavel Stehule | 09:20 |
| Re: list number of entries to be delete in cascading deletes | Eildert Groeneveld | 10:42 |
| Problem with ExclusiveLock on inserts | Бородин Владимир | 16:59 |
| Re: Problem with ExclusiveLock on inserts | Ilya Kosmodemiansky | 17:30 |
| Re: Problem with ExclusiveLock on inserts | Бородин Владимир | 17:43 |
| Re: Problem with ExclusiveLock on inserts | Ilya Kosmodemiansky | 17:56 |
| Re: Problem with ExclusiveLock on inserts | Бородин Владимир | 19:20 |
| Re: Problem with ExclusiveLock on inserts | Ilya Kosmodemiansky | 19:37 |
| Re: Problem with ExclusiveLock on inserts | Бородин Владимир | 19:57 |
| Re: Problem with ExclusiveLock on inserts | Ilya Kosmodemiansky | 20:14 |
| Thread | Author | Time |
|---|---|---|
| Re: Problem with ExclusiveLock on inserts | Бородин Владимир | 08:35 |
| Re: Problem with ExclusiveLock on inserts | Emre Hasegeli | 09:13 |
| Re: Problem with ExclusiveLock on inserts | Бородин Владимир | 09:23 |
| Re: Problem with ExclusiveLock on inserts | Ilya Kosmodemiansky | 09:29 |
| Re: Problem with ExclusiveLock on inserts | Emre Hasegeli | 10:00 |
| Re: Problem with ExclusiveLock on inserts | Бородин Владимир | 10:26 |
| Re: Problem with ExclusiveLock on inserts | Ilya Kosmodemiansky | 12:13 |
| Re: Problem with ExclusiveLock on inserts | Ilya Kosmodemiansky | 12:20 |
| Thread | Author | Time |
|---|---|---|
| Can one Dump schema without index/constraints? | Tory M Blue | 21:06 |
| Thread | Author | Time |
|---|---|---|
| Re: Can one Dump schema without index/constraints? | Michael Paquier | 01:55 |
| Re: Can one Dump schema without index/constraints? | Tory M Blue | 05:40 |
| Thread | Author | Time |
|---|---|---|
| Optimal settings for RAID controller - optimized for writes | Niels Kristian Schjødt | 17:49 |
| Thread | Author | Time |
|---|---|---|
| Optimal settings for RAID controller - optimized for writes | Niels Kristian Schjødt | 15:03 |
| Re: Optimal settings for RAID controller - optimized for writes | DFE | 15:29 |
| Re: Optimal settings for RAID controller - optimized for writes | Tomas Vondra | 15:40 |
| Re: Optimal settings for RAID controller - optimized for writes | Tomas Vondra | 15:54 |
| Why is the optimiser choosing the slower query, or, understanding explain analyze output | Alistair Bayley | 21:54 |
| DB size and TABLE sizes don't seem to add up | David Wall | 22:14 |
| Re: Why is the optimiser choosing the slower query, or, understanding explain analyze output | Jeff Janes | 22:48 |
| Thread | Author | Time |
|---|---|---|
| Re: Optimal settings for RAID controller - optimized for writes | KONDO Mitsumasa | 01:23 |
| Re: Why is the optimiser choosing the slower query, or, understanding explain analyze output | Tom Lane | 01:40 |
| Re: Why is the optimiser choosing the slower query, or, understanding explain analyze output | Alistair Bayley | 02:18 |
| Re: Why is the optimiser choosing the slower query, or, understanding explain analyze output | Tom Lane | 02:30 |
| Re: Optimal settings for RAID controller - optimized for writes | Scott Marlowe | 04:04 |
| Re: DB size and TABLE sizes don't seem to add up | Heikki Linnakangas | 08:34 |
| Re: Optimal settings for RAID controller - optimized for writes | Michael Stone | 14:25 |
| Re: DB size and TABLE sizes don't seem to add up | David Wall | 17:48 |
| Re: Optimal settings for RAID controller - optimized for writes | Tomas Vondra | 20:41 |
| Thread | Author | Time |
|---|---|---|
| Re: Optimal settings for RAID controller - optimized for writes | KONDO Mitsumasa | 02:45 |
| Re: Optimal settings for RAID controller - optimized for writes | Merlin Moncure | 15:13 |
| Re: Optimal settings for RAID controller - optimized for writes | Scott Marlowe | 18:09 |
| Thread | Author | Time |
|---|---|---|
| Re: Optimal settings for RAID controller - optimized for writes | Tomas Vondra | 00:13 |
| Re: Optimal settings for RAID controller - optimized for writes | Merlin Moncure | 00:18 |
| Re: Optimal settings for RAID controller - optimized for writes | Tomas Vondra | 00:26 |
| Re: Optimal settings for RAID controller - optimized for writes | Tomas Vondra | 01:10 |
| Re: Optimal settings for RAID controller - optimized for writes | Scott Marlowe | 01:47 |
| Re: Optimal settings for RAID controller - optimized for writes | KONDO Mitsumasa | 08:29 |
| Re: Optimal settings for RAID controller - optimized for writes | Tomas Vondra | 23:58 |
| Thread | Author | Time |
|---|---|---|
| Postgresql tunning-- help needed | Ashutosh Durugkar | 12:22 |
| Lack of index usage when doing array casts | Alexey Klyukin | 18:01 |
| Re: Lack of index usage when doing array casts | Tom Lane | 19:04 |
| Re: Lack of index usage when doing array casts | Tom Lane | 22:12 |
| Re: Lack of index usage when doing array casts | Alexey Klyukin | 22:37 |
| Re: Lack of index usage when doing array casts | Peter Geoghegan | 22:45 |
| Thread | Author | Time |
|---|---|---|
| 9.1.2 Postgres corruption, any way to recover? | Tory M Blue | 20:42 |
| Re: 9.1.2 Postgres corruption, any way to recover? | Tomas Vondra | 21:57 |
| Thread | Author | Time |
|---|---|---|
| Re: Bloated tables and why is vacuum full the only option | Claudio Freire | 21:43 |
| Thread | Author | Time |
|---|---|---|
| Re: Planner performance extremely affected by an hanging transaction (20-30 times)? | Tom Lane | 16:06 |
| Thread | Author | Time |
|---|---|---|
| Re: Planner performance extremely affected by an hanging transaction (20-30 times)? | Josh Berkus | 00:21 |
| Re: Problem with ExclusiveLock on inserts | Бородин Владимир | 06:32 |
| 9.2.4 specified item offset is too large, now what? | Tory M Blue | 15:17 |
| Query taking long time | acanada | 15:41 |
| Re: Postgresql tunning-- help needed | Tomas Vondra | 23:59 |
| Thread | Author | Time |
|---|---|---|
| Re: Query taking long time | acanada | 10:31 |
| not using my GIN index in JOIN expression | Jean-Max Reymond | 14:06 |
| Re: not using my GIN index in JOIN expression | Heikki Linnakangas | 14:19 |
| Re: not using my GIN index in JOIN expression | Jean-Max Reymond | 14:46 |
| Inefficient filter order in query plan | Tom Coogan | 16:57 |
| Re: Inefficient filter order in query plan | Tom Lane | 17:04 |
| Re: Inefficient filter order in query plan | Stephen Frost | 18:24 |
| Re: Inefficient filter order in query plan | Tom Lane | 19:02 |
| Re: Inefficient filter order in query plan | Tom Coogan | 20:34 |
| Re: Inefficient filter order in query plan | Tom Lane | 20:47 |
| Thread | Author | Time |
|---|---|---|
| Re: Inefficient filter order in query plan | Tom Coogan | 18:29 |
| Help with optimizing a query over hierarchical data | Damon Snyder | 20:01 |
| Thread | Author | Time |
|---|---|---|
| Re: Help with optimizing a query over hierarchical data | Claudio Freire | 01:02 |
| Thread | Author | Time |
|---|---|---|
| Re: Query taking long time | acanada | 10:17 |
| Re: Query taking long time | Vladimir Sitnikov | 17:17 |
| Re: Help with optimizing a query over hierarchical data | Damon Snyder | 17:55 |
| Help me understand why my subselect is an order of magnitude faster than my nested joins | Eli Naeher | 18:24 |
| Subselect an order of magnitude faster than nested joins | Eli Naeher | 18:55 |
| Re: Help with optimizing a query over hierarchical data | Claudio Freire | 21:52 |
| Re: Query taking long time | Venkata Balaji Nagothi | 23:28 |
| Thread | Author | Time |
|---|---|---|
| Re: Help with optimizing a query over hierarchical data | Damon Snyder | 01:12 |
| Re: Help with optimizing a query over hierarchical data | Claudio Freire | 04:20 |
| Re: Query taking long time | acanada | 10:10 |
| Re: Query taking long time | acanada | 11:23 |
| Re: Help with optimizing a query over hierarchical data | Damon Snyder | 17:06 |
| Re: Query taking long time | Venkata Balaji Nagothi | 23:35 |
| Thread | Author | Time |
|---|---|---|
| Re: Optimal settings for RAID controller - optimized for writes | Merlin Moncure | 00:34 |
| Re: Query taking long time | acanada | 10:47 |
| Re: Query taking long time | desmodemone | 13:11 |
| Re: Query taking long time | acanada | 14:45 |
| Thread | Author | Time |
|---|---|---|
| Slow query | Bikram Kesari Naik | 06:05 |
| Re: Slow query | David Johnston | 06:23 |
| Re: Slow query | Bikram Kesari Naik | 06:43 |
| Re: Slow query | David Johnston | 07:18 |
| Re: Query taking long time | Evgeniy Shishkin | 09:39 |
| Re: Query taking long time | acanada | 09:46 |
| Re: Query taking long time | Evgeniy Shishkin | 10:03 |
| Re: Query taking long time | acanada | 10:18 |
| Thread | Author | Time |
|---|---|---|
| How can I get the query planner to use a bitmap index scap instead of an index scan ? | Mohan Krishnan | 02:46 |
| Thread | Author | Time |
|---|---|---|
| Re: How can I get the query planner to use a bitmap index scap instead of an index scan ? | Jeff Janes | 21:46 |
| Thread | Author | Time |
|---|---|---|
| Re: How can I get the query planner to use a bitmap index scap instead of an index scan ? | Mohan Krishnan | 08:14 |
| Re: Query taking long time | Evgeniy Shishkin | 14:45 |
| Re: Query taking long time | acanada | 16:30 |
| Re: Query taking long time | Venkata Balaji Nagothi | 19:49 |
| Re: Query taking long time | desmodemone | 20:22 |
| Thread | Author | Time |
|---|---|---|
| Re: Query taking long time | acanada | 15:56 |
| Ye olde slow query | Murphy, Kevin | 20:02 |
| Re: Ye olde slow query | Tom Lane | 22:23 |
| Re: Query taking long time | Evgeny Shishkin | 23:12 |
| Thread | Author | Time |
|---|---|---|
| Very slow query in PostgreSQL 9.3.3 📎 | fburgess | 19:26 |
| Re: [BUGS] Very slow query in PostgreSQL 9.3.3 | Pavel Stehule | 19:36 |
| Re: [BUGS] Very slow query in PostgreSQL 9.3.3 | Sergey Konoplev | 22:12 |
| Thread | Author | Time |
|---|---|---|
| Re: [PERFORM] Very slow query in PostgreSQL 9.3.3 | Ian Lawrence Barwick | 02:19 |
| Adding new field to big table | acanada | 11:30 |
| Re: Adding new field to big table | Jeff Janes | 16:49 |
| Re: Adding new field to big table | acanada | 17:06 |
| Re: Adding new field to big table | Jeff Janes | 19:29 |
| Thread | Author | Time |
|---|---|---|
| Re: Adding new field to big table | acanada | 09:39 |
| Thread | Author | Time |
|---|---|---|
| Re: Adding new field to big table | Jeff Janes | 06:04 |
| Re: Help me understand why my subselect is an order of magnitude faster than my nested joins | Vincent | 21:20 |
| question about partial index | Yu Zhao | 21:26 |
| Re: question about partial index | Szymon Guz | 21:51 |
| Thread | Author | Time |
|---|---|---|
| Re: Query taking long time | acanada | 11:09 |
| slave wal is ahead of master | Evgeniy Shishkin | 17:10 |
| Re: slave wal is ahead of master | Sethu Prasad | 18:11 |
| Re: slave wal is ahead of master | Evgeny Shishkin | 20:01 |
| Re: Query taking long time | Venkata Balaji Nagothi | 23:30 |
| Thread | Author | Time |
|---|---|---|
| Re: Query taking long time | acanada | 10:17 |
| long lasting select, no io nor cpu usage ? | Franck Routier | 13:51 |
| Re: long lasting select, no io nor cpu usage ? | Tom Lane | 13:56 |
| Re: long lasting select, no io nor cpu usage ? | Franck Routier | 14:07 |
| Re: long lasting select, no io nor cpu usage ? | Tom Lane | 14:15 |
| Re: long lasting select, no io nor cpu usage ? | Franck Routier | 16:27 |
| Getting query plan alternatives from query planner? | Stefan Keller | 16:53 |
| Performance of UNION vs IN | Jean-Max Reymond | 16:57 |
| Re: Getting query plan alternatives from query planner? | Tom Lane | 17:08 |
| Re: Performance of UNION vs IN | Torsten Förtsch | 17:13 |
| slow join not using index properly | Stefan Amshey | 23:56 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance of UNION vs IN | Jean-Max Reymond | 05:33 |
| Re: slow join not using index properly | Ilya Kosmodemiansky | 06:02 |
| Re: Getting query plan alternatives from query planner? | Stefan Keller | 07:37 |