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: SSD Performance Article | Scott Marlowe | 01:27 |
| Nls sorting in Postgresql-8.3.3 | Praveen | 08:35 |
| Re: [PERFORM] Nls sorting in Postgresql-8.3.3 | Richard Huxton | 08:43 |
| Re: Database size Vs performance degradation | Matthew Wakeling | 11:03 |
| Thread | Author | Time |
|---|---|---|
| Re: Nls sorting in Postgresql-8.3.3 | Mathias Stjernström | 10:39 |
| Thread | Author | Time |
|---|---|---|
| Re: Database size Vs performance degradation | Fernando Ike | 23:51 |
| Thread | Author | Time |
|---|---|---|
| Re: SSD Performance Article | H. Hall | 11:20 |
| Re: Posible planner improvement? | Kevin Grittner | 18:16 |
| Thread | Author | Time |
|---|---|---|
| file system and raid performance | Mark Wong | 04:54 |
| Re: file system and raid performance | david | 05:04 |
| Re: file system and raid performance | Gregory S. Youngblood | 05:56 |
| Re: file system and raid performance | Mark Wong | 14:57 |
| Re: file system and raid performance | Mark Wong | 15:00 |
| Re: file system and raid performance | Fernando Ike | 16:51 |
| Re: file system and raid performance | Mark Kirkwood | 23:53 |
| Thread | Author | Time |
|---|---|---|
| Re: file system and raid performance | Gregory S. Youngblood | 00:03 |
| pg_dump error - out of memory, Failed on request of size 536870912 📎 | Marcin Citowicki | 09:48 |
| Re: pg_dump error - out of memory, Failed on request of size 536870912 📎 | Marcin Citowicki | 10:26 |
| Re: pg_dump error - out of memory, Failed on request of size 536870912 | Pavel Stehule | 12:21 |
| Re: pg_dump error - out of memory, Failed on request of size 536870912 | Stefan Kaltenbrunner | 12:33 |
| query planner not using the correct index | Joshua Shanks | 21:35 |
| Plz Heeeelp! performance settings | dforum | 22:12 |
| Thread | Author | Time |
|---|---|---|
| Re: why query plan for the inner SELECT of WHERE x IN is wrong, but when run the inner query alone is OK? | Miernik | 02:20 |
| Re: why query plan for the inner SELECT of WHERE x IN is wrong, but when run the inner query alone is OK? | Scott Carey | 03:25 |
| Re: Filesystem benchmarking for pg 8.3.3 server | Henrik | 19:40 |
| Thread | Author | Time |
|---|---|---|
| Re: long transaction | Sabin Coanda | 06:53 |
| Using PK value as a String | Jay | 07:34 |
| Re: Filesystem benchmarking for pg 8.3.3 server | Henrik | 09:17 |
| Re: Using PK value as a String | Gregory Stark | 09:30 |
| Re: Using PK value as a String | Valentin Bogdanov | 09:46 |
| 答复: [PERFORM] Using PK value as a String | jay | 10:05 |
| Re: Filesystem benchmarking for pg 8.3.3 server | Glyn Astill | 10:35 |
| Re: Filesystem benchmarking for pg 8.3.3 server | Henrik | 12:08 |
| Re: Using PK value as a String | ries van Twisk | 12:22 |
| Re: Filesystem benchmarking for pg 8.3.3 server | Scott Marlowe | 13:20 |
| Re: Filesystem benchmarking for pg 8.3.3 server | Jeff | 14:01 |
| Re: Distant mirroring | dforums | 14:26 |
| [No subject] | Sven Clement | 14:44 |
| Re: Distant mirroring | Fernando Hevia | 15:35 |
| Re: Filesystem benchmarking for pg 8.3.3 server | Greg Smith | 15:56 |
| Re: Distant mirroring | Scott Marlowe | 16:00 |
| Re: Using PK value as a String | Craig James | 16:03 |
| Re: long transaction | Merlin Moncure | 19:03 |
| Thread | Author | Time |
|---|---|---|
| Re: autovacuum: use case for indenpedent TOAST table autovac settings | Tom Lane | 00:53 |
| Re: [HACKERS] autovacuum: use case for indenpedent TOAST table autovac settings | Alvaro Herrera | 01:28 |
| Re: [HACKERS] autovacuum: use case for indenpedent TOAST table autovac settings | Tom Lane | 01:30 |
| Re: Incorrect estimates on correlated filters | Craig Ringer | 01:48 |
| Re: [HACKERS] autovacuum: use case for indenpedent TOAST table autovac settings | Simon Riggs | 09:51 |
| Re: Incorrect estimates on correlated filters | Gregory Stark | 10:12 |
| Re: Filesystem benchmarking for pg 8.3.3 server | Greg Smith | 14:10 |
| Re: Filesystem benchmarking for pg 8.3.3 server | Scott Marlowe | 14:54 |
| Experiences storing binary in Postgres | juliano.freitas | 18:00 |
| Thread | Author | Time |
|---|---|---|
| Re: Filesystem benchmarking for pg 8.3.3 server | Ron Mayer | 04:33 |
| Optimizing a VIEW | Madison Kelly | 18:36 |
| Re: file system and raid performance | Bruce Momjian | 19:22 |
| Re: file system and raid performance | Mark Wong | 19:31 |
| Thread | Author | Time |
|---|---|---|
| Re: file system and raid performance | Greg Smith | 04:53 |
| Re: file system and raid performance | Mark Mielke | 15:01 |
| Re: Incorrect estimates on correlated filters | Decibel! | 18:21 |
| Re: Experiences storing binary in Postgres | Decibel! | 18:45 |
| Re: Filesystem benchmarking for pg 8.3.3 server | Decibel! | 18:49 |
| Re: Optimizing a VIEW | Decibel! | 19:19 |
| Thread | Author | Time |
|---|---|---|
| Re: Filesystem benchmarking for pg 8.3.3 server | david | 00:15 |
| Re: Optimizing a VIEW | Rodrigo E. De León Plicet | 01:33 |
| Re: Optimizing a VIEW | Rodrigo E. De León Plicet | 01:36 |
| Re: Optimizing a VIEW | Gurjeet Singh | 02:19 |
| Re: Filesystem benchmarking for pg 8.3.3 server | Gregory Stark | 10:55 |
| Re: Filesystem benchmarking for pg 8.3.3 server | Gregory Stark | 11:17 |
| Re: Optimizing a VIEW | Madison Kelly | 15:21 |
| Thread | Author | Time |
|---|---|---|
| Re: long transaction | Merlin Moncure | 00:04 |
| Re: Optimizing a VIEW | Matthew Wakeling | 11:06 |
| Cross Join Problem | Gauri Kanekar | 13:37 |
| Re: Cross Join Problem | Tom Lane | 14:02 |
| Slow query with a lot of data | Moritz Onken | 14:08 |
| Re: Slow query with a lot of data | Matthew Wakeling | 14:30 |
| Re: Slow query with a lot of data | Moritz Onken | 14:43 |
| Re: Slow query with a lot of data | Matthew Wakeling | 14:57 |
| Re: Cross Join Problem | Tom Lane | 15:20 |
| Re: file system and raid performance | Mark Wong | 15:33 |
| Re: Slow query with a lot of data | Moritz Onken | 15:49 |
| Re: Slow query with a lot of data | Matthew Wakeling | 16:05 |