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: [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: [SQL] 7.3 analyze & vacuum analyze problem | Tom Lane | 00:10 |
| Re: [SQL] 7.3 analyze & vacuum analyze problem | Christopher Kings-Lynne | 01:51 |
| Re: profiling plpgsql functions.. | Rajesh Kumar Mallah | 14:59 |
| Thread | Author | Time |
|---|---|---|
| Query Priority | Peter Childs | 12:55 |
| Re: Query Priority | Andrew Sullivan | 14:05 |
| Re: Query Priority | Tom Lane | 14:23 |
| Re: [SQL] 7.3 analyze & vacuum analyze problem | Achilleus Mantzios | 16:29 |
| Looking for a cheap upgrade (RAID) | Chad Thompson | 18:53 |
| Re: [SQL] 7.3 analyze & vacuum analyze problem | Achilleus Mantzios | 19:03 |
| Re: Looking for a cheap upgrade (RAID) | scott.marlowe | 20:04 |
| Re: Looking for a cheap upgrade (RAID) | Josh Berkus | 20:10 |
| Re: Looking for a cheap upgrade (RAID) | Chad Thompson | 20:53 |
| Re: Looking for a cheap upgrade (RAID) | scott.marlowe | 21:20 |
| Re: Looking for a cheap upgrade (RAID) | Josh Berkus | 22:10 |
| Re: Looking for a cheap upgrade (RAID) | scott.marlowe | 22:18 |
| Thread | Author | Time |
|---|---|---|
| Suggestions wanted for 7.2.4 query | Josh Berkus | 02:28 |
| Re: NOT IN doesn't use index? (fwd) | Christopher Kings-Lynne | 04:05 |
| Re: Suggestions wanted for 7.2.4 query | Tom Lane | 04:42 |
| Re: Suggestions wanted for 7.2.4 query | Josh Berkus | 16:07 |
| Re: More tablescanning fun | Jim C. Nasby | 16:22 |
| Re: Suggestions wanted for 7.2.4 query | Tom Lane | 17:23 |
| Re: Suggestions wanted for 7.2.4 query | Josh Berkus | 17:59 |
| Thread | Author | Time |
|---|---|---|
| Indices are not used by the optimizer | Reiner Dassing | 12:16 |
| Wrong index usage in 7.3.2 | Achilleus Mantzios | 12:30 |
| Re: Indices are not used by the optimizer | Rod Taylor | 13:33 |
| Re: looking for large dataset 📎 | scott.marlowe | 16:25 |
| Re: Looking for a cheap upgrade (RAID) | scott.marlowe | 16:31 |
| Re: Looking for a cheap upgrade (RAID) | scott.marlowe | 16:38 |
| Re: Suggestions wanted for 7.2.4 query | Josh Berkus | 17:59 |
| Re: [SQL] Indices are not used by the optimizer | Achilleus Mantzios | 18:38 |
| Hypothetical suggestions for planner, indexing improvement | Josh Berkus | 19:19 |
| Re: Suggestions wanted for 7.2.4 query | Josh Berkus | 19:27 |
| Re: Looking for a cheap upgrade (RAID) | Ron Johnson | 21:54 |
| Re: Looking for a cheap upgrade (RAID) | scott.marlowe | 22:22 |