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 |
|---|---|---|
| Effects of IDLE processes | JM | 10:15 |
| Re: Degradation of postgres 7.4.5 on FreeBSD/CygWin | Steinar H. Gunderson | 14:08 |
| Re: Effects of IDLE processes | Tom Lane | 14:16 |
| Re: Degradation of postgres 7.4.5 on FreeBSD/CygWin | Tom Lane | 14:32 |
| Re: Degradation of postgres 7.4.5 on FreeBSD/CygWin | Steinar H. Gunderson | 14:40 |
| Re: RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin | Christopher Kings-Lynne | 14:51 |
| Re: RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin | Christopher Kings-Lynne | 14:52 |
| Degradation of postgres 7.4.5 on FreeBSD/CygWin | Rodrigo Moreno | 14:54 |
| Re: RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin | Tom Lane | 14:59 |
| Re: win32 performance - fsync question | Merlin Moncure | 15:11 |
| RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin | Rodrigo Moreno | 15:43 |
| RES: RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin | Rodrigo Moreno | 16:10 |
| Re: PostgreSQL clustering VS MySQL clustering | Gaetano Mendola | 23:20 |
| Re: PostgreSQL clustering VS MySQL clustering | Gaetano Mendola | 23:27 |
| Thread | Author | Time |
|---|---|---|
| Re: seq scan cache vs. index cache smackdown | Bruce Momjian | 04:11 |
| Help me please ! | Asatryan, Anahit | 11:05 |
| Thread | Author | Time |
|---|---|---|
| bad performances using hashjoin | Gaetano Mendola | 12:20 |
| RES: RES: Degradation of postgres 7.4.5 on FreeBSD/CygWin | Rodrigo Moreno | 13:02 |
| Problem with 7.4.5 and webmin 1.8 in grant function | amrit | 15:49 |
| Re: seq scan cache vs. index cache smackdown | Magnus Hagander | 18:25 |
| Re: bad performances using hashjoin | Tom Lane | 18:46 |
| Re: Problem with 7.4.5 and webmin 1.8 in grant function | Mark Kirkwood | 22:58 |
| Thread | Author | Time |
|---|---|---|
| Re: bad performances using hashjoin | Gaetano Mendola | 00:45 |
| Re: Effects of IDLE processes | Gaetano Mendola | 00:50 |
| Re: bad performances using hashjoin | Klint Gore | 01:30 |
| Re: Problem with 7.4.5 and webmin 1.8 in grant function | amrit | 01:34 |
| Re: bad performances using hashjoin | Tom Lane | 02:01 |
| Re: bad performances using hashjoin | David Brown | 03:01 |
| Re: Effects of IDLE processes | Christopher Browne | 03:18 |
| Re: bad performances using hashjoin | Tom Lane | 03:48 |
| Re: bad performances using hashjoin | Gaetano Mendola | 11:17 |
| Re: Effects of IDLE processes | Gaetano Mendola | 11:23 |
| Re: bad performances using hashjoin | David Brown | 14:03 |
| Re: seq scan cache vs. index cache smackdown | Merlin Moncure | 14:03 |
| Re: seq scan cache vs. index cache smackdown | Tom Lane | 16:27 |
| Re: bad performances using hashjoin | Mischa | 17:11 |
| Re: Problem with 7.4.5 and webmin 1.8 in grant function | Mark Kirkwood | 21:16 |
| Re: Problem with 7.4.5 and webmin 1.8 in grant function 📎 | Mark Kirkwood | 21:51 |
| Thread | Author | Time |
|---|---|---|
| Re: seq scan cache vs. index cache smackdown | Ron Mayer | 01:14 |
| Re: Problem with 7.4.5 and webmin 1.8 in grant function | amrit | 05:00 |
| Re: Problem with 7.4.5 and webmin 1.8 in grant function | Mark Kirkwood | 05:45 |
| join vs. subquery | David Haas | 06:47 |
| subquery vs join on 7.4.5 | David Haas | 07:05 |
| PostgreSQL is extremely slow on Windows | Vig, Sandor (G/FI-2) | 14:58 |
| PostgreSQL is extremely slow on Windows | Vig, Sandor (G/FI-2) | 15:00 |
| Re: Problem with 7.4.5 and webmin 1.8 in grant function | amrit | 15:37 |
| Re: PostgreSQL is extremely slow on Windows | Mitch Pirtle | 16:30 |
| Re: PostgreSQL is extremely slow on Windows | Magnus Hagander | 18:15 |
| is pg_autovacuum so effective ? | Gaetano Mendola | 19:47 |
| Re: Problem with 7.4.5 and webmin 1.8 in grant function | Mark Kirkwood | 20:07 |
| Re: is pg_autovacuum so effective ? | Matthew T. O'Connor | 20:58 |
| Re: is pg_autovacuum so effective ? | Tom Lane | 21:28 |
| Inefficient Query Plans | Luke Chambers | 22:08 |
| Re: VACUUM ANALYZE slows down query | Tom Lane | 23:08 |
| Thread | Author | Time |
|---|---|---|
| Re: Peformance Tuning Opterons/ Hard Disk Layout | Christopher Browne | 03:24 |
| Re: Peformance Tuning Opterons/ Hard Disk Layout | Vig, Sandor (G/FI-2) | 08:28 |
| Re: is pg_autovacuum so effective ? | Gaetano Mendola | 10:58 |
| Re: is pg_autovacuum so effective ? | Markus Schaber | 12:13 |
| Re: Peformance Tuning Opterons/ Hard Disk Layout | Bruno Almeida do Lago | 13:28 |
| Peformance Tuning Opterons/ Hard Disk Layout | John Allgood | 18:31 |
| Re: Peformance Tuning Opterons/ Hard Disk Layout | Joel Fradkin | 19:12 |
| Re: Peformance Tuning Opterons/ Hard Disk Layout | John Arbash Meinel | 19:40 |
| Re: PostgreSQL is extremely slow on Windows | Bruce Momjian | 21:25 |
| Re: is pg_autovacuum so effective ? | Gaetano Mendola | 22:30 |
| Thread | Author | Time |
|---|---|---|
| Re: PostgreSQL is extremely slow on Windows | Greg Stark | 05:02 |
| gah! sudden slowdown?? | SpaceBallOne | 07:41 |
| IS NULL vs IS NOT NULL 📎 | Vig, Sandor (G/FI-2) | 10:10 |
| Re: Peformance Tuning Opterons/ Hard Disk Layout | Vig, Sandor (G/FI-2) | 11:19 |
| Re: gah! sudden slowdown?? | Steinar H. Gunderson | 11:19 |
| Possible interesting extra information for explain analyze? | Jeff | 13:49 |
| Re: IS NULL vs IS NOT NULL | Stephan Szabo | 14:56 |
| Re: Possible interesting extra information for explain analyze? | Tom Lane | 16:05 |
| Re: Peformance Tuning Opterons/ Hard Disk Layout | Jim C. Nasby | 16:20 |
| Re: is pg_autovacuum so effective ? | Markus Schaber | 16:28 |
| Thread | Author | Time |
|---|---|---|
| PostgreSQL 7.4.3 Performance issues on OpenBSD | Glenn Kusardi | 12:13 |
| Thread | Author | Time |
|---|---|---|
| Re: Possible interesting extra information for explain | Simon Riggs | 20:25 |
| PG block sizes | Tom Arthurs | 22:32 |
| Thread | Author | Time |
|---|---|---|
| Re: Peformance Tuning Opterons/ Hard Disk Layout | Markus Schaber | 08:10 |
| Re: is pg_autovacuum so effective ? | Matthew T. O'Connor | 14:30 |
| Re: is pg_autovacuum so effective ? | Markus Schaber | 15:46 |
| Re: is pg_autovacuum so effective ? | Bruno Wolff III | 18:38 |
| wal_sync_methods | Stefan Hans | 21:23 |
| Re: High end server and storage for a PostgreSQL OLTP system | Cosimo Streppone | 21:47 |
| Re: High end server and storage for a PostgreSQL OLTP system | Tom Lane | 22:15 |
| Inheritence versus delete from | Sven Willenberger | 23:59 |
| Thread | Author | Time |
|---|---|---|
| Re: Help with tuning this query (with explain analyze finally) | John Arbash Meinel | 00:22 |
| Re: name search query speed | William Yu | 02:55 |
| Re: Help with tuning this query (with explain analyze finally) | Ken Egervari | 05:22 |
| Query's fast standalone - slow as a subquery. | Ron Mayer | 11:27 |
| Re: Query's fast standalone - slow as a subquery. | Tom Lane | 15:22 |
| Re: name search query speed | stig erikson | 15:46 |
| Re: Help with tuning this query (with explain analyze finally) | Richard Huxton | 15:56 |
| Re: Help with tuning this query (with explain analyze finally) | Ken | 16:36 |
| Re: Help with tuning this query (with explain analyze finally) | John Arbash Meinel | 16:56 |