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: [pgadmin-support] 100% CPU | Mark Kirkwood | 06:25 |
| Re: FWD: Update touches unrelated indexes? | Jaime Casanova | 14:36 |
| optimizing LIKE '%2345' queries | Gene | 21:50 |
| Thread | Author | Time |
|---|---|---|
| Re: optimizing LIKE '%2345' queries | Mario Weilguni | 07:33 |
| Is postgresql ca do the job for software deployed in ASP ou SaaS mode? | David Gagnon | 11:41 |
| Re: Is postgresql ca do the job for software deployed in ASP ou SaaS mode? | Richard Broersma Jr | 17:00 |
| Re: Is postgresql ca do the job for software deployed in ASP ou SaaS mode? | Chris Hoover | 17:20 |
| Re: Is postgresql ca do the job for software deployed in | Craig A. James | 17:35 |
| query very slow when enable_seqscan=on | Tomasz Ostrowski | 20:31 |
| Re: query very slow when enable_seqscan=on | Simon Riggs | 23:05 |
| Re: query very slow when enable_seqscan=on | Tom Lane | 23:05 |
| Thread | Author | Time |
|---|---|---|
| Re: Is postgresql ca do the job for software deployed in ASP ou SaaS mode? | Guoping Zhang | 04:35 |
| Re: Is postgresql ca do the job for software deployed in ASP ou SaaS mode? | Mikael Carneholm | 08:03 |
| Re: query very slow when enable_seqscan=on | Tomasz Ostrowski | 08:37 |
| Re: optimizing LIKE '%2345' queries | Tarhon-Onu Victor | 11:14 |
| Re: Is postgresql ca do the job for software deployed in ASP | David Gagnon | 11:55 |
| Re: Is postgresql ca do the job for software deployed in ASP ou SaaS mode? | Mikael Carneholm | 13:05 |
| Re: Is postgresql ca do the job for software deployed in ASP | David Gagnon | 13:33 |
| Re: query very slow when enable_seqscan=on | Tom Lane | 13:56 |
| Re: query very slow when enable_seqscan=on | Tomasz Ostrowski | 14:44 |
| how to tune this query. | Luckys | 16:00 |
| Re: how to tune this query. | Nolan Cafferky | 16:18 |
| Re: query very slow when enable_seqscan=on | tomas | 16:24 |
| Re: query very slow when enable_seqscan=on | Tom Lane | 18:15 |
| Re: optimizing LIKE '%2345' queries | Gene | 20:27 |
| Thread | Author | Time |
|---|---|---|
| Re: VACUUM vs. REINDEX | William Scott Jordan | 00:02 |
| Re: VACUUM vs. REINDEX | Jeff Frost | 00:22 |
| Re: VACUUM vs. REINDEX | William Scott Jordan | 00:48 |
| Re: VACUUM vs. REINDEX | Joshua D. Drake | 01:15 |
| Re: VACUUM vs. REINDEX | Chris Hoover | 01:28 |
| Re: VACUUM vs. REINDEX | Joshua D. Drake | 03:24 |
| Re: VACUUM vs. REINDEX | Steinar H. Gunderson | 08:13 |
| Re: VACUUM vs. REINDEX | Stefan Kaltenbrunner | 09:16 |
| Thread | Author | Time |
|---|---|---|
| Re: Opteron/FreeBSD/PostgreSQL performance poor | Merlin Moncure | 14:47 |
| Thread | Author | Time |
|---|---|---|
| High CPU Usage - PostgreSQL 7.3 | Neil Hepworth | 00:52 |
| Re: High CPU Usage - PostgreSQL 7.3 | Jeff Frost | 01:24 |
| Re: High CPU Usage - PostgreSQL 7.3 | Neil Hepworth | 07:55 |
| Re: High CPU Usage - PostgreSQL 7.3 | Neil Hepworth | 09:12 |
| Re: suggested RAID controller for FreeBSD 6.1 + PostgreSQL 8.1 | Vivek Khera | 14:52 |
| Re: High CPU Usage - PostgreSQL 7.3 | Jeff Frost | 15:26 |
| Re: High CPU Usage - PostgreSQL 7.3 | Scott Marlowe | 16:04 |
| Thread | Author | Time |
|---|---|---|
| Kill a session | Craig A. James | 05:50 |
| Re: Kill a session | Tino Wildenhain | 07:39 |
| Re: Kill a session | Magnus Hagander | 11:39 |
| Unsubscribe | Jghaffou | 20:18 |
| Thread | Author | Time |
|---|---|---|
| Re: [Fwd: Delivery Status Notification (Failure)] | Richard Broersma Jr | 00:54 |
| Re: size of pg_dump files containing bytea values | Tom Lane | 02:53 |
| Re: hyper slow after upgrade to 8.1.4 | Bruno Wolff III | 02:53 |
| Re: [Fwd: Delivery Status Notification (Failure)] | Tom Lane | 03:07 |
| Re: Commit slower on faster PC | Koth, Christian (DWBI) | 08:59 |
| Re: Sun Donated a Sun Fire T2000 to the PostgreSQL | Tatsuo Ishii | 09:02 |
| Re: hyper slow after upgrade to 8.1.4 | Medora Schauer | 13:22 |
| Re: hyper slow after upgrade to 8.1.4 | Michael Fuhr | 13:54 |
| Re: Sun Donated a Sun Fire T2000 to the PostgreSQL | Tom Lane | 14:44 |
| Re: size of pg_dump files containing bytea values | Greg Stark | 16:30 |
| Re: hyper slow after upgrade to 8.1.4 | Tom Lane | 17:11 |
| Re: size of pg_dump files containing bytea values | Tom Lane | 17:42 |
| Re: hyper slow after upgrade to 8.1.4 | Medora Schauer | 18:25 |
| Re: Problem with bitmap-index-scan plan | Tom Lane | 22:32 |
| Thread | Author | Time |
|---|---|---|
| Re: Kill a session | Mark Kirkwood | 01:30 |
| Re: Kill a session | Craig A. James | 02:17 |
| Re: Kill a session | Craig A. James | 02:23 |
| Re: Kill a session | Tom Lane | 05:50 |
| Re: size of pg_dump files containing bytea values | Florian Weimer | 07:05 |
| Re: Kill a session | Markus Schaber | 11:28 |
| Re: Kill a session | Craig A. James | 15:17 |
| Re: Kill a session | Tom Lane | 16:25 |
| Self-join query and index usage | worky.workerson | 18:56 |
| Re: Self-join query and index usage | Tom Lane | 19:19 |
| Thread | Author | Time |
|---|---|---|
| Big differences in plans between 8.0 and 8.1 | Gabriele Turchi | 14:14 |
| Re: increment Rows in an SQL Result Set postgresql | Craig A. James | 17:27 |
| increment Rows in an SQL Result Set postgresql | Hassan Adekoya | 17:46 |
| Re: increment Rows in an SQL Result Set postgresql | Hassan | 18:53 |
| Re: Big differences in plans between 8.0 and 8.1 | Michael Fuhr | 19:02 |
| Re: Big differences in plans between 8.0 and 8.1 | Gabriele Turchi | 19:55 |
| Re: Big differences in plans between 8.0 and 8.1 | Joe Conway | 20:04 |
| Re: Big differences in plans between 8.0 and 8.1 | Gabriele Turchi | 20:22 |
| Re: increment Rows in an SQL Result Set postgresql | Peter Eisentraut | 23:53 |
| Thread | Author | Time |
|---|---|---|
| Re: Big differences in plans between 8.0 and 8.1 | Joe Conway | 18:08 |
| RAID stripe size question | Mikael Carneholm | 22:52 |
| Re: RAID stripe size question | Steinar H. Gunderson | 23:10 |
| Thread | Author | Time |
|---|---|---|
| Re: RAID stripe size question | Michael Stone | 00:03 |
| Re: RAID stripe size question | Alex Turner | 06:13 |
| Re: RAID stripe size question | Mikael Carneholm | 08:00 |
| Re: RAID stripe size question | Markus Schaber | 09:47 |
| Re: RAID stripe size question | Mikael Carneholm | 11:33 |
| Re: RAID stripe size question | Markus Schaber | 11:40 |
| Re: RAID stripe size question | Mikael Carneholm | 12:52 |
| Re: RAID stripe size question | Ron Peacetree | 13:40 |
| Re: RAID stripe size question | Steinar H. Gunderson | 14:51 |
| Re: RAID stripe size question | Alex Turner | 15:23 |
| Re: Big differences in plans between 8.0 and 8.1 | Chris Hoover | 20:19 |
| Re: RAID stripe size question | Mikael Carneholm | 21:16 |
| Thread | Author | Time |
|---|---|---|
| Re: RAID stripe size question | Mark Kirkwood | 00:22 |
| Re: RAID stripe size question | Ron Peacetree | 03:07 |
| Re: RAID stripe size question | Alex Turner | 04:21 |
| Temporary table retains old contents on update eventually causing slow temp file usage. | Rusty Conover | 06:42 |
| Re: Temporary table retains old contents on update eventually causing slow temp file usage. | Rusty Conover | 06:56 |
| Re: Big differences in plans between 8.0 and 8.1 | Gabriele Turchi | 07:25 |
| Re: Problem with bitmap-index-scan plan | Kapadaidakis Yannis | 09:25 |
| Re: Temporary table retains old contents on update eventually | Gavin Sherry | 12:22 |
| Re: RAID stripe size question | Ron Peacetree | 12:32 |
| Re: RAID stripe size question | Mikael Carneholm | 13:34 |
| Re: Query plan issue when upgrading to postgres 8.14 (from | Ioana Danes | 16:02 |
| Re: Temporary table retains old contents on update eventually causing slow temp file usage. | Rusty Conover | 17:12 |
| Re: RAID stripe size question | Luke Lonergan | 18:56 |