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 |
|---|---|---|
| excessive disk access during query | Toby Sargeant | 03:19 |
| slower with the time | Juraj Porada | 07:47 |
| Re: slower with the time | Shridhar Daithankar | 07:48 |
| Re: slower with the time | Juraj Porada | 08:10 |
| Re: slower with the time | Shridhar Daithankar | 08:17 |
| Version 7 question | Hilary Forbes | 12:10 |
| Re: Version 7 question | Michael Mattox | 12:17 |
| Re: Version 7 question | Robert Treat | 12:52 |
| Re: Version 7 question | scott.marlowe | 12:55 |
| Re: Version 7 question | Michael Mattox | 13:02 |
| FW: Version 7 question | Howard Oblowitz | 13:06 |
| Re: FW: Version 7 question | scott.marlowe | 13:19 |
| Re: excessive disk access during query | Tom Lane | 13:42 |
| Effective Cache Size | Howard Oblowitz | 13:50 |
| Re: Version 7 question | Michael Mattox | 13:55 |
| Re: Effective Cache Size | Shridhar Daithankar | 14:02 |
| Re: Effective Cache Size | scott.marlowe | 14:18 |
| Re: Version 7 question | scott.marlowe | 14:19 |
| Re: Version 7 question | scott.marlowe | 14:22 |
| Re: Version 7 question | Manfred Koizar | 18:01 |
| Re: Effective Cache Size | Manfred Koizar | 18:22 |
| Thread | Author | Time |
|---|---|---|
| Re: Version 7 question | Christopher Kings-Lynne | 01:37 |
| Re: How to optimize monstrous query, sorts instead of | Michael Mattox | 10:24 |
| Re: How to optimize monstrous query, sorts instead of 📎 | Michael Mattox | 10:28 |
| Re: How to optimize monstrous query, sorts instead of | Rod Taylor | 12:45 |
| Re: How to optimize monstrous query, sorts instead of | Rod Taylor | 12:51 |
| Re: How to optimize monstrous query, sorts instead of 📎 | Michael Mattox | 13:46 |
| Thread | Author | Time |
|---|---|---|
| Re: raise or lower transaction timeout? | Paul Thomas | 08:47 |
| Re: How to optimize monstrous query, sorts instead of | Rod Taylor | 12:26 |
| Moving postgresql.conf tunables into 2003... | Sean Chittenden | 19:05 |
| Re: Moving postgresql.conf tunables into 2003... | scott.marlowe | 20:14 |
| Re: Moving postgresql.conf tunables into 2003... | Michael Mattox | 20:17 |
| Re: Moving postgresql.conf tunables into 2003... | Rod Taylor | 20:24 |
| Re: Moving postgresql.conf tunables into 2003... | Ron | 20:28 |
| Re: Moving postgresql.conf tunables into 2003... | Tom Lane | 20:38 |
| Re: Moving postgresql.conf tunables into 2003... | Brian Hirt | 21:33 |
| Re: Moving postgresql.conf tunables into 2003... | Sean Chittenden | 23:23 |
| Re: Moving postgresql.conf tunables into 2003... | Sean Chittenden | 23:25 |
| Re: Moving postgresql.conf tunables into 2003... | Sean Chittenden | 23:32 |
| Thread | Author | Time |
|---|---|---|
| Re: PostgreSQL vs. MySQL | Grega Bremec | 16:39 |
| Re: Strange result: UNIX vs. TCP/IP sockets | Andrew Sullivan | 20:58 |
| Re: Moving postgresql.conf tunables into 2003... | Sean Chittenden | 21:04 |
| Re: Moving postgresql.conf tunables into 2003... | Sean Chittenden | 21:12 |
| Re: Moving postgresql.conf tunables into 2003... | Josh Berkus | 22:58 |
| Re: PostgreSQL vs. MySQL | Hilmar Lapp | 23:40 |
| Thread | Author | Time |
|---|---|---|
| Re: PostgreSQL vs. MySQL | Hannu Krosing | 00:11 |
| Re: Moving postgresql.conf tunables into 2003... | Sean Chittenden | 00:24 |
| Re: Moving postgresql.conf tunables into 2003... | Josh Berkus | 01:27 |
| Extreme high load averages | Martin Foster | 04:54 |
| Re: [PERFORM] Extreme high load averages | Richard Huxton | 07:49 |
| Re: Extreme high load averages | Shridhar Daithankar | 09:44 |
| Re: Extreme high load averages | Martin Foster | 10:26 |
| Re: [PERFORM] Extreme high load averages | Martin Foster | 10:31 |
| Re: Extreme high load averages | Shridhar Daithankar | 10:34 |
| PostgreSQL banner | Cornelia Boenigk | 13:05 |
| Another POC initdb patch 📎 | Shridhar Daithankar | 14:10 |
| Re: [PERFORM] Extreme high load averages | Tom Lane | 15:19 |
| Re: Another POC initdb patch | Tom Lane | 15:25 |
| Re: Extreme high load averages | Martin Foster | 20:16 |
| Re: [PERFORM] Extreme high load averages | Martin Foster | 20:28 |
| Thread | Author | Time |
|---|---|---|
| Re: Extreme high load averages | Matthew Nuzum | 00:47 |
| Re: Extreme high load averages | scott.marlowe | 15:26 |
| Config file problem | Hilary Forbes | 19:46 |
| Re: Strange result: UNIX vs. TCP/IP sockets | Andrew Sullivan | 20:54 |
| Thread | Author | Time |
|---|---|---|
| Efficiency of timestamps | Martin Foster | 00:27 |
| Re: Efficiency of timestamps | Stephan Szabo | 00:55 |
| Re: Config file problem | Christopher Kings-Lynne | 01:13 |
| Re: Efficiency of timestamps | Martin Foster | 01:37 |
| Re: Efficiency of timestamps | Stephan Szabo | 02:49 |
| Re: Efficiency of timestamps | Martin Foster | 04:23 |
| Re: Efficiency of timestamps | Stephan Szabo | 05:01 |
| Re: Efficiency of timestamps | Martin Foster | 06:51 |
| Some very weird behaviour.... | Chris Bowlby | 17:29 |
| Re: Some very weird behaviour.... | Rod Taylor | 17:42 |
| Re: Moving postgresql.conf tunables into 2003... | Kaarel | 18:33 |
| Re: Moving postgresql.conf tunables into 2003... | scott.marlowe | 19:40 |
| Re: Moving postgresql.conf tunables into 2003... | Martin Foster | 21:45 |
| Re: Moving postgresql.conf tunables into 2003... | Sean Chittenden | 23:30 |
| Thread | Author | Time |
|---|---|---|
| Re: Moving postgresql.conf tunables into 2003... | Martin Foster | 00:23 |
| plpgsql vs. SQL performance (again) | Michael Pohl | 01:48 |
| Can you help me? | Chris_Wu | 01:51 |
| Re: [PERFORM] Extreme high load averages | Martin Foster | 05:37 |
| Re: [NOVICE] Extreme high load averages | Shridhar Daithankar | 06:30 |
| Re: [NOVICE] Extreme high load averages | Martin Foster | 06:43 |
| Re: [NOVICE] Extreme high load averages | Shridhar Daithankar | 07:11 |
| Re: Can you help me? | Oliver Scheit | 08:29 |
| Re: substr_count | Michael Pohl | 12:55 |
| Re: Some very weird behaviour.... | Chris Bowlby | 15:09 |
| force the use of a particular index | Scott Cain | 15:18 |
| Dual Xeon + HW RAID question | alexandre arruda paes :: aldeia digital | 17:43 |
| pre-Vacuum statistics | Rich Cullingford | 18:19 |
| Re: [PERFORM] Extreme high load averages | Sean Chittenden | 20:22 |
| Thread | Author | Time |
|---|---|---|
| Re: [NOVICE] Extreme high load averages | Martin Foster | 00:23 |
| Re: [NOVICE] Extreme high load averages | Martin Foster | 06:09 |
| Postgresql General Bits issue | Shridhar Daithankar | 10:32 |
| Re: force the use of a particular index | Rod Taylor | 10:51 |
| Re: Dual Xeon + HW RAID question | Rod Taylor | 10:55 |
| Re: pre-Vacuum statistics | Rod Taylor | 10:57 |
| Re: force the use of a particular index | Scott Cain | 13:17 |
| Re: force the use of a particular index | Rod Taylor | 13:38 |
| Re: force the use of a particular index | Tom Lane | 15:24 |
| Re: force the use of a particular index | Scott Cain | 15:36 |
| Re: force the use of a particular index | Scott Cain | 15:38 |
| Re: force the use of a particular index | Tom Lane | 15:44 |
| Re: force the use of a particular index | Rod Taylor | 16:20 |
| Re: force the use of a particular index | Scott Cain | 17:20 |
| Re: force the use of a particular index | Rod Taylor | 18:14 |
| Re: force the use of a particular index | Scott Cain | 18:23 |
| Thread | Author | Time |
|---|---|---|
| Optimizer Parameters 📎 | Martin Foster | 02:17 |
| Re: Dual Xeon + HW RAID question | Nikolaus Dilger | 18:25 |
| Re: Optimizer Parameters | Tom Lane | 20:46 |
| [OT] Such incredible h/w (was Re: Dual Xeon + HW RAID question) | Ron Johnson | 21:09 |
| Thread | Author | Time |
|---|---|---|
| Re: Optimizer Parameters | Martin Foster | 00:16 |
| Re: [NOVICE] Optimizer Parameters | Tom Lane | 02:14 |