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 |
|---|---|---|
| LIMIT causes planner to do Index Scan using a less optimal index | Joel Jacobson | 18:19 |
| Using high speed swap to improve performance? | Christiaan Willemsen | 19:15 |
| Re: Using high speed swap to improve performance? | Arjen van der Meijden | 19:53 |
| Re: How much memory is PostgreSQL using | Campbell, Lance | 20:10 |
| Does the psql executable support a "fetch many" approach when dumping large queries to stdout? | Beaver, John E | 20:28 |
| Re: *** PROBABLY SPAM *** Does the psql executable support a "fetch many" approach when dumping large queries to stdout? | Pierre C | 20:43 |
| Re: Does the psql executable support a "fetch many" approach when dumping large queries to stdout? | Hannu Krosing | 22:18 |
| Re: Does the psql executable support a "fetch many" approach when dumping large queries to stdout? 📎 | John Beaver | 22:18 |
| Re: *** PROBABLY SPAM *** Does the psql executable support a "fetch many" approach when dumping large queries to stdout? 📎 | John Beaver | 22:19 |
| Thread | Author | Time |
|---|---|---|
| David Crooke wants to stay in touch on LinkedIn | David Crooke | 05:05 |
| Re: How much memory is PostgreSQL using | Guillaume Lelarge | 11:58 |
| ERROR: cache lookup failed for relation X | raghavendra t | 16:38 |
| Re: ERROR: cache lookup failed for relation X | [email protected] | 17:04 |
| Re: ERROR: cache lookup failed for relation X | Tom Lane | 17:05 |
| Thread | Author | Time |
|---|---|---|
| Re: ERROR: cache lookup failed for relation X | raghavendra t | 02:50 |
| Re: ERROR: cache lookup failed for relation X | raghavendra t | 02:52 |
| Re: Using high speed swap to improve performance? | Robert Haas | 20:52 |
| Re: Using high speed swap to improve performance? | Robert Haas | 20:53 |
| Re: Using high speed swap to improve performance? | Scott Marlowe | 21:07 |
| Re: Using high speed swap to improve performance? | Lew | 21:17 |
| Thread | Author | Time |
|---|---|---|
| Re: temp table "on commit delete rows": transaction overhead | Artiom Makarov | 07:56 |
| Re: temp table "on commit delete rows": transaction overhead | Bruce Momjian | 12:09 |
| Huge table searching optimization | Oliver Kindernay | 14:28 |
| Re: Huge table searching optimization | hubert depesz lubaczewski | 14:32 |
| Re: Using high speed swap to improve performance? | Greg Smith | 14:55 |
| Re: Huge table searching optimization | Andres Freund | 16:10 |
| Re: Huge table searching optimization | Tom Lane | 16:22 |
| Re: How to fast the REINDEX | Robert Haas | 16:54 |
| Re: Huge table searching optimization | Oliver Kindernay | 17:11 |
| Thread | Author | Time |
|---|---|---|
| query slow; strace output worrisome | Brian Cox | 01:01 |
| Re: query slow; strace output worrisome | Craig Ringer | 01:53 |
| Re: query slow; strace output worrisome | Brian Cox | 04:04 |
| Re: query slow; strace output worrisome | Craig Ringer | 05:18 |
| Re: Using high speed swap to improve performance? | Christiaan Willemsen | 07:38 |
| Re: query slow; strace output worrisome | Brian Cox | 16:24 |
| Re: 3ware vs. MegaRAID | Ireneusz Pluta | 16:49 |
| Re: LIMIT causes planner to do Index Scan using a less optimal index | Robert Haas | 18:33 |
| Re: Some question | Scott Marlowe | 18:45 |
| Re: Using high speed swap to improve performance? | Scott Marlowe | 18:48 |
| indexes in partitioned tables - again | Samuel Gendler | 21:37 |
| Re: Some question | Kevin Grittner | 22:11 |
| Re: LIMIT causes planner to do Index Scan using a less optimal index | Joel Jacobson | 22:30 |
| Thread | Author | Time |
|---|---|---|
| Re: About “context-switching issue on Xeon” test case ？ | Greg Smith | 04:02 |
| Re: "could not open relation..." | Tom Lane | 04:29 |
| Re: significant slow down with various LIMIT | norn | 04:41 |
| Re: [PERFORM] About “context-switching issue on Xeon” test case ？ | Scott Marlowe | 05:05 |
| Re: [PERFORM] About “context-switching issue on Xeon” test case ？ | Scott Marlowe | 05:07 |
| Re: PostgreSQL with Zabbix - problem of newbe | Krzysztof Kardas | 18:54 |
| function performs differently with different values | Ben Chobot | 20:47 |
| Re: Some question | Ľubomír Varga | 21:42 |
| Thread | Author | Time |
|---|---|---|
| Re: About “context-switching issue on Xeon” test case ？ | Greg Smith | 02:22 |
| Re: "could not open relation..." | Brian Cox | 04:02 |
| Re: Some question | Kevin Grittner | 12:44 |
| Re: [PERFORM] About “context-switching issue on Xeon” test case ？ | Scott Marlowe | 15:43 |
| planer chooses very bad plan | Corin | 21:12 |
| Re: planer chooses very bad plan | Scott Marlowe | 21:18 |
| Re: planer chooses very bad plan | Luke Lonergan | 21:22 |
| Re: planer chooses very bad plan | Hannu Krosing | 21:25 |
| Re: planer chooses very bad plan | Corin | 22:41 |
| Re: planer chooses very bad plan | Corin | 22:44 |
| Re: planer chooses very bad plan | Scott Marlowe | 22:49 |
| Thread | Author | Time |
|---|---|---|
| 答复: [PERFORM] About “context-switching issue on Xeon” test case ？ | RD黄永卫 | 01:10 |
| Re: significant slow down with various LIMIT | Helio Campos Mello de Andrade | 02:43 |
| How to diagnose a “context-switching ” storm problem ? | RD黄永卫 | 06:35 |
| Re: planer chooses very bad plan | Pierre C | 10:06 |
| significant slow down with various LIMIT | Helio Campos Mello de Andrade | 10:23 |
| Re: significant slow down with various LIMIT | Kevin Grittner | 12:09 |
| Re: function performs differently with different values | Robert Haas | 13:21 |
| Re: significant slow down with various LIMIT | norn | 13:32 |
| Re: How check execution plan of a function | Kevin Grittner | 13:50 |
| Re: [PERFORM] How to diagnose a “context-switching ” storm problem ? | Sergey Konoplev | 21:27 |
| Re: significant slow down with various LIMIT | Kevin Grittner | 21:28 |
| Re: How to diagnose a *context-switching * storm problem ? | Kevin Grittner | 21:39 |
| Thread | Author | Time |
|---|---|---|
| Re: *** PROBABLY SPAM *** Does the psql executable support a "fetch many" approach when dumping large queries to stdout? | Bruce Momjian | 02:49 |
| Re: significant slow down with various LIMIT | norn | 06:07 |
| count is ten times faster | Sabin Coanda | 12:32 |
| stats collector suddenly causing lots of IO | Chris | 15:55 |
| stats collector suddenly causing lots of IO | Chris | 17:01 |
| Re: significant slow down with various LIMIT | Kevin Grittner | 17:24 |
| Re: significant slow down with various LIMIT | Chris Bowlby | 17:59 |
| Re: count is ten times faster | Pierre C | 18:09 |
| Re: stats collector suddenly causing lots of IO | Cédric Villemain | 18:13 |
| Re: "could not open relation..." | Tom Lane | 19:25 |
| Re: stats collector suddenly causing lots of IO | Alvaro Herrera | 21:55 |
| Thread | Author | Time |
|---|---|---|
| Re: PostgreSQL with Zabbix - problem of newbe | Krzysztof Kardas | 13:21 |
| Re: PostgreSQL with Zabbix - problem of newbe | Grzegorz Jaśkiewicz | 13:30 |
| Re: PostgreSQL with Zabbix - problem of newbe | Kevin Grittner | 13:50 |
| Re: count is ten times faster | Kevin Grittner | 14:16 |
| Re: significant slow down with various LIMIT | Kevin Grittner | 14:31 |
| Re: PostgreSQL with Zabbix - problem of newbe | Krzysztof Kardas | 19:02 |
| JDBC question for PG 8.3.9 | Dave Crooke | 20:49 |
| Re: Occasional giant spikes in CPU load | Bruce Momjian | 21:58 |
| Re: JDBC question for PG 8.3.9 | Craig Ringer | 23:10 |