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: Direct I/O issues | Bruce Momjian | 04:06 |
| Re: Postgres scalability and performance on windows | Guido Neitzer | 08:22 |
| Re: Postgres scalability and performance on windows | Gopal | 10:11 |
| TPC-H Benchmark | Felipe Rondon Rocha | 14:47 |
| Re: TPC-H Benchmark | Luke Lonergan | 16:30 |
| Re: Postgres scalability and performance on windows | Frank Wiles | 17:04 |
| Massive delete of rows, how to proceed? | Arnau | 18:43 |
| Re: [PERFORM] Direct I/O issues 📎 | Bruce Momjian | 18:58 |
| Re: [PERFORM] Direct I/O issues | Tom Lane | 19:08 |
| Re: [HACKERS] [PERFORM] Direct I/O issues | Bruce Momjian | 23:43 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgres scalability and performance on windows | Tom Lane | 00:10 |
| Massive delete of rows, how to proceed? | Peter Childs | 15:45 |
| Thread | Author | Time |
|---|---|---|
| Re: Massive delete of rows, how to proceed? | andrew | 00:35 |
| When to vacuum a table? | Joost Kraaijeveld | 11:24 |
| Re: When to vacuum a table? | Marcelo Costa | 12:43 |
| Re: When to vacuum a table? | Steinar H. Gunderson | 13:11 |
| Re: When to vacuum a table? | Marcelo Costa | 13:46 |
| Re: When to vacuum a table? | Rod Taylor | 14:24 |
| Re: When to vacuum a table? | Andrew Sullivan | 14:33 |
| Re: When to vacuum a table? | Craig A. James | 16:26 |
| BUG #2784: Performance serious degrades over a period of a month | Michael Simms | 16:35 |
| Re: When to vacuum a table? | Tom Lane | 17:06 |
| Re: When to vacuum a table? | Joshua D. Drake | 17:47 |
| Re: shared_buffers > 284263 on OS X | Jim C. Nasby | 23:25 |
| Re: availability of SATA vendors | Jim C. Nasby | 23:30 |
| Re: availability of SATA vendors | Jim C. Nasby | 23:33 |
| Re: Postgres server crash | Jim C. Nasby | 23:41 |
| Thread | Author | Time |
|---|---|---|
| Re: Priority to a mission critical transaction | Jim C. Nasby | 00:51 |
| Re: When to vacuum a table? | Jim C. Nasby | 01:01 |
| Re: shared_buffers > 284263 on OS X | Brendan Duddridge | 03:20 |
| Re: shared_buffers > 284263 on OS X | Tom Lane | 04:04 |
| Re: shared_buffers > 284263 on OS X | Brian Wipf | 04:10 |
| Re: shared_buffers > 284263 on OS X | Guido Neitzer | 07:04 |
| Re: shared_buffers > 284263 on OS X | Guido Neitzer | 07:04 |
| Re: shared_buffers > 284263 on OS X | Brian Wipf | 07:23 |
| Re: shared_buffers > 284263 on OS X | Guido Neitzer | 07:35 |
| Plattform comparison (lies, damn lies and benchmarks) | Guido Neitzer | 08:08 |
| Re: Massive delete of rows, how to proceed? | Merlin Moncure | 08:44 |
| Re: shared_buffers > 284263 on OS X | Jim C. Nasby | 09:22 |
| Re: Postgres server crash | Michael Stone | 13:20 |
| Re: shared_buffers > 284263 on OS X | AgentM | 16:05 |
| Re: shared_buffers > 284263 on OS X | Guido Neitzer | 16:21 |
| Re: Postgres server crash | Florian Weimer | 18:11 |
| Re: When to vacuum a table? | Kevin Grittner | 18:59 |
| Thread | Author | Time |
|---|---|---|
| Re: BUG #2784: Performance serious degrades over a period of a month | Tom Lane | 02:59 |
| Re: BUG #2784: Performance serious degrades over a period of a month | Bruno Wolff III | 04:26 |
| Re: BUG #2784: Performance serious degrades over a period of a month | Heikki Linnakangas | 11:08 |
| Re: BUG #2784: Performance serious degrades over a period | Bill Moran | 11:34 |
| Re: Postgres scalability and performance on windows | Gopal | 12:22 |
| Re: Postgres scalability and performance on windows | Tom Lane | 16:24 |
| Re: Postgres scalability and performance on windows | J. Andrew Rogers | 16:51 |
| RES: Priority to a mission critical transaction | Carlos H. Reimer | 19:01 |
| Re: RES: Priority to a mission critical transaction | Tom Lane | 19:07 |
| Re: RES: Priority to a mission critical transaction | Andreas Kostyrka | 19:20 |
| Re: RES: Priority to a mission critical transaction | Josh Berkus | 19:45 |
| Re: RES: Priority to a mission critical transaction | Ron Mayer | 20:31 |
| Re: RES: Priority to a mission critical transaction | Bruce Momjian | 23:44 |
| Thread | Author | Time |
|---|---|---|
| Re: RES: Priority to a mission critical transaction | Josh Berkus | 04:29 |
| Defining performance. | Paul Lathrop | 22:59 |
| Thread | Author | Time |
|---|---|---|
| Re: Defining performance. | Tobias Brox | 00:05 |
| Re: Defining performance. | Tom Lane | 00:26 |
| Re: Defining performance. | nospam | 00:37 |
| Re: Defining performance. | Scott Marlowe | 00:43 |
| Bad iostat numbers | Carlos H. Reimer | 00:44 |
| Re: Defining performance. | Jeff Davis | 00:57 |
| Re: Defining performance. | Tobias Brox | 01:07 |
| Re: Defining performance. | Tobias Brox | 01:15 |
| Re: Bad iostat numbers | Mark Kirkwood | 01:47 |
| Re: Bad iostat numbers | David Boreham | 02:24 |
| Re: Bad iostat numbers | Mark Kirkwood | 03:00 |
| Re: Defining performance. | Chris | 03:32 |
| Re: Defining performance. | Tobias Brox | 04:03 |
| Re: NAMEDATALEN and performance | Alessandro Baretta | 08:55 |
| Re: Defining performance. | Heikki Linnakangas | 10:36 |
| RES: Bad iostat numbers | Carlos H. Reimer | 14:29 |
| RES: Bad iostat numbers | Carlos H. Reimer | 14:47 |
| Re: NAMEDATALEN and performance | Tom Lane | 15:16 |
| Re: RES: Bad iostat numbers | David Boreham | 15:32 |
| Performance of Perc 5i | Alex Turner | 16:34 |
| Re: Performance of Perc 5i | Bucky Jordan | 17:06 |
| Thread | Author | Time |
|---|---|---|
| Dump performance problems following server crash | Kim | 15:50 |
| Re: Dump performance problems following server crash | Tom Lane | 17:13 |
| Re: Dump performance problems following server crash | Kim | 17:29 |
| Regex performance issue | Alexandru Coseru | 19:00 |
| Re: Regex performance issue | Dave Dutcher | 20:36 |
| Re: Regex performance issue | Alexandru Coseru | 20:48 |
| Re: Regex performance issue | Oleg Bartunov | 20:54 |
| Re: Regex performance issue | Heikki Linnakangas | 22:04 |
| Re: Regex performance issue | Alexandru Coseru | 22:13 |
| Re: Regex performance issue | Heikki Linnakangas | 22:35 |
| Thread | Author | Time |
|---|---|---|
| Re: shared_buffers > 284263 on OS X | Brian Wipf | 00:06 |
| max/min and index usage | Tobias Brox | 03:01 |
| Re: max/min and index usage | Tobias Brox | 03:17 |
| Re: max/min and index usage | Tom Lane | 03:29 |
| Re: max/min and index usage | Tobias Brox | 03:35 |
| Re: Hardware advice | Alex Turner | 04:24 |
| Re: Bad iostat numbers | Greg Smith | 04:54 |
| Re: Restart time | Rajesh Kumar Mallah | 06:20 |
| Locking in PostgreSQL? | Joost Kraaijeveld | 07:04 |
| Re: Locking in PostgreSQL? | Markus Schiltknecht | 07:11 |
| Re: Restart time | Jean Arnaud | 08:44 |
| Re: Hardware advice | Sven Geisler | 09:09 |
| Re: Hardware advice | Gregory S. Williamson | 09:21 |
| Re: [PERFORM] Locking in PostgreSQL? | Dave Cramer | 12:29 |
| Re: [PERFORM] Locking in PostgreSQL? | Jens Schipkowski | 13:20 |