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: 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 |
| PERFORMANCE and SIZE | Alfranio Junior | 19:35 |
| Re: How are null's stored? | Josh Berkus | 20:44 |
| Re: How are null's stored? | Andrew Sullivan | 21:04 |
| Re: How are null's stored? | Josh Berkus | 22:46 |
| Re: How are null's stored? | Stephan Szabo | 23:19 |
| Re: How are null's stored? | Tom Lane | 23:50 |
| partial index / funxtional idx or bad sql? | csajl | 23:51 |
| Thread | Author | Time |
|---|---|---|
| Re: Finding filenames for tables | Jamie Lawrence | 00:11 |
| constraint with reference to the same table | Victor Yegorov | 23:11 |
| Re: constraint with reference to the same table | Stephan Szabo | 23:28 |
| Re: constraint with reference to the same table | Rudi Starcevic | 23:57 |
| Thread | Author | Time |
|---|---|---|
| Re: realtime data inserts | alex b. | 20:27 |
| Re: realtime data inserts | Ericson Smith | 20:33 |
| Re: realtime data inserts | Ron Johnson | 22:29 |
| Thread | Author | Time |
|---|---|---|
| postgres on a beowulf? (AMD)opteron? | george young | 17:28 |
| Thread | Author | Time |
|---|---|---|
| Re: postgres on a beowulf? (AMD)opteron? | Shridhar Daithankar | 06:44 |
| Re: nested select query failing | amol | 07:26 |
| Re: postgres on a beowulf? (AMD)opteron? | Hannu Krosing | 08:29 |
| Re: postgres on a beowulf? (AMD)opteron? | Andrew Sullivan | 11:27 |
| 7.3.2 vs 7.1.2 | Eugene Fokin | 12:28 |
| Re: 7.3.2 vs 7.1.2 | Rod Taylor | 13:08 |
| Re: 7.3.2 vs 7.1.2 | Victor Yegorov | 13:09 |
| Re: 7.3.2 vs 7.1.2 | Eugene Fokin | 13:28 |
| Re: 7.3.2 vs 7.1.2 | Victor Yegorov | 14:07 |
| Re: nested select query failing | Tom Lane | 15:18 |
| Re: 7.3.2 vs 7.1.2 | Eugene Fokin | 15:33 |
| Re: postgres on a beowulf? (AMD)opteron? | scott.marlowe | 15:37 |
| Re: 7.3.2 vs 7.1.2 | Victor Yegorov | 15:58 |
| Re: 7.3.2 vs 7.1.2 | Josh Berkus | 16:30 |
| Re: 7.3.2 vs 7.1.2 -- Ooops | Josh Berkus | 16:31 |
| Re: 7.3.2 vs 7.1.2 | Josh Berkus | 16:35 |
| Re: 7.3.2 vs 7.1.2 | Tom Lane | 16:40 |
| Re: 7.3.2 vs 7.1.2 | Tom Lane | 17:33 |
| Thread | Author | Time |
|---|---|---|
| Re: 7.3.2 vs 7.1.2 | Eugene Fokin | 07:08 |
| Re: 7.3.2 vs 7.1.2 | Eugene Fokin | 07:11 |
| Re: 7.3.2 vs 7.1.2 | Eugene Fokin | 07:19 |
| Re: nested select query failing | amol | 10:16 |
| Re: postgres on a beowulf? (AMD)opteron? | Ron Johnson | 14:54 |
| Re: postgres on a beowulf? (AMD)opteron? | scott.marlowe | 15:45 |
| Thread | Author | Time |
|---|---|---|
| ugly query slower in 7.3, even slower after vacuum full analyze 📎 | SZŰCS Gábor | 14:25 |
| Re: ugly query slower in 7.3, even slower after vacuum full analyze | Tom Lane | 16:02 |
| Re: ugly query slower in 7.3, even slower after vacuum full analyze | Josh Berkus | 16:31 |
| Re: ugly query slower in 7.3, even slower after vacuum full analyze | SZŰCS Gábor | 16:32 |
| Q: Structured index - which one runs faster? | Ernest E Vogelsinger | 20:41 |
| Re: postgres on a beowulf? (AMD)opteron? | Bruce Momjian | 21:23 |
| Re: [GENERAL] Q: Structured index - which one runs faster? | scott.marlowe | 22:23 |
| Re: Q: Structured index - which one runs faster? | Tom Lane | 22:53 |
| Re: [ADMIN] Q: Structured index - which one runs faster? | Stephan Szabo | 23:00 |
| Re: [ADMIN] Q: Structured index - which one runs faster? | Ernest E Vogelsinger | 23:36 |
| Re: Q: Structured index - which one runs faster? | Ernest E Vogelsinger | 23:43 |
| Thread | Author | Time |
|---|---|---|
| Re: Q: Structured index - which one runs faster? | Tom Lane | 00:00 |
| Re: [ADMIN] Q: Structured index - which one runs faster? | Stephan Szabo | 06:42 |
| Re: [ADMIN] Q: Structured index - which one runs faster? | Vivek Khera | 15:09 |
| Re: postgres on a beowulf? (AMD)opteron? | scott.marlowe | 16:13 |
| Re: [GENERAL] Q: Structured index - which one runs faster? | Reece Hart | 16:46 |
| Re: [ADMIN] Q: Structured index - which one runs faster? | Bruno Wolff III | 16:50 |
| Re: [ADMIN] Q: Structured index - which one runs faster? | Tom Lane | 17:38 |
| Re: [ADMIN] Q: Structured index - which one runs faster? | Vivek Khera | 18:04 |
| Re: [ADMIN] Q: Structured index - which one runs faster? | Manfred Koizar | 18:30 |
| Simplifying varchar and bpchar behavior | Tom Lane | 20:34 |
| Thread | Author | Time |
|---|---|---|
| Wildcard searches & performance question | Grega Bremec | 19:09 |
| Re: Wildcard searches & performance question | Andrew Sullivan | 19:37 |
| Re: Wildcard searches & performance question | scott.marlowe | 19:48 |
| Re: Wildcard searches & performance question | Josh Berkus | 19:55 |
| Re: Wildcard searches & performance question | Rod Taylor | 20:06 |
| Thread | Author | Time |
|---|---|---|
| Re: IN list processing performance (yet again) | Dave Tenny | 01:19 |
| Re: IN list processing performance (yet again) | Tom Lane | 01:46 |
| Re: IN list processing performance (yet again) | Christopher Kings-Lynne | 01:47 |
| Re: IN list processing performance (yet again) | Christopher Kings-Lynne | 01:53 |
| Re: >24 hour restore | Victor Yegorov | 06:18 |
| Re: IN list processing performance (yet again) | Bruno Wolff III | 10:55 |
| Re: IN list processing performance (yet again) | Dave Tenny | 12:48 |
| Select query takes long to execute | Kevin Schroeder | 13:58 |
| Query problem fixed | Kevin Schroeder | 14:09 |
| Re: Select query takes long to execute | Shridhar Daithankar | 14:24 |
| Re: Query problem fixed | SZUCS Gábor | 14:27 |
| Re: Query problem fixed | Tom Lane | 14:49 |
| Re: Select query takes long to execute | scott.marlowe | 16:01 |
| db growing out of proportion | Tomas Szepe | 16:32 |
| Re: db growing out of proportion | Stephan Szabo | 17:37 |
| Thread | Author | Time |
|---|---|---|
| Re: Select query takes long to execute | Nikolaus Dilger | 02:44 |
| Re: db growing out of proportion | Tomas Szepe | 07:24 |
| Re: Select query takes long to execute | SZUCS Gábor | 08:57 |
| Re: db growing out of proportion | Peter Childs | 09:21 |
| Table Relationships | Jeandre du Toit | 09:23 |
| Re: Table Relationships | Victor Yegorov | 10:10 |
| Re: Table Relationships | Bruno Wolff III | 12:11 |
| Re: Select query takes long to execute | Bruno Wolff III | 12:13 |
| Re: db growing out of proportion | Tom Lane | 13:11 |
| Re: Table Relationships | Jeandre du Toit | 13:34 |
| Hardware advice | Adam Witney | 14:23 |
| Re: db growing out of proportion | Todd Nemanich | 14:25 |
| Re: Hardware advice | Andrew Sullivan | 14:44 |
| Re: Hardware advice | scott.marlowe | 15:25 |
| Re: db growing out of proportion | Stephan Szabo | 15:40 |
| Re: Table Relationships | Josh Berkus | 16:06 |