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: 30-70 seconds query... | alexandre :: aldeia digital | 12:23 |
| Re: ext3 filesystem / linux 7.3 | Jeffrey D. Brower | 17:33 |
| Re: ext3 filesystem / linux 7.3 | Shankar K | 17:39 |
| Re: ext3 filesystem / linux 7.3 | eric soroos | 17:53 |
| Re: ext3 filesystem / linux 7.3 | Bruce Momjian | 17:54 |
| Re: ext3 filesystem / linux 7.3 | Andrew Sullivan | 17:55 |
| Re: ext3 filesystem / linux 7.3 | Bruce Momjian | 18:26 |
| Postgresql performance on Solaris | Scott Buchan | 19:31 |
| Re: Postgresql performance on Solaris | Tom Lane | 20:21 |
| Re: ext3 filesystem / linux 7.3 | Jeffrey D. Brower | 20:42 |
| Re: ext3 filesystem / linux 7.3 | Keith Bottner | 20:43 |
| Re: Postgresql performance on Solaris | scott.marlowe | 21:42 |
| Thread | Author | Time |
|---|---|---|
| Re: ext3 filesystem / linux 7.3 | Christopher Kings-Lynne | 01:33 |
| Re: ext3 filesystem / linux 7.3 | Sean Chittenden | 01:49 |
| Re: ext3 filesystem / linux 7.3 | Shridhar Daithankar | 04:12 |
| Re: ext3 filesystem / linux 7.3 | Andreas Kostyrka | 15:13 |
| Re: ext3 filesystem / linux 7.3 | Andreas Kostyrka | 15:18 |
| Re: ext3 filesystem / linux 7.3 | Jeffrey D. Brower | 15:37 |
| Re: ext3 filesystem / linux 7.3 | Andreas Kostyrka | 15:47 |
| Re: ext3 filesystem / linux 7.3 | Andrew Sullivan | 15:56 |
| Re: ext3 filesystem / linux 7.3 | Andreas Pflug | 16:45 |
| Re: ext3 filesystem / linux 7.3 | Jeffrey D. Brower | 17:07 |
| Re: ext3 filesystem / linux 7.3 | Josh Berkus | 20:05 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] can i make this sql query more efficiant? | Manfred Koizar | 02:08 |
| Thread | Author | Time |
|---|---|---|
| Load times on RAID0 compared to RAID5 | Howard Oblowitz | 14:23 |
| Re: [BUGS] Rapid deteriation of performance (might be caused by tsearch?) in 7.3.2 | Robert John Shepherd | 14:25 |
| Re: Load times on RAID0 compared to RAID5 | Andrew Sullivan | 14:36 |
| Re: Load times on RAID0 compared to RAID5 | scott.marlowe | 15:29 |
| Re: Load times on RAID0 compared to RAID5 | Josh Berkus | 15:31 |
| Re: ext3 filesystem / linux 7.3 | Robert Treat | 17:17 |
| Thread | Author | Time |
|---|---|---|
| help need it | rute solipa | 14:58 |
| Re: help need it | Stephan Szabo | 15:16 |
| Re: help need it | Achilleus Mantzios | 19:40 |
| Yet Another (Simple) Case of Index not used | Denis | 19:57 |
| Re: Yet Another (Simple) Case of Index not used | Dennis Gearon | 20:25 |
| Re: Yet Another (Simple) Case of Index not used | Dann Corbit | 20:26 |
| Re: Yet Another (Simple) Case of Index not used | Dennis Gearon | 20:43 |
| Re: [SQL] Yet Another (Simple) Case of Index not used | Josh Berkus | 21:52 |
| Re: ext3 filesystem / linux 7.3 | Kevin Brown | 23:22 |
| Re: Yet Another (Simple) Case of Index not used | Martijn van Oosterhout | 23:46 |
| Thread | Author | Time |
|---|---|---|
| Re: Help analyzing 7.2.4 EXPLAIN | Josh Berkus | 00:13 |
| Re: Caching (was Re: choosing the right platform) | scott.marlowe | 15:14 |
| Re: Caching (was Re: choosing the right platform) | Josh Berkus | 16:15 |
| Re: Caching (was Re: choosing the right platform) | Ron Mayer | 17:25 |
| Thread | Author | Time |
|---|---|---|
| update query blows out | shane hill | 17:14 |
| Re: update query blows out | Tom Lane | 17:16 |
| Re: update query blows out 📎 | shane hill | 18:14 |
| Re: update query blows out | Tom Lane | 20:53 |
| Thread | Author | Time |
|---|---|---|
| Multicolumn indexes and equal conditions | Bruno Wolff III | 01:45 |
| Thread | Author | Time |
|---|---|---|
| for help! | linweidong | 09:44 |
| Re: for help! | Shridhar Daithankar | 09:54 |
| Re: [PERFORM] Yet Another (Simple) Case of Index not used | Bruce Momjian | 14:23 |
| Re: for help! | Will LaShell | 15:40 |
| Do Views offer any performance advantage? | Robert John Shepherd | 15:49 |
| Re: [PERFORM] Yet Another (Simple) Case of Index not used | Richard Huxton | 16:29 |
| Re: for help! | scott.marlowe | 16:34 |
| Re: Do Views offer any performance advantage? | Tom Lane | 17:26 |
| Using indexes for like foo% type queries when foo isn't constant (not a locale issue) | Greg Stark | 19:04 |
| Re: Do Views offer any performance advantage? | Andreas Pflug | 19:55 |
| Re: Do Views offer any performance advantage? | Tom Lane | 23:37 |
| Thread | Author | Time |
|---|---|---|
| Is there a performance between Inherits and Views? | dex | 06:10 |
| dum query plan | Jonathan Moore | 06:58 |
| Re: Do Views offer any performance advantage? | Andreas Pflug | 08:45 |
| Re: for help! | Josh Berkus | 15:48 |
| Re: for help! | Andrew Sullivan | 15:53 |
| Re: for help! | Tom Lane | 16:01 |
| Re: for help! | Andrew Sullivan | 16:11 |
| the RAID question, again | Vincent van Leeuwen | 16:26 |
| dum query plan: more info. | Jonathan Moore | 22:02 |
| Thread | Author | Time |
|---|---|---|
| Re: dum query plan | Stephan Szabo | 01:21 |
| Re: the RAID question, again | Nikolaus Dilger | 02:32 |
| Re: dum query plan | Tom Lane | 03:15 |
| Re: the RAID question, again | Josh Berkus | 03:20 |
| Re: dum query plan | Jean-Luc Lachance | 14:12 |
| Re: dum query plan: more info. | Manfred Koizar | 16:24 |
| Re: dum query plan: more info. | Tom Lane | 16:31 |
| Performance of Inherits versus Views | dex | 17:48 |
| Query speed problems | Victor Danilchenko | 19:17 |
| Re: Query speed problems | Victor Danilchenko | 19:38 |
| Re: Query speed problems | Stephan Szabo | 19:55 |
| Re: Query speed problems | Peter Darley | 19:59 |
| Re: Query speed problems | Victor Danilchenko | 20:24 |
| Re: Query speed problems | Victor Danilchenko | 20:29 |
| Re: Query speed problems | Stephan Szabo | 21:08 |
| Thread | Author | Time |
|---|---|---|
| Re: Query speed problems | Nikolaus Dilger | 01:26 |
| Foreign key performance | Kevin Brown | 05:11 |
| Re: [PERFORM] Foreign key performance | Stephan Szabo | 05:30 |
| Re: [PERFORM] Foreign key performance | Tom Lane | 06:06 |
| Re: [PERFORM] Foreign key performance | Stephan Szabo | 06:25 |
| Re: [PERFORM] Foreign key performance | Stephan Szabo | 14:47 |
| Re: [PERFORM] Foreign key performance | Tom Lane | 14:51 |
| Re: Query speed problems | Victor Danilchenko | 15:01 |
| Re: [PERFORM] Foreign key performance | Stephan Szabo | 15:12 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Yet Another (Simple) Case of Index not used | Kevin Brown | 13:01 |
| Re: [SQL] Yet Another (Simple) Case of Index not used | Tom Lane | 15:58 |
| Re: [PERFORM] Foreign key performance 📎 | Stephan Szabo | 19:03 |
| Re: [SQL] Yet Another (Simple) Case of Index not used | Josh Berkus | 19:03 |
| Re: [SQL] Yet Another (Simple) Case of Index not used | Tom Lane | 20:26 |
| Re: [PERFORM] Foreign key performance | Tom Lane | 20:58 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Yet Another (Simple) Case of Index not used | Kevin Brown | 01:13 |
| Re: [SQL] Yet Another (Simple) Case of Index not used | Tom Lane | 03:34 |
| Re: [SQL] Yet Another (Simple) Case of Index not used | Kevin Brown | 06:28 |
| Re: [PERFORM] Foreign key performance | Stephan Szabo | 06:56 |
| Re: [SQL] Yet Another (Simple) Case of Index not used | Andreas Pflug | 10:07 |
| Re: [SQL] Yet Another (Simple) Case of Index not used | Tom Lane | 15:21 |
| Re: [SQL] Yet Another (Simple) Case of Index not used | Tom Lane | 15:25 |