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 |
|---|---|---|
| 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 |
| Re: [HACKERS] Question regarding effects of Vacuum, Vacuum | Rod Taylor | 13:46 |
| Re: for/loop performance in plpgsql ? | Tom Lane | 14:04 |
| Slow DELETE with IN clausule | Jirka Novak | 14:26 |
| Re: Slow DELETE with IN clausule | Richard Huxton | 14:36 |
| Re: Slow DELETE with IN clausule | Andrew Sullivan | 14:39 |
| Thread | Author | Time |
|---|---|---|
| Re: selects from large tables | Nikk Anderson | 15:08 |
| Re: selects from large tables | Tom Lane | 15:16 |
| Re: selects from large tables | Bruce Momjian | 15:18 |
| Re: selects from large tables | Rod Taylor | 15:31 |
| Re: selects from large tables | Nikk Anderson | 15:49 |
| Re: selects from large tables | Rod Taylor | 15:56 |
| [No subject] | Francisco Reyes | 18:58 |
| Re: selects from large tables | Hannu Krosing | 20:26 |
| Query Analysis | typea | 23:40 |
| Re: Query Analysis | Josh Berkus | 23:52 |
| Thread | Author | Time |
|---|---|---|
| Is there a system of cache in pgsql 7.3rc1 ? | David Pradier | 09:28 |
| Re: Query Analysis | typea | 16:16 |
| H/W RAID 5 on slower disks versus no raid on faster HDDs | Rajesh Kumar Mallah. | 16:45 |
| vacuum full | Henrik Steffen | 16:52 |
| Re: H/W RAID 5 on slower disks versus no raid on faster | Charles H. Woloszynski | 17:06 |
| Re: H/W RAID 5 on slower disks versus no raid on faster HDDs | Chris Ruprecht | 17:19 |
| Re: H/W RAID 5 on slower disks versus no raid on faster | scott.marlowe | 17:32 |
| Re: vacuum full | scott.marlowe | 17:32 |