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 |
|---|---|---|
| Re: JDBC 5 million function insert returning Single Transaction Lock Access Exclusive Problem | Craig Ringer | 00:43 |
| Re: NOTIFY performance 📎 | Jeff Janes | 02:12 |
| Re: Bad query plan when the wrong data type is used | Bruce Momjian | 16:25 |
| Thread | Author | Time |
|---|---|---|
| Re: [PERFORM] pg_dump and thousands of schemas | Jeff Janes | 21:39 |
| Fwd: [PERFORM] Loose Index Scans by Planner? | Jeff Janes | 21:53 |
| Thread | Author | Time |
|---|---|---|
| Re: [PERFORM] pg_dump and thousands of schemas | Robert Haas | 04:37 |
| Re: Execution from java - slow | Jayadevan M | 08:35 |
| Inserts in 'big' table slowing down the database | Stefan Keller | 11:03 |
| Re: Inserts in 'big' table slowing down the database | Ivan Voras | 11:21 |
| Re: exponential performance decrease in ISD transaction | John Nash | 11:22 |
| Re: exponential performance decrease in ISD transaction | Jeff Janes | 17:27 |
| Thread | Author | Time |
|---|---|---|
| HELP!!!-----Need to Sql commands to monitoring Postgresql | charles_xie | 07:12 |
| Re: JDBC 5 million function insert returning Single Transaction Lock Access Exclusive Problem | Eileen | 23:34 |
| Thread | Author | Time |
|---|---|---|
| query performance, where goes time? | Anibal David Acosta | 21:48 |
| Thread | Author | Time |
|---|---|---|
| Re: query performance, where goes time? | Craig Ringer | 01:26 |
| Re: [repost] Help me develop new commit_delay advice | Greg Smith | 03:20 |
| Re: exponential performance decrease in ISD transaction | Greg Smith | 03:55 |
| Re: HELP!!!-----Need to Sql commands to monitoring Postgresql | Daniel Farina | 07:43 |
| Re: HELP!!!-----Need to Sql commands to monitoring Postgresql | Josh Berkus | 19:44 |
| Re: HELP!!!-----Need to Sql commands to monitoring Postgresql | Steven Crandell | 19:50 |
| libpq or postgresql performance | Aryan Ariel Rodriguez Chalas | 20:04 |
| Thread | Author | Time |
|---|---|---|
| Re: HELP!!!-----Need to Sql commands to monitoring Postgresql | charles_xie | 01:50 |
| Re: libpq or postgresql performance | Andreas Kretschmer | 05:35 |
| Re: HELP!!!-----Need to Sql commands to monitoring Postgresql | Daniel Farina | 05:45 |
| Re: libpq or postgresql performance | Albe Laurenz | 06:45 |
| Re: libpq or postgresql performance | Ireneusz Pluta | 06:52 |
| Re: exponential performance decrease in ISD transaction | John Nash | 10:55 |
| Re: exponential performance decrease in ISD transaction 📎 | John Nash | 10:57 |
| Re: libpq or postgresql performance | Ireneusz Pluta | 17:24 |
| Thread | Author | Time |
|---|---|---|
| Re: libpq or postgresql performance | Ireneusz Pluta | 09:01 |
| : PostgreSQL Index behavior | Venkat Balaji | 12:39 |
| Planner selects different execution plans depending on limit | bill_martin | 14:24 |
| force defaults | Willy-Bas Loos | 14:40 |
| Re: : PostgreSQL Index behavior | Jeff Janes | 15:36 |
| Re: Planner selects different execution plans depending on limit | Jesper Krogh | 18:18 |
| Re: Slow Performance on a XEON E5504 | Marcos Ortiz | 20:58 |
| Thread | Author | Time |
|---|---|---|
| Re: Planner selects different execution plans depending on limit | Bill Martin | 07:20 |
| add column with default value is very slow | AI Rumman | 13:20 |
| Re: add column with default value is very slow | Albe Laurenz | 13:41 |
| Re: add column with default value is very slow | hubert depesz lubaczewski | 13:44 |
| Re: add column with default value is very slow 📎 | AI Rumman | 13:55 |
| Re: add column with default value is very slow | hubert depesz lubaczewski | 13:59 |
| Re: add column with default value is very slow | AI Rumman | 14:04 |
| Re: add column with default value is very slow | hubert depesz lubaczewski | 14:05 |
| Re: add column with default value is very slow | Andrew Dunstan | 14:07 |
| Re: Planner selects different execution plans depending on limit | Tom Lane | 17:19 |
| Thread | Author | Time |
|---|---|---|
| Re: : PostgreSQL Index behavior | Venkat Balaji | 06:57 |
| Re: : PostgreSQL Index behavior | Scott Marlowe | 14:12 |
| Guide to Posting Slow Query Questions | Jeff Janes | 16:00 |
| Thread | Author | Time |
|---|---|---|
| Re: Setting autovacuum_vacuum_scale_factor to 0 a good idea ? | Sébastien Lorion | 02:35 |
| Re: Remote access to Postgresql slow | Andrew Barnham | 21:17 |
| Re: Remote access to Postgresql slow | Scott Marlowe | 21:20 |
| Thread | Author | Time |
|---|---|---|
| PostgreSQL performance on 64 bit as compared to 32 bit | Umesh Kirdat | 03:48 |
| Re: Are there known performance issues with defining all Foreign Keys as deferrable initially immediate | Craig Ringer | 13:45 |
| Re: Are there known performance issues with defining all Foreign Keys as deferrable initially immediate | Craig Ringer | 14:12 |
| Re: Are there known performance issues with defining all Foreign Keys as deferrable initially immediate | Tom Lane | 15:37 |
| Re: [PERFORM] Planner selects different execution plans depending on limit | Jeff Janes | 21:39 |
| Re: [PERFORM] Planner selects different execution plans depending on limit | Tom Lane | 22:16 |
| Thread | Author | Time |
|---|---|---|
| Re: Are there known performance issues with defining all Foreign Keys as deferrable initially immediate | Craig Ringer | 02:59 |
| Re: wal_sync_method on FreeBSD 9.0 - ZFS | Ivan Voras | 10:56 |
| Re: Are there known performance issues with defining all Foreign Keys as deferrable initially immediate | McKinzie, Alan (Alan) | 13:38 |
| Thread | Author | Time |
|---|---|---|
| Re: Planner selects different execution plans depending on limit | Bill Martin | 07:28 |
| Re: 20% performance drop on PostgreSQL 9.2 from kernel 3.5.3 to 3.6-rc5 on AMD chipsets | Andrea Suisani | 07:44 |
| Re: 20% performance drop on PostgreSQL 9.2 from kernel 3.5.3 to 3.6-rc5 on AMD chipsets | Merlin Moncure | 13:54 |
| Re: 20% performance drop on PostgreSQL 9.2 from kernel 3.5.3 to 3.6-rc5 on AMD chipsets | Andrea Suisani | 14:25 |
| Thread | Author | Time |
|---|---|---|
| Newbie performance problem - semop taking most of time ? | mal.oracledba | 12:34 |
| Thread | Author | Time |
|---|---|---|
| problems with large objects dump | Sergio Gabriel Rodriguez | 12:06 |
| Re: problems with large objects dump | Tom Lane | 14:35 |
| Re: problems with large objects dump | Sergio Gabriel Rodriguez | 15:53 |
| Re: problems with large objects dump | Tom Lane | 16:33 |
| Thread | Author | Time |
|---|---|---|
| Cost of opening and closing an empty transaction | Jon Leighton | 10:46 |
| Query Planner Optimization? | Brandon | 17:08 |
| Thread | Author | Time |
|---|---|---|
| Re: PostgreSQL performance on 64 bit as compared to 32 bit | Claudio Freire | 02:43 |
| Re: Cost of opening and closing an empty transaction | Claudio Freire | 03:08 |
| Re: Newbie performance problem - semop taking most of time ? | Daniel Farina | 05:50 |
| Re: wal_sync_method on FreeBSD 9.0 - ZFS | Sébastien Lorion | 14:01 |
| Thread | Author | Time |
|---|---|---|
| Re: Newbie performance problem - semop taking most of time ? | mal.oracledba | 19:42 |
| Re: Newbie performance problem - semop taking most of time ? | Tom Lane | 20:36 |
| Thread | Author | Time |
|---|---|---|
| Re: Spurious failure to obtain row lock possible in PG 9.1? | Albe Laurenz | 10:48 |
| Re: Postgres becoming slow, only full vacuum fixes it | Kiriakos Tsourapas | 11:01 |
| Re: Postgres becoming slow, only full vacuum fixes it | Kiriakos Tsourapas | 11:07 |
| Re: Postgres becoming slow, only full vacuum fixes it | Kiriakos Tsourapas | 11:10 |
| Re: Postgres becoming slow, only full vacuum fixes it | Thomas Kellerer | 11:24 |
| Re: Postgres becoming slow, only full vacuum fixes it | Kevin Grittner | 12:40 |
| Re: Postgres becoming slow, only full vacuum fixes it | Ondrej Ivanič | 23:14 |