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 |
|---|---|---|
| pgtune + configurations with 9.3 | Tory M Blue | 06:49 |
| Re: Incredibly slow restore times after 9.0>9.2 upgrade | jmcdonagh | 16:23 |
| Re: Incredibly slow restore times after 9.0>9.2 upgrade | Jerry Sievers | 16:58 |
| Re: Incredibly slow restore times after 9.0>9.2 upgrade | Tomas Vondra | 19:08 |
| Thread | Author | Time |
|---|---|---|
| Re: pgtune + configurations with 9.3 | Albe Laurenz | 09:43 |
| Thread | Author | Time |
|---|---|---|
| Replication Lag Causes | Mike Wilson | 22:33 |
| Re: Replication Lag Causes | Valentine Gogichashvili | 23:14 |
| Thread | Author | Time |
|---|---|---|
| Re: Replication Lag Causes | Mike Wilson | 20:58 |
| Re: Replication Lag Causes | Mike Wilson | 21:16 |
| Thread | Author | Time |
|---|---|---|
| Index order ignored after `is null` in query | Artūras Lapinskas | 01:40 |
| Re: Replication Lag Causes | Felipe Santos | 14:34 |
| assignment vs SELECT INTO | Andrew Dunstan | 20:00 |
| Re: assignment vs SELECT INTO | Tom Lane | 20:24 |
| Re: assignment vs SELECT INTO | Matheus de Oliveira | 20:27 |
| Re: assignment vs SELECT INTO | Andrew Dunstan | 20:31 |
| Thread | Author | Time |
|---|---|---|
| Re: Replication Lag Causes | Stuart Bishop | 12:34 |
| Re: unnecessary sort in the execution plan when doing group by | Simon Riggs | 16:02 |
| Re: Incredibly slow restore times after 9.0>9.2 upgrade | jmcdonagh | 16:28 |
| 9.3 performance issues, lots of bind and parse log entries | Tory M Blue | 17:01 |
| Re: Incredibly slow restore times after 9.0>9.2 upgrade | jmcdonagh | 18:59 |
| Re: 9.3 performance issues, lots of bind and parse log entries | Tory M Blue | 20:07 |
| Re: 9.3 performance issues, lots of bind and parse log entries | Tomas Vondra | 20:31 |
| Thread | Author | Time |
|---|---|---|
| intel s3500 -- hot stuff | Merlin Moncure | 17:40 |
| Re: intel s3500 -- hot stuff | Merlin Moncure | 18:09 |
| Re: 9.3 performance issues, lots of bind and parse log entries | Tory M Blue | 19:16 |
| log_temp_files (integer), tuning work_mem | Tory M Blue | 21:32 |
| Index order ignored after `is null` in query | Artūras Lapinskas | 21:42 |
| Thread | Author | Time |
|---|---|---|
| Re: 9.3 performance issues, lots of bind and parse log entries | Tomas Vondra | 01:54 |
| Re: log_temp_files (integer), tuning work_mem | Guillaume Lelarge | 06:31 |
| Re: Index order ignored after `is null` in query | Artūras Lapinskas | 17:06 |
| Re: Index order ignored after `is null` in query | Tom Lane | 17:23 |
| Re: pgtune + configurations with 9.3 | Josh Berkus | 22:01 |
| Thread | Author | Time |
|---|---|---|
| Postgres does not use indexes with OR-conditions | arhipov | 04:16 |
| Re: Postgres does not use indexes with OR-conditions | David Rowley | 04:38 |
| Re: Postgres does not use indexes with OR-conditions | Vlad Arkhipov | 05:06 |
| Re: Index order ignored after `is null` in query | Artūras Lapinskas | 11:14 |
| Re: Postgres does not use indexes with OR-conditions | Andrew Dunstan | 13:55 |
| Re: pgtune + configurations with 9.3 | Shaun Thomas | 14:13 |
| Re: Postgres does not use indexes with OR-conditions | Kevin Grittner | 14:17 |
| Re: Postgres does not use indexes with OR-conditions | Tom Lane | 15:11 |
| Re: Postgres does not use indexes with OR-conditions | David G Johnston | 16:50 |
| Thread | Author | Time |
|---|---|---|
| Postgres slave not catching up (on 9.2) | Ruben Domingo Gaspar Aparicio | 13:11 |
| Re: Postgres slave not catching up (on 9.2) | Robert Klemme | 20:35 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgres slave not catching up (on 9.2) | Andres Freund | 22:44 |
| Thread | Author | Time |
|---|---|---|
| trigger Before or After | avpro avpro | 06:38 |
| Re: [GENERAL] trigger Before or After | Albe Laurenz | 08:19 |
| Re: trigger Before or After | Adrian Klaver | 13:58 |
| Re: Lock pileup causes server to stall | Josh Berkus | 17:11 |
| Re: Lock pileup causes server to stall | Jeff Janes | 17:33 |
| Thread | Author | Time |
|---|---|---|
| Re: Lock pileup causes server to stall | Jesper Krogh | 06:49 |
| Re: Lock pileup causes server to stall | Alvaro Herrera | 13:51 |
| Re: Lock pileup causes server to stall | Josh Berkus | 17:04 |
| Thread | Author | Time |
|---|---|---|
| Re: Lock pileup causes server to stall | Jesper Krogh | 06:53 |
| 9.0 performance degradation with kernel 3.11 | Filip Rembiałkowski | 08:10 |
| Increased shared_buffer setting = lower hit ratio ? | CS DBA | 23:09 |
| Re: Increased shared_buffer setting = lower hit ratio ? | CS DBA | 23:16 |
| Re: Increased shared_buffer setting = lower hit ratio ? | Tomas Vondra | 23:35 |
| Thread | Author | Time |
|---|---|---|
| Re: Increased shared_buffer setting = lower hit ratio ? | Jeff Janes | 00:01 |
| Re[2]: [PERFORM] pgtune + configurations with 9.3 | Alexey Vasiliev | 14:23 |
| Re: 9.0 performance degradation with kernel 3.11 | Glyn Astill | 16:08 |
| Re: pgtune + configurations with 9.3 | Shaun Thomas | 16:28 |
| [PERFORM] pgtune + configurations with 9.3 | Alexey Vasiliev | 16:40 |
| Re: pgtune + configurations with 9.3 | Shaun Thomas | 17:06 |
| Re[2]: [PERFORM] pgtune + configurations with 9.3 | Alexey Vasiliev | 19:10 |
| Re: pgtune + configurations with 9.3 | Mark Kirkwood | 23:00 |
| Thread | Author | Time |
|---|---|---|
| Re: updating statistics on slow running query | Jim Nasby | 01:53 |
| Re: pgtune + configurations with 9.3 | Jim Nasby | 02:08 |
| Re: Index order ignored after `is null` in query | Jim Nasby | 02:12 |
| Re: pgtune + configurations with 9.3 | Mark Kirkwood | 03:29 |
| Plan uses wrong index, preferring to scan pkey index instead | Yuri Kunde Schlesner | 23:16 |
| Re: Plan uses wrong index, preferring to scan pkey index instead | Yuri Kunde Schlesner | 23:24 |
| Thread | Author | Time |
|---|---|---|
| Re: Plan uses wrong index, preferring to scan pkey index instead | Tom Lane | 17:18 |
| Re: Partitions and work_mem? | Dave Johansen | 22:25 |
| Thread | Author | Time |
|---|---|---|
| Re: Re[2]: [PERFORM] pgtune + configurations with 9.3 | Stuart Bishop | 04:52 |
| Re: pgtune + configurations with 9.3 | Stuart Bishop | 05:17 |
| Re: Partitions and work_mem? | Magnus Hagander | 06:57 |
| Re: Partitions and work_mem? | Tom Lane | 15:13 |
| Thread | Author | Time |
|---|---|---|
| Re: Partitions and work_mem? | Dave Johansen | 03:34 |
| Thread | Author | Time |
|---|---|---|
| Re: Plan uses wrong index, preferring to scan pkey index instead | Yuri Kunde Schlesner | 00:02 |
| Thread | Author | Time |
|---|---|---|
| A pessimistic planner | Stuart Bishop | 05:07 |
| Re: A pessimistic planner | Tom Lane | 05:12 |
| Re: Yet another abort-early plan disaster on 9.3 | Jeff Janes | 18:38 |
| Thread | Author | Time |
|---|---|---|
| Re: Yet another abort-early plan disaster on 9.3 📎 | Tomas Vondra | 20:19 |
| Thread | Author | Time |
|---|---|---|
| Re: pgtune + configurations with 9.3 | Johann Spies | 07:01 |
| Why don't use index on x when ORDER BY x, y? | Vlad Arkhipov | 11:02 |
| Re: Why don't use index on x when ORDER BY x, y? | Robert Klemme | 13:39 |
| Re: Why don't use index on x when ORDER BY x, y? | Tom Lane | 15:38 |
| Thread | Author | Time |
|---|---|---|
| Small performance regression in 9.2 has a big impact 📎 | Scott Marlowe | 20:36 |
| Re: Small performance regression in 9.2 has a big impact | Heikki Linnakangas | 20:58 |
| Re: Small performance regression in 9.2 has a big impact | Tom Lane | 21:55 |
| Re: Small performance regression in 9.2 has a big impact | Scott Marlowe | 22:25 |
| Re: Small performance regression in 9.2 has a big impact | Tom Lane | 22:57 |
| Re: Small performance regression in 9.2 has a big impact | Tom Lane | 23:02 |
| Thread | Author | Time |
|---|---|---|
| Re: Small performance regression in 9.2 has a big impact 📎 | Tom Lane | 03:59 |
| issue in postgresql 9.1.3 in using arrow key in Solaris platform | M Tarkeshwar Rao | 10:16 |
| Re: pgtune + configurations with 9.3 📎 | Johann Spies | 13:34 |
| Re: pgtune + configurations with 9.3 📎 | Johann Spies | 13:39 |
| Re: issue in postgresql 9.1.3 in using arrow key in Solaris platform | Adrian Klaver | 14:37 |
| Re: issue in postgresql 9.1.3 in using arrow key in Solaris platform | Tom Lane | 15:27 |
| Re: Small performance regression in 9.2 has a big impact | Scott Marlowe | 17:21 |
| Thread | Author | Time |
|---|---|---|