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: Simple join doesn't use index | Jeff Janes | 04:34 |
| Re: FW: performance issue with a 2.5gb joinded table | Vladimir Sitnikov | 09:30 |
| Re: Simple join doesn't use index | Alex Vinnik | 15:49 |
| Re: Simple join doesn't use index | Merlin Moncure | 15:53 |
| Thread | Author | Time |
|---|---|---|
| Re: Two Necessary Kernel Tweaks for Linux Systems | Henri Philipps | 08:51 |
| Slow query after upgrade from 9.0 to 9.2 | Andrzej Zawadzki | 13:32 |
| Re: Two Necessary Kernel Tweaks for Linux Systems | Shaun Thomas | 15:53 |
| Updates on one row causing ExclusiveLock on PostgreSQL 8.3.5 | PostgreSQL | 18:01 |
| Updates on one row causing ExclusiveLock on PostgreSQL 8.3.5 | PostgreSQL | 18:04 |
| Re: Slow query after upgrade from 9.0 to 9.2 | Jeff Janes | 18:17 |
| Partition insert trigger using C language | Matheus de Oliveira | 18:45 |
| Re: Slow query after upgrade from 9.0 to 9.2 | Matheus de Oliveira | 18:48 |
| Re: Partition insert trigger using C language | Heikki Linnakangas | 18:54 |
| Re: Partition insert trigger using C language | Matheus de Oliveira | 19:11 |
| Re: Partition insert trigger using C language | Pavel Stehule | 19:14 |
| Re: Partition insert trigger using C language | Heikki Linnakangas | 19:22 |
| Re: Partition insert trigger using C language | Matheus de Oliveira | 19:48 |
| Re: Partition insert trigger using C language | Charles Gomes | 19:57 |
| Thread | Author | Time |
|---|---|---|
| Re: [PERFORM] Slow query: bitmap scan troubles 📎 | Tom Lane | 01:07 |
| Re: Slow query after upgrade from 9.0 to 9.2 | Andrzej Zawadzki | 08:13 |
| Re: Slow query after upgrade from 9.0 to 9.2 | Andrzej Zawadzki | 08:23 |
| Re: Partition insert trigger using C language | Heikki Linnakangas | 10:19 |
| Re: Partition insert trigger using C language | Matheus de Oliveira | 10:36 |
| Re: Partition insert trigger using C language | Matheus de Oliveira | 10:57 |
| Re: Partition insert trigger using C language | Heikki Linnakangas | 11:02 |
| Re: Partition insert trigger using C language | Matheus de Oliveira | 11:55 |
| Re: Slow query after upgrade from 9.0 to 9.2 | Jeff Janes | 17:12 |
| Insert performance for large transaction with multiple COPY FROM | Horst Dehmer | 23:55 |
| Thread | Author | Time |
|---|---|---|
| Insert performance for large transaction with multiple COPY FROM | Jeff Janes | 01:17 |
| Re: Insert performance for large transaction with multiple COPY FROM | Claudio Freire | 01:17 |
| Re: Insert performance for large transaction with multiple COPY FROM | Horst Dehmer | 20:16 |
| Re: Insert performance for large transaction with multiple COPY FROM | Jeff Janes | 21:23 |
| Re: Insert performance for large transaction with multiple COPY FROM | Claudio Freire | 22:18 |
| Re: Insert performance for large transaction with multiple COPY FROM | Tom Lane | 22:26 |
| Re: Insert performance for large transaction with multiple COPY FROM | Horst Dehmer | 22:41 |
| Thread | Author | Time |
|---|---|---|
| Re: Insert performance for large transaction with multiple COPY FROM | Claudio Freire | 01:52 |
| From TODO: Simplify creation of partitioned tables | Alexandre de Arruda Paes | 21:49 |
| Thread | Author | Time |
|---|---|---|
| Re: serious under-estimation of n_distinct for clustered distributions | Stefan Andreatta | 07:35 |
| Re: serious under-estimation of n_distinct for clustered distributions | Peter Geoghegan | 11:34 |
| Re: Two Necessary Kernel Tweaks for Linux Systems | Boszormenyi Zoltan | 14:28 |
| Re: [PERFORM] Slow query: bitmap scan troubles | Robert Haas | 16:45 |
| Re: [PERFORM] Slow query: bitmap scan troubles | Tom Lane | 17:23 |
| Re: [PERFORM] Slow query: bitmap scan troubles | Robert Haas | 17:50 |
| Re: [PERFORM] Slow query: bitmap scan troubles | Tom Lane | 17:56 |
| Re: Partition table in 9.0.x? | Jeff Janes | 18:24 |
| Thread | Author | Time |
|---|---|---|
| Re: [PERFORM] Slow query: bitmap scan troubles | Bruce Momjian | 19:46 |
| Re: [PERFORM] Slow query: bitmap scan troubles | Tom Lane | 20:11 |
| Re: Insert performance for large transaction with multiple COPY FROM | Horst Dehmer | 23:44 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance on Bulk Insert to Partitioned Table | Ali Pouya | 14:38 |
| Re: Performance on Bulk Insert to Partitioned Table | Charles Gomes | 15:01 |
| Re: Performance on Bulk Insert to Partitioned Table | Ali Pouya | 16:03 |
| Re: Insert performance for large transaction with multiple COPY FROM | Jeff Janes | 18:12 |
| Thread | Author | Time |
|---|---|---|
| Re: Insert performance for large transaction with multiple COPY FROM | Horst Dehmer | 23:15 |
| Thread | Author | Time |
|---|---|---|
| High CPU usage after partitioning | rudi | 15:05 |
| Analyze and default_statistics_target | AJ Weber | 15:29 |
| Re: Analyze and default_statistics_target | Heikki Linnakangas | 15:47 |
| Re: Analyze and default_statistics_target | Albe Laurenz | 16:00 |
| Re: High CPU usage after partitioning | Merlin Moncure | 17:13 |
| Re: High CPU usage after partitioning | Kevin Grittner | 21:12 |
| Thread | Author | Time |
|---|---|---|
| Re: High CPU usage after partitioning | Andrew Dunstan | 00:41 |
| Re: High CPU usage after partitioning | rudi | 13:34 |
| Re: High CPU usage after partitioning | Merlin Moncure | 14:04 |
| Re: High CPU usage after partitioning | rudi | 14:21 |
| Re: High CPU usage after partitioning | Andrew Dunstan | 14:46 |
| Re: High CPU usage after partitioning | rudi | 15:08 |
| Re: High CPU usage after partitioning | Igor Neyman | 15:42 |
| Re: High CPU usage after partitioning | Tom Lane | 18:38 |
| Effect of the WindowAgg on the Nested Loop | Виктор Егоров | 20:57 |
| Thread | Author | Time |
|---|---|---|
| autovacuum fringe case? | AJ Weber | 16:53 |
| Re: autovacuum fringe case? | Evgeniy Shishkin | 19:03 |
| Re: autovacuum fringe case? | Jeff Janes | 19:13 |
| Re: autovacuum fringe case? | Kevin Grittner | 22:17 |
| Re: autovacuum fringe case? | AJ Weber | 22:48 |
| Thread | Author | Time |
|---|---|---|
| Re: autovacuum fringe case? | Alvaro Herrera | 02:03 |
| Re: autovacuum fringe case? | Jeff Janes | 03:06 |
| Thread | Author | Time |
|---|---|---|
| DML's to tpcw benchmark for postgresql | Sachin D. Kotwal | 06:38 |
| Nested loop and simple join query - slow after upgrade to 9.2 | alexandre - aldeia digital | 15:34 |
| Re: Nested loop and simple join query - slow after upgrade to 9.2 | Jeff Janes | 18:29 |
| Re: Nested loop and simple join query - slow after upgrade to 9.2 | alexandre - aldeia digital | 19:30 |
| Thread | Author | Time |
|---|---|---|
| PostgreSQL over internet | belal hamed | 00:15 |
| Re: PostgreSQL over internet | [email protected] | 02:45 |
| Re: [PERFORM] pgbench to the MAXINT 📎 | Satoshi Nagayasu | 04:24 |
| Re: PostgreSQL over internet | Richard Neill | 06:13 |
| Re: PostgreSQL over internet | belal hamed | 12:09 |
| Re: PostgreSQL over internet | [email protected] | 17:33 |
| Re: PostgreSQL over internet | David Rowley | 20:23 |
| Thread | Author | Time |
|---|---|---|
| Re: PostgreSQL over internet | belal hamed | 11:15 |
| Triggers and transactions | Craig James | 18:54 |
| Re: Triggers and transactions | Richard Huxton | 19:10 |
| Re: Triggers and transactions | Rosser Schwarz | 19:25 |
| Re: [PERFORM] pgbench to the MAXINT | Gurjeet Singh | 21:30 |
| Re: Simple join doesn't use index | Alex Vinnik | 23:43 |
| Thread | Author | Time |
|---|---|---|
| Re: Simple join doesn't use index | Filip Rembiałkowski | 00:55 |
| Re: Simple join doesn't use index | Merlin Moncure | 02:31 |
| Re: [PERFORM] pgbench to the MAXINT | Heikki Linnakangas | 10:12 |
| Re: Simple join doesn't use index | Alex Vinnik | 14:24 |
| Re: Simple join doesn't use index | Alex Vinnik | 14:41 |
| Re: Simple join doesn't use index | Filip Rembiałkowski | 16:19 |
| Re: Simple join doesn't use index | Merlin Moncure | 16:41 |
| Re: Simple join doesn't use index | Ben Chobot | 17:39 |
| Re: Simple join doesn't use index | Alex Vinnik | 18:59 |
| Re: Simple join doesn't use index | Merlin Moncure | 19:35 |
| Re: Simple join doesn't use index | Jeff Janes | 20:06 |
| Re: Simple join doesn't use index | Alex Vinnik | 20:43 |
| Re: Simple join doesn't use index | Alex Vinnik | 20:48 |
| Re: Simple join doesn't use index | Jeff Janes | 23:15 |
| Thread | Author | Time |
|---|---|---|
| Fighting the planner >:-( | Casey Allen Shobe | 17:11 |
| Re: Fighting the planner >:-( | Casey Allen Shobe | 17:54 |
| Re: Fighting the planner >:-( | Richard Huxton | 18:50 |
| Re: Fighting the planner >:-( | Casey Allen Shobe | 19:18 |
| Re: Fighting the planner >:-( | Casey Allen Shobe | 21:02 |
| Re: Fighting the planner >:-( | Виктор Егоров | 21:12 |
| Re: Fighting the planner >:-( | Casey Allen Shobe | 21:18 |
| Re: Fighting the planner >:-( | Виктор Егоров | 21:55 |
| Re: Fighting the planner >:-( | Casey Allen Shobe | 22:03 |
| Re: Fighting the planner >:-( | Виктор Егоров | 22:17 |
| Thread | Author | Time |
|---|---|---|
| Re: Simple join doesn't use index | Jeff Janes | 16:39 |
| Thread | Author | Time |
|---|---|---|
| Re: Simple join doesn't use index | Dan Fairs | 21:14 |
| numerical primary key vs alphanumerical primary key | Anne Rosset | 21:52 |
| Re: numerical primary key vs alphanumerical primary key | Виктор Егоров | 21:57 |
| Thread | Author | Time |
|---|---|---|
| Slow Query Help | Will Platnick | 03:45 |
| Re: Slow Query Help | Heikki Linnakangas | 13:58 |
| postgresql.conf recommendations | Johnny Tan | 22:02 |
| Re: postgresql.conf recommendations | Josh Krupka | 22:37 |
| Re: postgresql.conf recommendations | Johnny Tan | 23:46 |
| Thread | Author | Time |
|---|---|---|
| Re: postgresql.conf recommendations | Josh Krupka | 04:23 |
| Re: postgresql.conf recommendations | Pavan Deolasee | 06:00 |
| Re: postgresql.conf recommendations | [email protected] | 06:18 |
| Re: Slow Query Help | Pavan Deolasee | 08:51 |
| Re: postgresql.conf recommendations | Kevin Grittner | 12:49 |
| Re: Slow Query Help | Will Platnick | 13:17 |
| Re: postgresql.conf recommendations | David Whittaker | 15:42 |
| Re: Slow Query Help | Kevin Grittner | 16:22 |
| Re: Slow Query Help | Will Platnick | 16:24 |
| Re: Slow Query Help | Pavan Deolasee | 16:27 |
| Re: postgresql.conf recommendations | Josh Krupka | 18:20 |
| Re: postgresql.conf recommendations | David Whittaker | 19:13 |
| Re: postgresql.conf recommendations | Johnny Tan | 19:33 |
| Re: postgresql.conf recommendations | Johnny Tan | 19:45 |
| Re: postgresql.conf recommendations | Johnny Tan | 19:47 |
| Re: postgresql.conf recommendations | Jeff Janes | 20:12 |
| Re: postgresql.conf recommendations | Josh Krupka | 20:27 |
| Re: postgresql.conf recommendations | Kevin Grittner | 21:12 |
| Thread | Author | Time |
|---|---|---|
| Re: postgresql.conf recommendations | Strahinja Kustudić | 12:06 |
| Re: postgresql.conf recommendations | Charles Gomes | 14:41 |
| Re: postgresql.conf recommendations | Johnny Tan | 17:29 |
| Re: postgresql.conf recommendations | Josh Krupka | 17:49 |
| Thread | Author | Time |
|---|---|---|
| FTS performance issue probably due to wrong planner estimate of detoasting | Stefan Keller | 00:52 |
| Re: FTS performance issue probably due to wrong planner estimate of detoasting | Pavel Stehule | 05:45 |
| Re: FTS performance issue probably due to wrong planner estimate of detoasting | Jesper Krogh | 06:56 |
| Slow query even with aggressive auto analyze | Karolis Pocius | 12:36 |
| Re: FTS performance issue probably due to wrong planner estimate of detoasting | Stefan Keller | 17:30 |
| temp tablespaces and SSDs, etc.. | Jon Nelson | 20:52 |
| Query Time is Slow | Foster, Kristian B (HSC) | 22:13 |
| Re: Query Time is Slow | Kevin Grittner | 22:45 |
| Thread | Author | Time |
|---|---|---|
| Re: postgresql.conf recommendations | Johnny Tan | 13:19 |
| Re: postgresql.conf recommendations | Johnny Tan | 13:24 |
| Re: postgresql.conf recommendations | Scott Marlowe | 14:51 |
| Re: postgresql.conf recommendations | Josh Krupka | 19:37 |
| Re: postgresql.conf recommendations | Jeff Janes | 20:16 |
| Re: postgresql.conf recommendations | Scott Marlowe | 21:03 |
| Thread | Author | Time |
|---|---|---|
| Re: postgresql.conf recommendations | Jeff Janes | 04:02 |
| Re: Slow query even with aggressive auto analyze | Amit kapila | 06:52 |
| Thread | Author | Time |
|---|---|---|
| Is it correct to optimize a query with subselect in the "where"? | Alexandre Riveira | 12:52 |
| Re: postgresql.conf recommendations | Charles Gomes | 14:57 |
| Re: Partition insert trigger using C language | Ali Pouya | 15:24 |
| Re: postgresql.conf recommendations | Johnny Tan | 22:10 |
| Re: postgresql.conf recommendations | Scott Marlowe | 22:57 |
| Re: postgresql.conf recommendations | Will Platnick | 23:29 |
| Thread | Author | Time |
|---|---|---|
| Re: postgresql.conf recommendations | Scott Marlowe | 02:54 |
| Re: numerical primary key vs alphanumerical primary key | Julien Cigar | 13:06 |
| Re: numerical primary key vs alphanumerical primary key | Grant Johnson | 15:05 |
| Re: numerical primary key vs alphanumerical primary key | Florent Guillaume | 15:14 |
| Re: numerical primary key vs alphanumerical primary key | Claudio Freire | 16:26 |
| High CPU usage / load average after upgrading to Ubuntu 12.04 | Dan Kogan | 17:25 |
| Re: High CPU usage / load average after upgrading to Ubuntu 12.04 | Dan Kogan | 19:59 |
| Thread | Author | Time |
|---|---|---|
| Re: High CPU usage / load average after upgrading to Ubuntu 12.04 | Dan Kogan | 01:28 |
| Re: Partition insert trigger using C language | Matheus de Oliveira | 11:00 |
| connection poolers' db connections | Yetkin Öztürk | 13:47 |
| Re: connection poolers' db connections | Kevin Grittner | 14:56 |
| Re: connection poolers' db connections | Yetkin Öztürk | 15:35 |
| Re: High CPU usage / load average after upgrading to Ubuntu 12.04 | Josh Berkus | 19:24 |