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 |
|---|---|---|
| [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 |
| Re: TRUNCATE TABLE | Adriaan van Os | 16:17 |
| Re: TRUNCATE TABLE | Steinar H. Gunderson | 16:29 |
| Re: TRUNCATE TABLE | Tom Lane | 16:30 |
| Database Statistics??? | smiley2211 | 16:53 |
| Re: TRUNCATE TABLE | Jim C. Nasby | 17:12 |
| Re: TRUNCATE TABLE | Alvaro Herrera | 17:35 |
| Re: Database Statistics??? | Tom Arthurs | 17:39 |
| Re: Database Statistics??? | Ansgar -59cobalt- Wiechers | 17:52 |
| Re: Database Statistics??? | Mario Weilguni | 18:19 |
| Re: Database Statistics??? | smiley2211 | 18:27 |
| Re: TRUNCATE TABLE | Pavel Stehule | 19:12 |
| Re: TRUNCATE TABLE | Adriaan van Os | 19:32 |
| Re: Database Statistics??? | Alvaro Herrera | 21:05 |
| Thread | Author | Time |
|---|---|---|
| Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950 | Hannes Dorbath | 08:29 |
| Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950 | Steinar H. Gunderson | 08:34 |
| Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950 | Gregory Stark | 09:57 |
| Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950 | Hannes Dorbath | 10:19 |
| Vacuum full considered useful ;) | Patric de Waha | 15:50 |
| Re: Vacuum full considered useful ;) | Joshua D. Drake | 16:25 |
| Re: Vacuum full considered useful ;) | Tom Lane | 16:32 |
| Re: Vacuum full considered useful ;) | Guillaume Lelarge | 16:34 |
| Thread | Author | Time |
|---|---|---|
| Re: Vacuum full considered useful ;) | Vivek Khera | 02:26 |
| slony over LAN and VPN | angga erwina | 16:37 |
| slony over VPN and LAN | angga erwina | 16:41 |
| Thread | Author | Time |
|---|---|---|
| Re: Estimating WAL volume | Simon Riggs | 08:02 |
| Re: FORGOT TO CONFIGURE RAID! DELL POWEREDGE 2950 | Jim C. Nasby | 21:02 |
| Re: TRUNCATE TABLE | Jim C. Nasby | 21:39 |