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 |
|---|---|---|
| dump time increase by 1h with new kernel | Justin Pryzby | 01:48 |
| Re: dump time increase by 1h with new kernel | Tom Lane | 02:35 |
| Re: Confusion on shared buffer | S Arvind | 06:11 |
| Thread | Author | Time |
|---|---|---|
| Re: Confusion on shared buffer | Robert Haas | 01:02 |
| Re: Performance problems with DISTINCT ON | imad | 02:27 |
| Re: Best suiting OS | Karl Denninger | 02:35 |
| Re: Performance problems with DISTINCT ON | Tom Lane | 02:53 |
| Re: dump time increase by 1h with new kernel | Scott Marlowe | 05:31 |
| Re: [PERFORM] Postgres performance | Robert Haas | 11:06 |
| Re: Postgres performance | Gerd Koenig | 11:08 |
| Re: Confusion on shared buffer | Gurjeet Singh | 13:28 |
| Re: Best suiting OS | Mark Mielke | 14:05 |
| Re: Best suiting OS | Devrim GÜNDÜZ | 17:55 |
| Re: Confusion on shared buffer | Robert Haas | 19:30 |
| Re: Best suiting OS | Mark Mielke | 19:51 |
| Re: Best suiting OS | Gerhard Wiesinger | 20:55 |
| Speed / Server | anthony | 22:45 |
| Thread | Author | Time |
|---|---|---|
| Re: Speed / Server | Greg Smith | 00:48 |
| Re: Speed / Server | richard.henwood | 08:40 |
| Re: Query plan for NOT IN | Grzegorz Jaśkiewicz | 13:27 |
| Re: Query plan for NOT IN | Kevin Grittner | 14:39 |
| Re: Query plan for NOT IN | Guy Rouillier | 17:33 |
| Re: Query plan for NOT IN | Kevin Grittner | 18:17 |
| Re: Query plan for NOT IN | Craig James | 20:27 |
| Re: Query plan for NOT IN | Guy Rouillier | 22:47 |
| Thread | Author | Time |
|---|---|---|
| Re: High CPU load on Postgres Server during Peak times!!!! | Shiva Raman | 07:11 |
| Re: Explain Analyze returns faster than psql or JDBC calls. | Dave Cramer | 11:57 |
| Re: Bad performance of SELECT ... where id IN (...) | Xia Qingran | 12:31 |
| Re: Bad performance of SELECT ... where id IN (...) | Kenneth Marshall | 13:09 |
| Re: High CPU load on Postgres Server during Peak times!!!! | Merlin Moncure | 13:27 |
| disk I/O problems and Solutions | Alan McKay | 16:45 |
| UUID as primary key | tsuraan | 16:56 |
| Databases vs Schemas | Scott Otis | 17:46 |
| Re: concurrent reindex issues | Tory M Blue | 17:58 |
| Re: Databases vs Schemas | Ben Chobot | 18:18 |
| Re: UUID as primary key | Mark Mielke | 18:30 |
| Re: disk I/O problems and Solutions | Flavio Henrique Araque Gurgel | 19:03 |
| Re: disk I/O problems and Solutions | Scott Marlowe | 19:22 |
| Re: Databases vs Schemas | Merlin Moncure | 21:02 |
| Re: disk I/O problems and Solutions | David Rees | 23:08 |
| Thread | Author | Time |
|---|---|---|
| Re: disk I/O problems and Solutions | Scott Carey | 02:46 |
| Re: Databases vs Schemas | Scott Carey | 02:50 |
| Re: Databases vs Schemas | Tom Lane | 03:11 |
| Re: UUID as primary key | tsuraan | 05:14 |
| Re: Databases vs Schemas | Merlin Moncure | 13:26 |
| Re: Databases vs Schemas | Chris Kratz | 14:44 |
| Re: UUID as primary key | Mark Mielke | 15:40 |
| table partitioning & max_locks_per_transaction | Brian Karlak | 20:55 |
| Re: Databases vs Schemas | Scott Marlowe | 21:34 |
| Thread | Author | Time |
|---|---|---|
| Re: table partitioning & max_locks_per_transaction | Tom Lane | 02:56 |
| table full scan or index full scan? | 旭斌 裴 | 10:26 |