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 |
|---|---|---|
| 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 |
| Thread | Author | Time |
|---|---|---|
| Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance problem. | Tom Lane | 04:13 |
| Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance problem. | Sean Chittenden | 04:57 |
| Re: An unresolved performance problem. | Andrew Sullivan | 11:20 |
| Re: [SQL] An unresolved performance problem. | Achilleus Mantzios | 12:09 |
| Re: An unresolved performance problem. | Achilleus Mantzios | 12:48 |
| Re: An unresolved performance problem. | Tom Lane | 14:42 |
| Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance problem. | johnnnnnn | 14:47 |
| Type casting and indexes | David Olbersen | 15:36 |
| Re: Type casting and indexes | Stephan Szabo | 16:13 |
| Re: [PERFORM] [SQL] Unanswered Questions WAS: An unresolved performance | scott.marlowe | 16:20 |
| Re: Type casting and indexes | Tom Lane | 16:25 |
| Re: Type casting and indexes | Tom Lane | 22:35 |
| Thread | Author | Time |
|---|---|---|
| Re: An unresolved performance problem. | Tom Lane | 12:31 |
| Re: An unresolved performance problem. | Achilleus Mantzios | 13:00 |
| Re: An unresolved performance problem. | Tom Lane | 13:08 |
| Re: An unresolved performance problem. | Tom Lane | 13:30 |
| Re: An unresolved performance problem. | Achilleus Mantzios | 18:11 |
| Re: An unresolved performance problem. | Achilleus Mantzios | 18:22 |
| Re: An unresolved performance problem. | Achilleus Mantzios | 19:13 |
| Re: An unresolved performance problem. | Achilleus Mantzios | 19:25 |
| Thread | Author | Time |
|---|---|---|
| realtime data inserts | Adam Siegel | 15:25 |
| Re: realtime data inserts | Tom Lane | 16:00 |
| Re: realtime data inserts | Ericson Smith | 16:02 |
| Re: realtime data inserts | Jim C. Nasby | 17:08 |
| Re: realtime data inserts | Ron Johnson | 18:31 |
| Thread | Author | Time |
|---|---|---|
| Re: realtime data inserts | Tom Lane | 02:46 |
| Yet another question about not use on indexes | Xevi Serrats | 13:16 |
| Re: Yet another question about not use on indexes | Richard Huxton | 14:08 |
| Re: Yet another question about not use on indexes | Tom Lane | 14:15 |
| Re: realtime data inserts | Ron Johnson | 16:54 |
| Re: realtime data inserts | Doug McNaught | 16:58 |
| Thread | Author | Time |
|---|---|---|
| Re: Hack around lack of CORRESPONDING BY in EXCEPT? | Lucas Adamski | 07:29 |
| Re: realtime data inserts | Adam Siegel | 14:51 |
| Re: PERFORMANCE and SIZE | Josh Berkus | 15:49 |
| Re: realtime data inserts | Steve Crawford | 15:56 |
| Re: How are null's stored? | Ryan | 18:58 |
| How are null's stored? | Jim C. Nasby | 19:01 |