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: [PERFORM] encouraging index-only scans | Bruce Momjian | 03:22 |
| Thread | Author | Time |
|---|---|---|
| Re: PostgreSQL 9.3.2 Performance tuning for 32 GB server | Tom Kincaid | 23:52 |
| Thread | Author | Time |
|---|---|---|
| Re: [PERFORM] encouraging index-only scans | Robert Haas | 16:55 |
| Planner estimates and VACUUM/autovacuum | Artur Zając CFI | 18:57 |
| Planner estimates and VACUUM/autovacuum | Artur Zając | 19:29 |
| Re: Planner estimates and VACUUM/autovacuum | Tom Lane | 21:03 |
| Postgres Query Plan Live Lock | Pweaver (Paul Weaver) | 21:35 |
| Thread | Author | Time |
|---|---|---|
| Re: [PERFORM] encouraging index-only scans | Jeff Janes | 00:14 |
| Re: Re: Increased memory utilization by pgsql backend after upgrade from 9.1.3 to 9.2.6 | Claudio Freire | 01:32 |
| Re: Postgres Query Plan Live Lock | Peter Geoghegan | 02:03 |
| increasing query time after analyze | Katharina Koobs | 11:50 |
| Re: increasing query time after analyze | Pavel Stehule | 12:15 |
| Postgres Query Plan Live Lock | Jeff Janes | 14:52 |
| Re: increasing query time after analyze | Claudio Freire | 15:28 |
| Re: Postgres Query Plan Live Lock | bricklen | 16:39 |
| Re: Postgres Query Plan Live Lock | Pweaver (Paul Weaver) | 19:36 |
| Re: Postgres Query Plan Live Lock | Pweaver (Paul Weaver) | 19:47 |
| Re: [PERFORM] encouraging index-only scans | Robert Haas | 21:19 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgres Query Plan Live Lock | Claudio Freire | 02:42 |
| Thread | Author | Time |
|---|---|---|
| Bloated tables and why is vacuum full the only option | Claudio Freire | 18:47 |
| Thread | Author | Time |
|---|---|---|
| Performance Benchmarking for data-warehousing instance? | Huy Nguyen | 03:36 |
| Re: Performance Benchmarking for data-warehousing instance? | Peter Geoghegan | 04:12 |
| Re: Performance Benchmarking for data-warehousing instance? | Huy Nguyen | 06:41 |
| Re: Performance Benchmarking for data-warehousing instance? | Wattana Hinchaisri | 08:24 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance Benchmarking for data-warehousing instance? | Tomas Vondra | 15:42 |
| Re: Bloated tables and why is vacuum full the only option | Tomas Vondra | 15:50 |
| Re: Bloated tables and why is vacuum full the only option | Claudio Freire | 19:13 |
| Re: Bloated tables and why is vacuum full the only option | Tom Lane | 19:40 |
| Re: Bloated tables and why is vacuum full the only option | Claudio Freire | 19:48 |
| Re: Bloated tables and why is vacuum full the only option | Sergey Konoplev | 22:32 |
| Re: Bloated tables and why is vacuum full the only option | Claudio Freire | 22:58 |
| Re: Bloated tables and why is vacuum full the only option | Sergey Konoplev | 23:29 |
| Thread | Author | Time |
|---|---|---|
| Strange performance boost with random() | M Putz | 19:52 |
| Re: Strange performance boost with random() | Heikki Linnakangas | 20:03 |