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 |
|---|---|---|
| rtree/gist index taking enormous amount of space in 8.2.3 | Dolafi, Tom | 15:17 |
| Re: PostgreSQL Configuration Tool for Dummies | Josh Berkus | 18:02 |
| Re: Volunteer to build a configuration tool | Josh Berkus | 23:19 |
| Thread | Author | Time |
|---|---|---|
| Re: PostgreSQL 8.0 occasionally slow down | Ho Fat Tsang | 02:04 |
| Re: PostgreSQL 8.0 occasionally slow down | Richard Huxton | 09:21 |
| Re: PostgreSQL 8.0 occasionally slow down | Alvaro Herrera | 13:33 |
| Re: rtree/gist index taking enormous amount of space in 8.2.3 | Dolafi, Tom | 13:51 |
| Re: rtree/gist index taking enormous amount of space in 8.2.3 | Craig James | 16:14 |
| Re: rtree/gist index taking enormous amount of space in 8.2.3 | Tom Lane | 17:57 |
| Re: rtree/gist index taking enormous amount of space in 8.2.3 | Dolafi, Tom | 18:05 |
| Re: rtree/gist index taking enormous amount of space in 8.2.3 | Dolafi, Tom | 18:13 |
| Re: rtree/gist index taking enormous amount of space in 8.2.3 | Tom Lane | 18:30 |
| Re: rtree/gist index taking enormous amount of space in 8.2.3 | Tom Lane | 18:38 |
| Re: rtree/gist index taking enormous amount of space in 8.2.3 | Dolafi, Tom | 18:44 |
| Re: rtree/gist index taking enormous amount of space in 8.2.3 | Dolafi, Tom | 19:40 |
| Re: | Ed Tyrrill | 21:01 |
| Thread | Author | Time |
|---|---|---|
| [PERFORMANCE] is it possible to force an index to be held in memory? | valgog | 10:04 |
| slow query | Vidhya Bondre | 10:07 |
| Re: slow query | Nis Jørgensen | 13:20 |
| Re: PostgreSQL 8.0 occasionally slow down | Greg Smith | 22:21 |
| Join with lower/upper limits doesn't scale well | Craig James | 23:30 |
| Thread | Author | Time |
|---|---|---|
| Re: Filesystem Direct I/O and WAL sync option | Gregory Stark | 01:13 |
| Re: Delete Cascade FK speed issue | Axel Rau | 07:30 |
| Re: Filesystem Direct I/O and WAL sync option | Dimitri | 10:26 |
| Re: Filesystem Direct I/O and WAL sync option | Gregory Stark | 10:45 |
| Thread | Author | Time |
|---|---|---|
| Re: PostgreSQL Configuration Tool for Dummies | Magnus Hagander | 05:15 |
| Re: Filesystem Direct I/O and WAL sync option | Dimitri | 12:01 |
| improvement suggestions for performance design | tfinneid | 12:15 |
| Re: improvement suggestions for performance design | Heikki Linnakangas | 12:59 |
| Re: improvement suggestions for performance design | tfinneid | 13:35 |
| Re: improvement suggestions for performance design | Y Sidhu | 14:57 |
| Re: improvement suggestions for performance design | tfinneid | 15:49 |
| Re: improvement suggestions for performance design | Y Sidhu | 16:10 |
| Re: Query is taking 5 HOURS to Complete on 8.1 version | smiley2211 | 17:49 |
| Re: Query is taking 5 HOURS to Complete on 8.1 version | Alvaro Herrera | 18:05 |
| Re: improvement suggestions for performance design | Heikki Linnakangas | 18:39 |
| Re: improvement suggestions for performance design | Thomas Finneid | 22:23 |
| Thread | Author | Time |
|---|---|---|
| Direct I/O | lai yoke hman | 02:28 |
| Performance of PostgreSQL and Oracle | lai yoke hman | 02:44 |
| Re: Performance of PostgreSQL and Oracle | Tom Lane | 03:59 |
| Re: PostgreSQL Configuration Tool for Dummies | Harald Armin Massa | 04:25 |
| Re: improvement suggestions for performance design | Kalle Hallivuori | 11:30 |
| Re: Direct I/O | Alvaro Herrera | 14:40 |
| Advice about how to delete | Arnau | 14:42 |
| Re: Advice about how to delete | Michael Glaesemann | 15:04 |
| Re: Advice about how to delete | Arnau | 15:56 |
| Re: Direct I/O | Jignesh K. Shah | 16:03 |
| Re: Advice about how to delete | Heikki Linnakangas | 16:18 |
| Thread | Author | Time |
|---|---|---|
| Re: improvement suggestions for performance design | Thomas Finneid | 10:06 |
| Re: improvement suggestions for performance design | Kalle Hallivuori | 16:25 |
| Thread | Author | Time |
|---|---|---|
| Re: PostgreSQL publishes first real benchmark | Heiko W.Rupp | 08:00 |
| Re: Filesystem Direct I/O and WAL sync option | Dimitri | 12:53 |
| Query Analyser | Gauri Kanekar | 14:47 |
| tuning a function to insert/retrieve values from a reference table | Marc Mamin | 15:03 |
| Re: tuning a function to insert/retrieve values from a reference table | Tom Lane | 15:41 |
| Thread | Author | Time |
|---|---|---|
| Re: WALL on controller without battery? | Francisco Reyes | 00:26 |
| Estimating WAL volume | Greg Smith | 03:10 |
| Re: bitmap-index-scan slower than normal index scan | A. Kretschmer | 05:06 |
| pg_restore causes 100 | Craig James | 07:34 |
| Re: TRUNCATE TABLE | Adriaan van Os | 07:37 |
| one column from huge view | Marcin Stępnicki | 08:33 |
| Re: one column from huge view | Heikki Linnakangas | 08:50 |
| Re: Weird row estimate | Marc Cousin | 08:55 |
| Re: PostgreSQL publishes first real benchmark | Stefan Kaltenbrunner | 09:08 |
| Re: PostgreSQL publishes first real benchmark | Gregory Stark | 10:45 |
| Re: TIMING A QUERY ??? | smiley2211 | 12:39 |
| Re: one column from huge view | Michael Fuhr | 12:51 |
| Re: one column from huge view | Heikki Linnakangas | 12:55 |
| Re: pg_restore causes 100 | Tom Lane | 14:27 |
| Re: one column from huge view | Tom Lane | 14:48 |
| Re: PostgreSQL publishes first real benchmark | Greg Smith | 15:00 |
| Re: TRUNCATE TABLE | Tom Lane | 19:20 |
| Thread | Author | Time |
|---|---|---|
| Re: TRUNCATE TABLE | Adriaan van Os | 07:47 |
| Re: TRUNCATE TABLE | Gregory Stark | 09:02 |
| Re: TRUNCATE TABLE | Jean-Max Reymond | 09:05 |
| Re: TRUNCATE TABLE | Thomas Samson | 09:21 |
| Re: PostgreSQL publishes first real benchmark | Philippe Amelant | 09:56 |
| Re: PostgreSQL publishes first real benchmark | Ray Stell | 12:08 |
| Re: TRUNCATE TABLE | Michael Stone | 12:44 |
| Re: TRUNCATE TABLE | Tom Lane | 14:40 |