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: planner/optimizer question | Tom Lane | 01:19 |
| Re: Insert only tables and vacuum performance | Tom Lane | 03:04 |
| Re: Wierd context-switching issue on Xeon | Robert Creager | 04:03 |
| Re: planner/optimizer question | Jochem van Dieten | 11:18 |
| Re: planner/optimizer question | Gary Doades | 12:48 |
| Re: planner/optimizer question | Tom Lane | 16:21 |
| Re: Wierd context-switching issue on Xeon | Dave Cramer | 18:50 |
| Thread | Author | Time |
|---|---|---|
| Re: planner/optimizer question | Manfred Koizar | 08:03 |
| Recommended File System Configuration | James Thornton | 08:11 |
| Re: planner/optimizer question | Jochem van Dieten | 14:30 |
| Re: Wierd context-switching issue on Xeon | Robert Creager | 15:20 |
| Re: Wierd context-switching issue on Xeon | Dave Cramer | 15:39 |
| Re: Wierd context-switching issue on Xeon | Robert Creager | 21:46 |
| Thread | Author | Time |
|---|---|---|
| Bug in optimizer | Timo Nentwig | 16:08 |
| Re: Recommended File System Configuration | Chris Browne | 16:38 |
| INSERT RULE | Pailloncy Jean-Gérard | 20:58 |
| Thread | Author | Time |
|---|---|---|
| cache table | Joseph Shraibman | 02:24 |
| Re: linux distro for better pg performance | Joseph Shraibman | 02:30 |
| Re: linux distro for better pg performance | Alan Stange | 03:03 |
| Re: linux distro for better pg performance | James Thornton | 03:41 |
| Re: linux distro for better pg performance | Greg Stark | 06:03 |
| Re: Fwd: FreeBSD, PostgreSQL, semwait and sbwait! | Mark Kirkwood | 07:39 |
| Re: INSERT RULE | Pailloncy Jean-Gérard | 10:13 |
| Re: linux distro for better pg performance | Aaron Werman | 12:06 |
| Re: cache table | scott.marlowe | 13:52 |
| Re: cache table | Joseph Shraibman | 15:27 |
| Re: Bug in optimizer | Bruno Wolff III | 16:36 |
| Re: cache table | Greg Stark | 18:14 |
| pg_stat | Litao Wu | 18:44 |
| Adapting Oracle S.A.M.E. Methodology for Postgres | James Thornton | 19:34 |
| Re: Recommended File System Configuration | James Thornton | 19:38 |
| Re: Horribly slow hash join | Greg Stark | 22:15 |
| very high CPU usage in "top", but not in "mpstat" | Cyrille Bonnet | 23:34 |
| Thread | Author | Time |
|---|---|---|
| Re: very high CPU usage in "top", but not in "mpstat" | Tom Lane | 13:03 |
| Re: History of oids in postgres? | Bruce Momjian | 17:03 |
| Re: Bug in optimizer | Gaetano Mendola | 17:31 |
| Re: LIKE and INDEX | Rod Taylor | 17:31 |
| Re: LIKE and INDEX | Richard Huxton | 18:12 |
| Re: very high CPU usage in "top", but not in "mpstat" | Paul Tuckfield | 18:13 |
| Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL | J. Andrew Rogers | 21:11 |
| Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL | scott.marlowe | 21:23 |
| Thread | Author | Time |
|---|---|---|
| Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL | Christopher Kings-Lynne | 01:48 |
| Re: [OFF-TOPIC] - Known maximum size of the PostgreSQL | Richard Huxton | 08:13 |
| Re: [PERFORM] [OFF-TOPIC] - Known maximum size of the PostgreSQL | Shridhar Daithankar | 08:43 |
| Re: [PERFORM] MySQL vs PG TPC-H benchmarks | Grega Bremec | 08:59 |
| Re: [OFF-TOPIC] - Known maximum size of the | Don Vaillancourt | 13:47 |
| Re: pg_stat | Litao Wu | 15:44 |
| Re: INSERT RULE | Richard Huxton | 18:10 |
| Re: [PERFORM] [OFF-TOPIC] - Known maximum size of | Gavin Sherry | 22:29 |
| Thread | Author | Time |
|---|---|---|
| Help how to tune-up my Database | Michael Ryan S. Puncia | 11:07 |
| Re: Help how to tune-up my Database | scott.marlowe | 16:00 |
| Re: Help how to tune-up my Database | Bricklen | 16:47 |
| Re: [OFF-TOPIC] - Known maximum size of the | Gaetano Mendola | 23:35 |
| Thread | Author | Time |
|---|---|---|
| Why queries takes too much time to execute? | Anderson Boechat Lopes | 14:00 |
| Re: Why queries takes too much time to execute? | Shridhar Daithankar | 14:21 |
| Re: Why queries takes too much time to execute? | Christopher Kings-Lynne | 14:24 |
| Re: Why queries takes too much time to execute? | Anderson Boechat Lopes | 17:36 |
| Re: Why queries takes too much time to execute? | Chris Browne | 18:11 |
| Configuring PostgreSQL to minimize impact of checkpoints | jao | 18:52 |
| Re: Configuring PostgreSQL to minimize impact of checkpoints | Bruce Momjian | 19:09 |
| Re: Why queries takes too much time to execute? | scott.marlowe | 19:59 |
| Re: Help how to tune-up my Database | scott.marlowe | 20:23 |
| Re: Help how to tune-up my Database | Bricklen | 20:37 |
| Thread | Author | Time |
|---|---|---|
| Re: [PERFORM] Quad processor options - summary | Paul Tuckfield | 00:51 |
| R: R: Query plan on identical tables differs . Why ? | Fabio Panizzutti | 08:40 |
| R: R: Query plan on identical tables differs . Why ? | Fabio Panizzutti | 08:55 |
| R: R: Query plan on identical tables differs . Why ? | Fabio Panizzutti | 09:22 |
| Re: R: R: Query plan on identical tables differs . Why ? | Christopher Kings-Lynne | 09:55 |
| Re: [PERFORM] Quad processor options - summary | Mark Kirkwood | 10:17 |
| R: R: R: Query plan on identical tables differs . Why ? | Fabio Panizzutti | 10:30 |
| TPCH 100GB - need some help | Eduardo Almeida | 18:00 |
| numeric data types | Jaime Casanova | 21:08 |
| Re: TPCH 100GB - need some help | Rod Taylor | 21:40 |
| Thread | Author | Time |
|---|---|---|
| Re: numeric data types | Tom Lane | 04:03 |
| filesystem option tuning | share-postgres | 10:52 |
| Re: TPCH 100GB - need some help | Tom Lane | 16:00 |
| Thread | Author | Time |
|---|---|---|
| Re: numeric data types | Neil Conway | 02:27 |
| Thread | Author | Time |
|---|---|---|
| Re: filesystem option tuning | Richard Huxton | 17:04 |
| Hardware Platform | Duane Lee - EGOVX | 23:08 |
| Thread | Author | Time |
|---|---|---|
| Re: TPCH 100GB - need some help | Eduardo Almeida | 12:49 |
| Interpreting vmstat | Doug Y | 18:12 |
| where to find out when a table was last analyzed? | Litao Wu | 21:13 |
| Thread | Author | Time |
|---|---|---|
| Re: Using LIKE expression problem.. | Joseph Shraibman | 02:51 |
| Re: Quad processor options | Marty Scholes | 03:38 |
| Re: filesystem option tuning | share-postgres | 07:32 |
| DB Design | Michael Ryan S. Puncia | 07:37 |
| Re: DB Design | Andrew McMillan | 11:21 |
| shared buffer size on linux | Joseph Shraibman | 19:26 |
| PostgreSQL performance in simple queries | Eugeny Balakhonov | 20:07 |
| Re: PostgreSQL performance in simple queries | Gary Doades | 20:23 |
| Re: PostgreSQL performance in simple queries | Neil Conway | 21:51 |
| Thread | Author | Time |
|---|---|---|
| PostgreSQL caching | Vitaly Belman | 14:42 |
| Re: PostgreSQL caching | Rosser Schwarz | 15:29 |
| Re: PostgreSQL caching | Richard Huxton | 15:34 |
| Avoiding vacuum full on an UPDATE-heavy table | Bill Montgomery | 15:59 |
| Re: PostgreSQL caching | Chris Browne | 17:22 |
| Re: PostgreSQL caching | Vitaly Belman | 17:33 |
| Re: PostgreSQL caching | Rod Taylor | 18:33 |
| Re: PostgreSQL caching | Neil Conway | 19:02 |
| Re: Avoiding vacuum full on an UPDATE-heavy table | Matthew T. O'Connor | 19:22 |
| Re: PostgreSQL caching | Marty Scholes | 20:10 |
| Re: Avoiding vacuum full on an UPDATE-heavy table | Vivek Khera | 20:36 |
| Re: Avoiding vacuum full on an UPDATE-heavy table | Bill Montgomery | 21:29 |
| Re: Avoiding vacuum full on an UPDATE-heavy table | Tom Lane | 22:09 |
| tuning for AIX 5L with large memory | Dan Harris | 23:23 |
| Thread | Author | Time |
|---|---|---|
| Re: tuning for AIX 5L with large memory | Christopher Browne | 01:28 |
| Re: tuning for AIX 5L with large memory | Neil Conway | 02:31 |
| Re: PostgreSQL caching | Vitaly Belman | 22:22 |
| Thread | Author | Time |
|---|---|---|
| Re: tuning for AIX 5L with large memory | Dan Harris | 03:30 |
| Thread | Author | Time |
|---|---|---|
| index's relpages after table analyzed | Litao Wu | 16:51 |
| Re: index's relpages after table analyzed | Litao Wu | 17:20 |