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: FreeBSD config | Mark Kirkwood | 07:30 |
| Re: FreeBSD config | Dror Matalon | 07:39 |
| Re: FreeBSD config | Mark Kirkwood | 08:19 |
| Re: compiling 7.4.1 on Solaris 9 | Andrew Sullivan | 14:34 |
| Scaling further up | Anjan Dave | 15:35 |
| Re: Slow query | scott.marlowe | 16:26 |
| Re: WAL Optimisation - configuration and usage | Rob Fielding | 17:30 |
| Re: Scaling further up | Magnus Hagander | 20:54 |
| Re: Scaling further up | Anjan Dave | 21:02 |
| Thread | Author | Time |
|---|---|---|
| Re: Scaling further up | Paul Thomas | 00:52 |
| Re: Feature request: smarter use of conditional indexes | Christopher Kings-Lynne | 01:31 |
| Re: Bulk INSERT performance in 7.4.1 | Florian Weimer | 10:06 |
| Re: Scaling further up | Aaron W | 13:57 |
| Re: Scaling further up | Anjan Dave | 15:57 |
| Re: Scaling further up | scott.marlowe | 17:12 |
| Thread | Author | Time |
|---|---|---|
| Fixed width rows faster? | Jeff | 13:35 |
| Re: Fixed width rows faster? | Bill Moran | 14:07 |
| Re: Fixed width rows faster? | Dennis Bjorklund | 14:31 |
| Re: Fixed width rows faster? | Josh Berkus | 23:28 |
| Re: Fixed width rows faster? | Josh Berkus | 23:37 |
| Re: Fixed width rows faster? | Mike Nolan | 23:43 |
| Re: Fixed width rows faster? | Rod Taylor | 23:54 |
| Thread | Author | Time |
|---|---|---|
| Re: Fixed width rows faster? | Christopher Kings-Lynne | 04:20 |
| Re: Fixed width rows faster? | Mike Nolan | 04:32 |
| Re: Fixed width rows faster? | Tom Lane | 05:42 |
| Re: Fixed width rows faster? | Tom Lane | 05:53 |
| Re: Fixed width rows faster? | Christopher Kings-Lynne | 10:01 |
| Re: Fixed width rows faster? | Eric Jain | 13:17 |
| Re: Fixed width rows faster? | Andrew Sullivan | 16:26 |
| Re: Feature request: smarter use of conditional indexes | John Siracusa | 20:51 |
| Re: Fixed width rows faster? | Tom Lane | 20:52 |
| Re: Feature request: smarter use of conditional indexes | Tom Lane | 21:06 |
| Re: Feature request: smarter use of conditional indexes | John Siracusa | 21:55 |
| Thread | Author | Time |
|---|---|---|
| Re: Fixed width rows faster? | Mike Nolan | 01:16 |
| Re: Fixed width rows faster? | Rod Taylor | 01:22 |
| Re: Fixed width rows faster? | Neil Conway | 01:32 |
| Re: Fixed width rows faster? | Mike Nolan | 02:26 |
| Re: Feature request: smarter use of conditional indexes | John Siracusa | 02:29 |
| Re: Feature request: smarter use of conditional indexes | Larry Rosenman | 02:39 |
| Re: Fixed width rows faster? | Rod Taylor | 03:01 |
| Re: Feature request: smarter use of conditional indexes | Tom Lane | 03:46 |
| speeding up a select with C function? | David Teran | 11:42 |
| Re: Fixed width rows faster? | Dennis Bjorklund | 13:42 |
| Re: Fixed width rows faster? | Andrew Sullivan | 14:49 |
| Re: speeding up a select with C function? | Rod Taylor | 15:02 |
| Thread | Author | Time |
|---|---|---|
| Using bigint needs explicit cast to use the index | Steven Butler | 00:26 |
| Re: Using bigint needs explicit cast to use the index | Neil Conway | 00:43 |
| Re: speeding up a select with C function? | Christopher Kings-Lynne | 01:29 |
| Re: speeding up a select with C function? | Dennis Bjorklund | 06:22 |
| simple query join | Chris Smith | 06:57 |
| Re: simple query join | Steven Butler | 07:11 |
| Re: simple query join | Dennis Bjorklund | 07:47 |
| Re: Fixed width rows faster? | Eric Jain | 09:39 |
| Re: Using bigint needs explicit cast to use the index | Andrew Sullivan | 16:05 |
| Re: Using bigint needs explicit cast to use the index | Neil Conway | 16:22 |
| Re: Using bigint needs explicit cast to use the index | Bruno Wolff III | 16:33 |
| Re: Scaling further up | William Yu | 16:40 |
| Re: Using bigint needs explicit cast to use the index | Andrew Sullivan | 16:46 |
| Re: Feature request: smarter use of conditional indexes | Bruce Momjian | 17:55 |
| Re: simple query join | Chris Smith | 21:43 |
| Re: [PERFORM] WAL Optimisation - configuration and usage | Simon Riggs | 23:28 |
| Thread | Author | Time |
|---|---|---|
| [OT] Respository [was Re: [PERFORM] Feature request: smarter use of conditional indexes] | Shridhar Daithankar | 07:02 |
| Re: speeding up a select with C function? | David Teran | 09:54 |
| Re: speeding up a select with C function? | David Teran | 12:02 |
| Re: speeding up a select with C function? | Christopher Kings-Lynne | 14:46 |
| Re: speeding up a select with C function? | Tom Lane | 15:37 |
| Re: [OT] Respository [was Re: [PERFORM] Feature request: smarter | Bruce Momjian | 17:46 |
| Re: [OT] Respository [was Re: [PERFORM] Feature request: | Joe Conway | 18:48 |
| Cluster and vacuum performance | Shea,Dan [CIS] | 20:17 |
| Re: [HACKERS] WAL Optimisation - configuration and usage | Simon Riggs | 20:26 |
| syslog slowing the database? | Greg Spiegelberg | 20:29 |
| Re: [PERFORM] syslog slowing the database? | Richard Huxton | 21:34 |
| Re: Cluster and vacuum performance | Josh Berkus | 22:20 |
| Re: Cluster and vacuum performance | Tom Lane | 22:57 |
| Re: Cluster and vacuum performance | Tom Lane | 23:30 |
| Thread | Author | Time |
|---|---|---|
| Re: optimizing large query with IN (...) | Joseph Shraibman | 00:41 |
| Re: Postgresql on SAN | Joseph Shraibman | 00:43 |
| Re: [PERFORM] syslog slowing the database? | Christopher Kings-Lynne | 01:34 |
| Re: [PERFORM] syslog slowing the database? | Chris Smith | 01:37 |
| Re: [PERFORM] syslog slowing the database? | Bruno Wolff III | 02:03 |
| Re: [PERFORM] syslog slowing the database? | Tom Lane | 04:09 |
| started Data Warehousing | Pablo Marrero | 13:54 |
| Re: [PERFORM] syslog slowing the database? 📎 | Joshua D. Drake | 14:55 |
| Re: [PERFORM] started Data Warehousing 📎 | Joshua D. Drake | 14:55 |
| Re: [PERFORM] started Data Warehousing | brew | 15:08 |
| Impact of varchar/text in use of indexes | Mike Moran | 18:25 |
| Re: compiling 7.4.1 on Solaris 9 | Andrew Sullivan | 18:29 |
| Re: Impact of varchar/text in use of indexes | Tom Lane | 19:02 |
| Thread | Author | Time |
|---|---|---|
| severe performance issue with planner | Eric Brown | 01:47 |
| Re: severe performance issue with planner | Christopher Kings-Lynne | 02:42 |
| Re: severe performance issue with planner | Tom Lane | 04:07 |
| Sorting when LEFT JOINING to 2 same tables, even aliased. | Octavio Alvarez | 05:41 |
| Re: Sorting when LEFT JOINING to 2 same tables, even | Stephan Szabo | 06:09 |
| Re: optimizing large query with IN (...) | Josh Berkus | 17:39 |
| Re: severe performance issue with planner | Greg Stark | 18:00 |
| Re: severe performance issue with planner | Greg Stark | 18:14 |
| pg_xlog on same drive as OS | mallah | 19:12 |
| Re: pg_xlog on same drive as OS | Josh Berkus | 20:03 |
| Re: pg_xlog on same drive as OS | Christopher Browne | 20:52 |
| Re: Scaling further up | Robert Treat | 23:01 |
| Re: Scaling further up | Anjan Dave | 23:25 |
| Thread | Author | Time |
|---|---|---|
| rapid degradation after postmaster restart | Joe Conway | 01:38 |
| Re: rapid degradation after postmaster restart | Marty Scholes | 02:51 |
| Re: rapid degradation after postmaster restart | Tom Lane | 04:02 |
| Re: rapid degradation after postmaster restart | Tom Lane | 15:39 |
| Re: rapid degradation after postmaster restart | Joe Conway | 15:51 |
| Re: rapid degradation after postmaster restart | Joe Conway | 16:03 |
| Re: rapid degradation after postmaster restart | Joe Conway | 16:07 |
| Re: rapid degradation after postmaster restart | Josh Berkus | 16:51 |
| Re: rapid degradation after postmaster restart | Matthew T. O'Connor | 17:33 |
| Re: High CPU with 7.4.1 after running for about 2 weeks | Tom Lane | 23:17 |
| Thread | Author | Time |
|---|---|---|
| Re: High CPU with 7.4.1 after running for about 2 weeks | Mike Bridge | 03:10 |
| Re: severe performance issue with planner | Kris Jurka | 03:48 |
| Re: Drop Tables Very Slow in Postgresql 7.2.1 | Andrew Sullivan | 15:52 |
| Re: [ADMIN] syslog slowing the database? | Andrew Sullivan | 16:00 |
| Large CASE-statement is pretty slow? | Arjen van der Meijden | 19:33 |
| Re: Large CASE-statement is pretty slow? | Tom Lane | 21:09 |
| Deadlocks... 📎 | postgres | 21:43 |
| Re: Scaling further up | Aaron Werman | 22:11 |
| Re: Large CASE-statement is pretty slow? | Arjen van der Meijden | 23:21 |
| Thread | Author | Time |
|---|---|---|
| Re: [PERFORM] syslog slowing the database? | scott.marlowe | 15:17 |
| Re: [PERFORM] syslog slowing the database? | Bruce Momjian | 15:38 |
| Re: [PERFORM] syslog slowing the database? | scott.marlowe | 15:57 |