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: Index Bloat Problem | Jeff Janes | 02:33 |
| Re: Index Bloat Problem | Greg Williamson | 08:01 |
| Thread | Author | Time |
|---|---|---|
| Re: 7k records into Sort node, 4.5m out? | Josh Berkus | 19:53 |
| Thread | Author | Time |
|---|---|---|
| Re: 7k records into Sort node, 4.5m out? | Tom Lane | 15:40 |
| Re: 7k records into Sort node, 4.5m out? | Josh Berkus | 17:47 |
| Re: Increasing WAL usage followed by sudden drop | delongboy | 20:51 |
| Does setval(nextval()+N) generate unique blocks of IDs? | Craig James | 23:32 |
| Thread | Author | Time |
|---|---|---|
| Re: average query performance measuring | Rick Otten | 14:04 |
| Thread | Author | Time |
|---|---|---|
| Re: Increasing WAL usage followed by sudden drop | Jeff Janes | 00:28 |
| Re: Performance of Seq Scan from buffer cache | Merlin Moncure | 13:32 |
| Re: Increasing WAL usage followed by sudden drop | delongboy | 14:43 |
| Thread | Author | Time |
|---|---|---|
| Slow Performance on a XEON E5504 | Felix Schubert | 09:47 |
| Loose Index Scans by Planner? | Shaun Thomas | 16:20 |
| NOTIFY performance | Artur Zając | 18:46 |
| Re: NOTIFY performance | Merlin Moncure | 19:12 |
| Re: Loose Index Scans by Planner? | Kevin Grittner | 19:40 |
| Re: NOTIFY performance | Artur Zając | 21:11 |
| Re: Loose Index Scans by Planner? | Shaun Thomas | 21:22 |
| Thread | Author | Time |
|---|---|---|
| Re: Loose Index Scans by Planner? | Jeff Janes | 03:42 |
| Slow Performance on a XEON E5504 | Felix Schubert | 12:07 |
| Re: Slow Performance on a XEON E5504 | Scott Marlowe | 12:42 |
| Re: Slow Performance on a XEON E5504 | Felix Schubert | 12:53 |
| Re: Slow Performance on a XEON E5504 | Scott Marlowe | 12:59 |
| Re: Slow Performance on a XEON E5504 | Scott Marlowe | 13:04 |
| Re: Loose Index Scans by Planner? | Shaun Thomas | 14:39 |
| Re: Slow Performance on a XEON E5504 | Felix Schubert | 21:26 |
| Re: Slow Performance on a XEON E5504 | Scott Marlowe | 21:47 |
| Thread | Author | Time |
|---|---|---|
| Investigating the reason for a very big TOAST table size | Liron Shiri | 12:46 |
| Investigating the reason for a very big TOAST table size | Liron Shiri | 12:51 |
| Thread | Author | Time |
|---|---|---|
| Execution from java - slow | Jayadevan M | 12:37 |
| Re: Execution from java - slow | Albe Laurenz | 12:47 |
| Re: Investigating the reason for a very big TOAST table size | Daniel Farina | 16:42 |
| Thread | Author | Time |
|---|---|---|
| Vacuum problems with 9.1 | Nimesh Satam | 04:33 |
| Re: Investigating the reason for a very big TOAST table size | Liron Shiri | 06:24 |
| Re: Vacuum problems with 9.1 | Pavan Deolasee | 06:33 |
| Re: Vacuum problems with 9.1 | Craig Ringer | 06:53 |
| Re: Execution from java - slow | Pavan Deolasee | 07:11 |
| pg_trgm and slow bitmap index scan plan 📎 | Mathieu De Zutter | 07:39 |
| Re: Investigating the reason for a very big TOAST table size | Daniel Farina | 08:57 |
| Re: Investigating the reason for a very big TOAST table size 📎 | Daniel Farina | 08:59 |
| Re: pg_trgm and slow bitmap index scan plan | Merlin Moncure | 13:27 |
| Re: Execution from java - slow | Merlin Moncure | 13:32 |
| Re: NOTIFY performance | Merlin Moncure | 15:11 |
| Thread | Author | Time |
|---|---|---|
| JDBC 5 million function insert returning Single Transaction Lock Access Exclusive Problem | Eileen | 06:34 |
| Re: Investigating the reason for a very big TOAST table size | Daniel Farina | 08:10 |
| Question about caching on full table scans | Markus Innerebner | 08:13 |
| Re: Investigating the reason for a very big TOAST table size | Liron Shiri | 08:34 |
| Re: Investigating the reason for a very big TOAST table size | Daniel Farina | 08:39 |
| Re: Question about caching on full table scans | Albe Laurenz | 09:31 |
| Re: Question about caching on full table scans | Markus Innerebner | 17:34 |
| Re: Question about caching on full table scans | Jeff Janes | 18:00 |
| Re: Question about caching on full table scans | Scott Marlowe | 18:13 |
| Re: pg_dump and thousands of schemas | Bruce Momjian | 20:44 |
| Re: pg_dump and thousands of schemas | Tom Lane | 20:51 |
| Re: pg_dump and thousands of schemas | Bruce Momjian | 20:53 |
| Re: [HACKERS] pg_dump and thousands of schemas | Robert Haas | 21:45 |
| Thread | Author | Time |
|---|---|---|
| Re: [HACKERS] pg_dump and thousands of schemas | Tom Lane | 03:17 |
| Re: Question about caching on full table scans | Markus Innerebner | 07:30 |
| exponential performance decrease in ISD transaction | John Nash | 12:27 |
| Re: exponential performance decrease in ISD transaction | Heikki Linnakangas | 13:36 |
| Re: JDBC 5 million function insert returning Single Transaction Lock Access Exclusive Problem | Dave Cramer | 13:50 |
| Re: JDBC 5 million function insert returning Single Transaction Lock Access Exclusive Problem | Albe Laurenz | 14:18 |
| Re: JDBC 5 million function insert returning Single Transaction Lock Access Exclusive Problem | Scott Marlowe | 15:18 |
| Re: exponential performance decrease in ISD transaction | Jeff Janes | 16:17 |
| Re: NOTIFY performance | Jeff Janes | 19:54 |
| Re: NOTIFY performance | Tom Lane | 20:22 |
| 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 |
|---|---|---|
| Memory issues | Shiran Kleiderman | 06:41 |
| Memory issues | Shiran Kleiderman | 06:45 |
| Re: Cost of opening and closing an empty transaction | Albe Laurenz | 09:48 |
| Postgres becoming slow, only full vacuum fixes it | Kiriakos Tsourapas | 10:33 |
| Re: Postgres becoming slow, only full vacuum fixes it | Kiriakos Tsourapas | 11:55 |
| Re: Postgres becoming slow, only full vacuum fixes it 📎 | Julien Cigar | 12:21 |
| Re: Postgres becoming slow, only full vacuum fixes it | MirrorX | 12:23 |
| Re: Postgres becoming slow, only full vacuum fixes it | Andres Freund | 12:34 |
| Re: Postgres becoming slow, only full vacuum fixes it 📎 | Julien Cigar | 12:53 |