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 + RAID | Tom Lane | 04:24 |
| Re: SSD + RAID | Scott Carey | 04:35 |
| Re: SSD + RAID | Scott Carey | 04:39 |
| Re: SSD + RAID | Craig Ringer | 12:29 |
| Re: SSD + RAID | Greg Smith | 14:44 |
| Re: SSD + RAID 📎 | Karl Denninger | 14:44 |
| Re: SSD + RAID | Greg Smith | 14:49 |
| Re: SSD + RAID | Merlin Moncure | 17:01 |
| View based upon function won't use index on joins | Jonathan Foy | 17:06 |
| Re: SSD + RAID | Scott Marlowe | 17:19 |
| Re: SSD + RAID | Anton Rommerskirchen | 18:01 |
| FSM - per database or per installation? | Craig James | 18:12 |
| Re: FSM - per database or per installation? | Heikki Linnakangas | 18:33 |
| Re: SSD + RAID | Brad Nicholson | 18:57 |
| Re: SSD + RAID | Greg Smith | 21:04 |
| Re: SSD + RAID | Greg Smith | 21:10 |
| Re: SSD + RAID | Merlin Moncure | 21:39 |
| Re: SSD + RAID | Scott Marlowe | 21:52 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgres query completion status? | Greg Smith | 00:07 |
| Re: Postgres query completion status? | Greg Smith | 00:18 |
| Re: SSD + RAID | Greg Smith | 00:27 |
| Re: SSD + RAID | Merlin Moncure | 14:25 |
| Performance degrade running on multicore computer | afancy | 22:56 |
| Re: Performance degrade running on multicore computer | Tom Lane | 23:13 |
| Thread | Author | Time |
|---|---|---|
| sub-select makes query take too long - unusable | Mark Dueck | 04:41 |
| sub-select makes query take too long - unusable | Mark Dueck | 05:13 |
| Re: sub-select makes query take too long - unusable | Sergey Aleynikov | 08:06 |
| Re: Performance degrade running on multicore computer | afancy | 09:02 |
| Why is the query not using the index for sorting? | Jonathan Blitz | 12:50 |
| Re: Why is the query not using the index for sorting? | Thom Brown | 13:10 |
| Re: Why is the query not using the index for sorting? | Craig Ringer | 13:25 |
| Re: Why is the query not using the index for sorting? | Jonathan Blitz | 13:34 |
| Re: Postgres query completion status? | Richard Neill | 15:10 |
| Re: Postgres query completion status? | Richard Neill | 15:10 |
| Re: Postgres query completion status? | Richard Neill | 15:14 |
| Query times change by orders of magnitude as DB ages | Richard Neill | 15:31 |
| Re: Query times change by orders of magnitude as DB ages | Sergey Aleynikov | 16:13 |
| Thread | Author | Time |
|---|---|---|
| Re: Why is the query not using the index for sorting? | Matthew Wakeling | 11:00 |
| Re: Query times change by orders of magnitude as DB ages | Matthew Wakeling | 12:44 |
| Re: Why is the query not using the index for sorting? | Jonathan Blitz | 14:10 |
| Re: View based upon function won't use index on joins | Robert Haas | 16:47 |
| Re: Query times change by orders of magnitude as DB ages | Robert Haas | 18:11 |
| Re: Performance degrade running on multicore computer | Dave Youatt | 19:10 |
| Re: Strange performance degradation | Lorenzo Allegrucci | 20:46 |
| Best possible way to insert and get returned ids | Jason Dictos | 20:53 |
| Re: Strange performance degradation | Bill Moran | 21:05 |
| Re: Strange performance degradation | Tom Lane | 21:26 |
| Re: Best possible way to insert and get returned ids | Scott Marlowe | 21:55 |
| query optimization | Faheem Mitha | 22:47 |
| Re: query optimization | Thom Brown | 23:25 |
| Re: query optimization | Faheem Mitha | 23:49 |
| Re: query optimization | marcin mank | 23:52 |