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: SELECT is slow on smaller table? | Ao Jianwang | 00:30 |
| Processing of subqueries in union | Markus Hervén | 06:32 |
| hardware upgrade, performance degrade? | Steven Crandell | 09:52 |
| Re: hardware upgrade, performance degrade? | Guillaume Smet | 11:13 |
| New server setup | Niels Kristian Schjødt | 11:43 |
| Re: xmlconcat performance | Merlin Moncure | 14:09 |
| Re: New server setup | Craig James | 15:28 |
| Re: hardware upgrade, performance degrade? | Craig James | 15:41 |
| Re: hardware upgrade, performance degrade? | Steven Crandell | 16:49 |
| Re: New server setup | Wales Wang | 17:05 |
| Thread | Author | Time |
|---|---|---|
| Re: hardware upgrade, performance degrade? | Scott Marlowe | 06:51 |
| Re: hardware upgrade, performance degrade? | Jesper Krogh | 07:30 |
| Thread | Author | Time |
|---|---|---|
| Re: hardware upgrade, performance degrade? | Josh Berkus | 20:16 |
| Re: hardware upgrade, performance degrade? | Jean-David Beyer | 20:34 |
| Thread | Author | Time |
|---|---|---|
| Re: hardware upgrade, performance degrade? | Scott Marlowe | 01:48 |
| Re: hardware upgrade, performance degrade? | Steven Crandell | 03:05 |
| Optimize SELECT * from table WHERE foreign_key_id IN (key1, key2, key3, key4...) | Niels Kristian Schjødt | 14:00 |
| Re: Poor performance after update from SLES11 SP1 to SP2 | Mark Smith | 14:13 |
| Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...) | Julien Cigar | 14:26 |
| Re: New server setup | Kevin Grittner | 16:34 |
| Re: New server setup | Scott Marlowe | 17:10 |
| Re: New server setup | Niels Kristian Schjødt | 17:11 |
| Re: Are bitmap index scans slow to start? | Jeff Janes | 17:46 |
| Re: New server setup | Benjamin Krajmalnik | 18:03 |
| Re: New server setup | Niels Kristian Schjødt | 18:27 |
| sniff test on some PG 8.4 numbers | Jon Nelson | 19:35 |
| Re: Are bitmap index scans slow to start? | Jeff Janes | 21:20 |
| Re: New server setup | Jeff Janes | 21:59 |
| Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1, key2, key3, key4...) | Niels Kristian Schjødt | 23:51 |
| Thread | Author | Time |
|---|---|---|
| Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...) | Joshua D. Drake | 00:07 |
| Re: sniff test on some PG 8.4 numbers | Josh Berkus | 01:02 |
| Re: sniff test on some PG 8.4 numbers | Jon Nelson | 02:13 |
| Re: sniff test on some PG 8.4 numbers | Jon Nelson | 03:00 |
| Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1,key2,key3,key4...) | Julien Cigar | 12:33 |
| Poor plan when joining against a union containing a join | David Leverton | 14:54 |
| Re: Optimize SELECT * from table WHERE foreign_key_id IN (key1, key2, key3, key4...) | Jeff Janes | 16:44 |
| Re: Poor plan when joining against a union containing a join | Josh Berkus | 23:15 |
| Thread | Author | Time |
|---|---|---|
| Re: Poor plan when joining against a union containing a join | Tom Lane | 05:52 |
| Re: Poor plan when joining against a union containing a join | David Leverton | 18:21 |
| Re: Poor plan when joining against a union containing a join | Tom Lane | 18:47 |
| Thread | Author | Time |
|---|---|---|
| Anyone running Intel S3700 SSDs? | CSS | 06:48 |
| Re: Anyone running Intel S3700 SSDs? | Yeb Havinga | 08:51 |
| PostgreSQL 9.2.3 performance problem caused Exclusive locks | Emre Hasegeli | 11:27 |
| Re: Poor plan when joining against a union containing a join | David Leverton | 13:49 |
| Re: PostgreSQL 9.2.3 performance problem caused Exclusive locks | Emre Hasegeli | 19:56 |
| Re: Are bitmap index scans slow to start? | Carlo Stonebanks | 21:27 |
| Thread | Author | Time |
|---|---|---|
| Re: New server setup | Gregg Jaskiewicz | 17:53 |
| Thread | Author | Time |
|---|---|---|
| Re: sniff test on some PG 8.4 numbers | Greg Smith | 15:46 |
| Re: New server setup | Greg Smith | 15:58 |
| Thread | Author | Time |
|---|---|---|
| Re: sniff test on some PG 8.4 numbers | Jon Nelson | 01:18 |
| Re: sniff test on some PG 8.4 numbers | Scott Marlowe | 03:02 |
| Re: sniff test on some PG 8.4 numbers | Greg Smith | 04:28 |
| Large Table - Slow Window Functions (Better Approach?) | Jeff Adams - NOAA Affiliate | 14:27 |
| Re: sniff test on some PG 8.4 numbers | Jon Nelson | 14:47 |
| Re: Large Table - Slow Window Functions (Better Approach?) | Pavel Stehule | 15:03 |
| Re: Large Table - Slow Window Functions (Better Approach?) | Jeff Adams - NOAA Affiliate | 15:20 |
| Re: Large Table - Slow Window Functions (Better Approach?) | Pavel Stehule | 15:34 |
| Re: Large Table - Slow Window Functions (Better Approach?) | Jeff Adams - NOAA Affiliate | 15:48 |
| The dreaded semwait on FreeBSD | Benjamin Krajmalnik | 15:53 |
| Slow query when used in a view | Shaun Thomas | 22:29 |
| Re: Slow query when used in a view | Tom Lane | 23:56 |
| Thread | Author | Time |
|---|---|---|
| Slow concurrent processing | Misa Simic | 03:55 |
| Re: Large Table - Slow Window Functions (Better Approach?) | Jeff Adams - NOAA Affiliate | 13:08 |
| Re: Large Table - Slow Window Functions (Better Approach?) | Victor Yegorov | 13:36 |
| Re: Slow query when used in a view | Shaun Thomas | 13:49 |
| Re: Slow concurrent processing | Misa Simic | 14:13 |
| Re: Slow concurrent processing | Steve Crawford | 14:20 |
| Re: Slow concurrent processing | Misa Simic | 15:06 |
| Re: Slow concurrent processing | Steve Crawford | 15:54 |
| Re: Slow concurrent processing | Jeff Janes | 17:09 |
| Re: Slow concurrent processing | Misa Simic | 17:11 |
| Re: Slow concurrent processing | Misa Simic | 17:16 |
| Re: PostgreSQL 9.2.3 performance problem caused Exclusive locks | Emre Hasegeli | 19:17 |
| Re: New server setup | Gregg Jaskiewicz | 21:41 |
| Thread | Author | Time |
|---|---|---|
| Re: New server setup | Mark Kirkwood | 03:29 |
| Re: New server setup | David Boreham | 03:39 |
| PostgreSQL 9.2.3 performance problem caused Exclusive locks | Jeff Janes | 04:53 |
| Re: PostgreSQL 9.2.3 performance problem caused Exclusive locks | Emre Hasegeli | 17:07 |
| Re: New server setup | Bruce Momjian | 18:54 |
| Speed of EXCECUTE in PL/PGSQL | Artur Zając | 19:22 |
| Re: Speed of EXCECUTE in PL/PGSQL | Merlin Moncure | 19:36 |
| Re: Speed of EXCECUTE in PL/PGSQL | Andrew Dunstan | 19:39 |
| Re: New server setup | Mark Kirkwood | 21:37 |
| Re: New server setup | Mark Kirkwood | 21:47 |
| Re: New server setup | Bruce Momjian | 22:34 |
| Re: New server setup | Mark Kirkwood | 22:53 |
| Re: New server setup | David Boreham | 23:37 |
| Thread | Author | Time |
|---|---|---|
| Join the master table with other table is very slow (partitioning) | Ao Jianwang | 15:02 |
| Re: Join the master table with other table is very slow (partitioning) | Ao Jianwang | 15:09 |
| Re: Join the master table with other table is very slow (partitioning) | AI Rumman | 15:12 |
| Re: Join the master table with other table is very slow (partitioning) | Ao Jianwang | 15:17 |
| Re: Join the master table with other table is very slow (partitioning) | Ao Jianwang | 15:39 |
| Re: Join the master table with other table is very slow (partitioning) | Tom Lane | 15:42 |
| Re: Join the master table with other table is very slow (partitioning) | Ao Jianwang | 16:04 |
| Pre-sorting COPY FROM input | Florian Weimer | 17:31 |
| Re: New server setup | Rick Otten | 18:06 |
| Re: Pre-sorting COPY FROM input | Heikki Linnakangas | 18:26 |
| Re: New server setup | Bruce Momjian | 18:55 |
| Re: New server setup | Scott Marlowe | 19:14 |
| Thread | Author | Time |
|---|---|---|
| Re: New server setup | Mark Kirkwood | 08:47 |
| Thread | Author | Time |
|---|---|---|
| Index usage for tstzrange? | Josh Berkus | 00:12 |
| Re: New server setup | David Rees | 00:44 |
| Re: New server setup | David Boreham | 01:04 |
| Re: New server setup | Karl Denninger | 01:46 |
| Re: New server setup | Scott Marlowe | 01:56 |
| Re: New server setup | Mark Kirkwood | 02:26 |
| Re: Index usage for tstzrange? | Tom Lane | 03:58 |
| Re: Index usage for tstzrange? | Vasilis Ventirozos | 04:07 |
| Re: Index usage for tstzrange? 📎 | Heikki Linnakangas | 08:52 |
| Thread | Author | Time |
|---|---|---|
| Re: Index usage for tstzrange? | Josh Berkus | 00:05 |
| Performance of query | Cindy Makarowsky | 19:46 |
| Re: Performance of query | Josh Berkus | 21:13 |
| Re: Index usage for tstzrange? 📎 | Heikki Linnakangas | 21:53 |
| Re: Performance of query | Cindy Makarowsky | 22:20 |
| Re: Performance of query | Misa Simic | 22:25 |
| Re: Performance of query | Cindy Makarowsky | 22:26 |
| Re: Index usage for tstzrange? 📎 | Heikki Linnakangas | 22:53 |
| Thread | Author | Time |
|---|---|---|
| Re: Index usage for tstzrange? | Josh Berkus | 01:23 |
| Re: Index usage for tstzrange? | Tom Lane | 04:31 |
| Re: Performance of query | Jeff Janes | 21:53 |
| Re: Performance of query | Misa Simic | 22:27 |
| Thread | Author | Time |
|---|---|---|
| PostgreSQL planner | Misa Simic | 00:12 |
| Re: Performance of query | Roman Konoval | 06:45 |
| Thread | Author | Time |
|---|---|---|
| 9.2.3 upgrade reduced pgbench performance by 60% | Colin Currie | 09:57 |
| query plan estimate | pg noob | 18:16 |
| Re: Performance of query | Jeff Janes | 18:18 |
| Re: Performance of query | Cindy Makarowsky | 18:55 |
| Proof of concept: Evolving postgresql.conf using genetic algorithm | Greg Jaskiewicz | 20:08 |
| Setting vacuum_freeze_min_age really low | Josh Berkus | 20:31 |
| Re: 9.2.3 upgrade reduced pgbench performance by 60% | Josh Berkus | 20:34 |
| Thread | Author | Time |
|---|---|---|
| [OT] linux 3.10 kernel will improve ipc,sysv semaphore scalability | Andrea Suisani | 13:04 |
| Re: [OT] linux 3.10 kernel will improve ipc,sysv semaphore scalability | Shaun Thomas | 18:59 |
| Re: 9.2.3 upgrade reduced pgbench performance by 60% | Nicholson, Brad (Toronto, ON, CA) | 20:05 |
| Thread | Author | Time |
|---|---|---|
| Reg: Slow query | Prakash Chinnakannan | 14:04 |
| Re: Reg: Slow query | Vasilis Ventirozos | 14:15 |
| Re: 9.2.3 upgrade reduced pgbench performance by 60% | Josh Berkus | 22:52 |
| Thread | Author | Time |
|---|---|---|
| how to help the planner | Marty Frasier | 15:59 |
| Re: how to help the planner | Tom Lane | 16:18 |
| Question about postmaster's CPU usage | kelphet xiong | 19:07 |
| Re: how to help the planner | Marty Frasier | 20:45 |
| Re: Question about postmaster's CPU usage | Kevin Grittner | 21:03 |
| Re: Question about postmaster's CPU usage | [email protected] | 21:20 |
| Re: how to help the planner | Stephen Frost | 22:13 |
| Thread | Author | Time |
|---|---|---|
| Postgresql performance degrading... how to diagnose the root cause | Franck Routier | 14:20 |
| Re: Postgresql performance degrading... how to diagnose the root cause | Julien Cigar | 14:42 |
| Re: Postgresql performance degrading... how to diagnose the root cause | Guillaume Cottenceau | 14:50 |