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 |
|---|---|---|
| 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 |
| Re: [SQL] Yet Another (Simple) Case of Index not used | Andreas Pflug | 15:37 |
| Re: [PERFORM] Foreign key performance 📎 | Stephan Szabo | 16:04 |
| Re: [SQL] Yet Another (Simple) Case of Index not used | Andrew Sullivan | 16:46 |
| Re: [PERFORM] Foreign key performance | Tom Lane | 17:09 |
| problems | Ian Knopke | 18:09 |
| Re: problems | Tom Lane | 18:36 |
| Thread | Author | Time |
|---|---|---|
| Re: [PERFORM] Foreign key performance | Kevin Brown | 00:09 |
| Re: [PERFORM] Foreign key performance | Tom Lane | 00:35 |
| Re: [SQL] Yet Another (Simple) Case of Index not used | Kevin Brown | 00:46 |
| Re: [SQL] Yet Another (Simple) Case of Index not used | Tom Lane | 01:53 |
| Re: [SQL] Yet Another (Simple) Case of Index not used | Josh Berkus | 16:14 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Yet Another (Simple) Case of Index not used | Jim C. Nasby | 08:23 |
| Re: choosing the right platform | Jim C. Nasby | 08:30 |
| Re: [SQL] Yet Another (Simple) Case of Index not used | Christopher Kings-Lynne | 08:33 |
| Re: [PERFORM] Foreign key performance | Kevin Brown | 11:44 |
| Re: the RAID question, again | Vincent van Leeuwen | 12:11 |
| Re: the RAID question, again | Josh Berkus | 17:18 |
| Re: the RAID question, again | scott.marlowe | 17:29 |
| Re: the RAID question, again | Will LaShell | 17:44 |
| Thread | Author | Time |
|---|---|---|
| Re: [SQL] Yet Another (Simple) Case of Index not used | Greg Stark | 16:32 |
| Important speed difference between a query and a function with the same query | Frederic Jolliton | 17:53 |
| Thread | Author | Time |
|---|---|---|
| Re: Important speed difference between a query and a | Frederic Jolliton | 15:47 |
| Re: Important speed difference between a query and a | Tom Lane | 15:56 |
| Re: Important speed difference between a query and a | Stephan Szabo | 15:57 |
| Re: Important speed difference between a query and a | Frederic Jolliton | 16:33 |
| Re: Important speed difference between a query and a | Frederic Jolliton | 16:41 |
| Re: Important speed difference between a query and a | Stephan Szabo | 17:28 |
| Re: Important speed difference between a query and a | Frederic Jolliton | 17:40 |
| More tablescanning fun | Jim C. Nasby | 23:38 |
| Re: More tablescanning fun | Tom Lane | 23:58 |
| Thread | Author | Time |
|---|---|---|
| Re: More tablescanning fun | Jim C. Nasby | 04:59 |
| Re: More tablescanning fun | Tom Lane | 05:23 |
| Re: Important speed difference between a query and a | Hannu Krosing | 07:01 |
| Re: More tablescanning fun | Jim C. Nasby | 14:38 |
| Re: Important speed difference between a query and a function with the same query | Jim C. Nasby | 15:09 |
| Re: More tablescanning fun | Hannu Krosing | 16:28 |
| Re: More tablescanning fun | Jim C. Nasby | 16:56 |
| Re: [PERFORM] Foreign key performance | Jan Wieck | 19:52 |
| Re: More tablescanning fun | Tom Lane | 20:10 |
| Indexes with different datatypes 📎 | Cecilia Alvarez | 22:33 |
| Indexes with different datatypes:Correction 📎 | Cecilia Alvarez | 22:36 |
| Re: Indexes with different datatypes:Correction | scott.marlowe | 22:40 |
| Thread | Author | Time |
|---|---|---|
| Automatic analyze on select into | Jim C. Nasby | 15:15 |
| Re: Automatic analyze on select into | Tom Lane | 16:18 |
| Re: Automatic analyze on select into | Jim C. Nasby | 18:16 |
| Re: Automatic analyze on select into | Tom Lane | 18:40 |
| Thread | Author | Time |
|---|---|---|
| Re: More tablescanning fun | Hannu Krosing | 06:50 |
| Thread | Author | Time |
|---|---|---|
| pgsql BLOB issues | Jeremy Andrus | 02:30 |
| Re: pgsql BLOB issues | Tom Lane | 05:00 |
| Re: pgsql BLOB issues | Jeremy Andrus | 05:33 |
| Re: pgsql BLOB issues | Christopher Kings-Lynne | 08:19 |
| Diferent execution plan for similar query | jgimenez | 10:26 |
| Re: Diferent execution plan for similar query | Shridhar Daithankar | 10:41 |
| Re: Diferent execution plan for similar query | Magnus Naeslund(w) | 10:59 |
| Re: Diferent execution plan for similar query | Magnus Naeslund(w) | 11:00 |
| Re: [PERFORM] Diferent execution plan for similar query | Shridhar Daithankar | 11:00 |
| Re: Diferent execution plan for similar query | Andrew Sullivan | 11:12 |
| How to get the optimizer to use an index with multiple fields | Jim C. Nasby | 18:21 |
| Re: How to get the optimizer to use an index with multiple fields | Jim C. Nasby | 18:32 |
| Re: How to get the optimizer to use an index with multiple | scott.marlowe | 19:52 |
| Re: How to get the optimizer to use an index with multiple | Jim C. Nasby | 22:54 |
| Thread | Author | Time |
|---|---|---|
| Re: [HACKERS] Changing the default configuration | Matthew T. O'Connor | 04:41 |
| Is 292 inserts/sec acceptable performance ? | Rajesh Kumar Mallah | 07:01 |
| Re: Is 292 inserts/sec acceptable performance ? | Shridhar Daithankar | 07:25 |
| Optimizer not using index when it should | Rob Messer | 09:03 |
| Re: Is 292 inserts/sec acceptable performance ? | Rajesh Kumar Mallah | 11:12 |
| profiling plpgsql functions.. | Rajesh Kumar Mallah | 11:25 |
| Query Plan far worse in 7.3.2 than 7.2.1 | SZŰCS Gábor | 13:01 |
| Re: Optimizer not using index when it should | Rod Taylor | 13:04 |
| Best ODBC cursor and lock types for fastest reading? | Robert John Shepherd | 13:53 |
| Re: Is 292 inserts/sec acceptable performance ? | Tom Lane | 14:00 |
| Re: Optimizer not using index when it should | Tom Lane | 14:18 |
| Re: profiling plpgsql functions.. | Tom Lane | 14:27 |
| Re: Query Plan far worse in 7.3.2 than 7.2.1 | Tom Lane | 14:53 |
| Re: Best ODBC cursor and lock types for fastest reading? | Josh Berkus | 15:38 |