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 |
|---|---|---|
| [pgsql-performance] Performance Problems | Lars Maschke | 11:00 |
| Clusters | James Kelty | 20:47 |
| Re: Clusters | Andrew Sullivan | 20:59 |
| Re: Clusters | Sean Chittenden | 21:18 |
| Re: Clusters | Andrew Sullivan | 21:32 |
| Low Budget Performance | eric soroos | 21:56 |
| Re: Setting shared buffers | Carlos Moreno | 22:07 |
| Thread | Author | Time |
|---|---|---|
| Re: Clusters | James Kelty | 00:00 |
| Re: Clusters | Andrew Sullivan | 03:27 |
| Re: Low Budget Performance | Shridhar Daithankar | 06:30 |
| Re: Low Budget Performance | Mario Weilguni | 07:07 |
| Re: [pgsql-performance] Performance Problems | Andrew Sullivan | 13:38 |
| Re: Clusters | Tom Lane | 13:43 |
| Possible OT - Benchmark test for 7.3 Beta 3 | Kenny H Klatt | 14:26 |
| Re: Possible OT - Benchmark test for 7.3 Beta 3 | Andrew Sullivan | 15:15 |
| Re: Low Budget Performance | Josh Berkus | 17:00 |
| Re: Low Budget Performance | Josh Berkus | 17:10 |
| Re: Low Budget Performance | Andrew Sullivan | 17:31 |
| Re: Low Budget Performance | eric soroos | 18:43 |
| Re: Low Budget Performance | Andrew Sullivan | 20:13 |
| Re: Low Budget Performance | Ron Johnson | 21:09 |
| Re: Low Budget Performance | Robert J. Sanford, Jr. | 21:57 |
| Thread | Author | Time |
|---|---|---|
| Re: PG_Autotune 0.1 | Justin Clift | 01:38 |
| Thread | Author | Time |
|---|---|---|
| Is dump-reload the only cure? | mallah | 11:15 |
| Re: [pgsql-performance] Is dump-reload the only cure? | Rod Taylor | 12:52 |
| Re: [pgsql-performance] Is dump-reload the only cure? | mallah | 13:03 |
| Re: [pgsql-performance] Is dump-reload the only cure? | mallah | 13:15 |
| Re: [pgsql-performance] Is dump-reload the only cure? | Rod Taylor | 14:07 |
| Re: [pgsql-performance] Is dump-reload the only cure? | Rod Taylor | 14:11 |
| Re: Is dump-reload the only cure? | Rod Taylor | 14:38 |
| Re: [pgsql-performance] Is dump-reload the only cure? | mallah | 14:41 |
| Re: [pgsql-performance] Is dump-reload the only cure? | Robert Treat | 19:54 |
| Does this matter? | Wei Weng | 20:18 |
| Re: Does this matter? | Josh Berkus | 20:23 |
| Re: Does this matter? | Wei Weng | 20:52 |
| Re: Does this matter? | Philip Hallstrom | 20:53 |
| Re: Does this matter? | Andrew Sullivan | 21:10 |
| Re: Does this matter? | Josh Berkus | 22:00 |
| Re: Does this matter? | Curtis Faith | 22:00 |
| Re: Does this matter? | Josh Berkus | 22:01 |
| Thread | Author | Time |
|---|---|---|
| Re: Does this matter? | Neil Conway | 04:08 |
| Re: [PERFORM] Does this matter? | Wei Weng | 04:33 |
| Thread | Author | Time |
|---|---|---|
| Upgrade to dual processor machine? | Henrik Steffen | 12:32 |
| Re: Upgrade to dual processor machine? | Justin Clift | 12:50 |
| Re: Upgrade to dual processor machine? | Neil Conway | 18:56 |
| Thread | Author | Time |
|---|---|---|
| Re: Upgrade to dual processor machine? | Henrik Steffen | 07:05 |
| Re: Upgrade to dual processor machine? | Neil Conway | 07:32 |
| Re: Upgrade to dual processor machine? | Justin Clift | 07:44 |
| Slow response from 'SELECT * FROM table' | Jirka Novak | 10:08 |
| Re: Slow response from 'SELECT * FROM table' | Jakub Ouhrabka | 10:13 |
| Re: Upgrade to dual processor machine? | Helge Bahmann | 11:56 |
| Re: Slow response from 'SELECT * FROM table' | Wei Weng | 17:19 |
| Re: Slow response from 'SELECT * FROM table' | Josh Berkus | 17:28 |
| Query performance discontinuity | Mike Nielsen | 17:44 |
| Re: Slow response from 'SELECT * FROM table' | Andrew Sullivan | 17:59 |
| Re: Upgrade to dual processor machine? | Shaun Thomas | 18:08 |
| Re: Upgrade to dual processor machine? | scott.marlowe | 18:25 |
| Re: Query performance discontinuity | Josh Berkus | 19:14 |
| Re: Query performance discontinuity | Stephan Szabo | 19:37 |
| Thread | Author | Time |
|---|---|---|
| Re: Query performance discontinuity | Tom Lane | 01:39 |
| Re: Query performance discontinuity | Mike Nielsen | 04:10 |
| Re: Query performance discontinuity | Rod Taylor | 04:51 |
| Re: Slow response from 'SELECT * FROM table' | Jirka Novak | 07:30 |
| Re: Query performance discontinuity | Josh Berkus | 16:57 |
| Re: Upgrade to dual processor machine? | scott.marlowe | 17:22 |
| Re: Upgrade to dual processor machine? | Henrik Steffen | 19:22 |
| Re: Upgrade to dual processor machine? | Henrik Steffen | 19:27 |
| Re: Upgrade to dual processor machine? | Henrik Steffen | 19:42 |
| Re: Upgrade to dual processor machine? | Henrik Steffen | 19:45 |
| Re: Upgrade to dual processor machine? | Josh Berkus | 20:05 |
| Re: Upgrade to dual processor machine? | scott.marlowe | 20:26 |
| Thread | Author | Time |
|---|---|---|
| Re: Sort time | pginfo | 06:20 |
| Re: Sort time | pginfo | 06:36 |
| Re: Sort time | Stephan Szabo | 17:15 |
| Thread | Author | Time |
|---|---|---|
| Re: Sort time | pginfo | 06:30 |
| Re: Sort time | pginfo | 07:29 |
| Re: Sort time | Stephan Szabo | 07:44 |
| Re: Sort time | pginfo | 08:16 |
| Re: Sort time | Stephan Szabo | 08:18 |
| Re: Sort time | Stephan Szabo | 17:29 |
| Re: Sort time | Tom Lane | 20:56 |
| Re: Sort time | Hannu Krosing | 21:10 |
| Re: Sort time | Tom Lane | 23:05 |
| Re: Sort time | Tom Lane | 23:54 |
| Thread | Author | Time |
|---|---|---|
| Re: Sort time | pginfo | 06:10 |
| Re: Sort time | pginfo | 10:16 |
| Re: Sort time | Stephan Szabo | 11:56 |
| selects from large tables | Nikk Anderson | 12:32 |
| Re: selects from large tables | Stephan Szabo | 13:02 |
| Re: for/loop performance in plpgsql ? | Federico | 15:02 |
| Re: selects from large tables | Tom Lane | 15:03 |
| Re: selects from large tables | Nikk Anderson | 15:31 |
| Re: selects from large tables | Nikk Anderson | 15:36 |
| Re: selects from large tables | Andrew Sullivan | 15:43 |
| Re: selects from large tables | Charles H. Woloszynski | 15:46 |
| Re: selects from large tables | Tom Lane | 16:25 |
| Re: selects from large tables | Stephan Szabo | 16:32 |
| Re: selects from large tables | Nikk Anderson | 16:32 |
| Re: selects from large tables | Nikk Anderson | 16:36 |
| Re: selects from large tables | Robert Treat | 18:48 |
| Thread | Author | Time |
|---|---|---|
| Question regarding effects of Vacuum, Vacuum Analyze, and Reindex | Adrian Calvin | 03:02 |
| Re: for/loop performance in plpgsql ? | Tom Lane | 05:23 |
| Re: for/loop performance in plpgsql ? | Federico /* juri */ Pedemonte | 09:49 |