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: Talking about optimizer, my long dream | Robert Haas | 17:59 |
| Re: Bad query plan when the wrong data type is used | Robert Haas | 18:16 |
| Re: Indexes with condition using immutable functions applied to column not used | Robert Haas | 18:21 |
| Re: Bad query plan when the wrong data type is used | Tom Lane | 18:39 |
| Re: Talking about optimizer, my long dream | Віталій Тимчишин | 22:20 |
| Thread | Author | Time |
|---|---|---|
| Performance trouble finding records through related records | sverhagen | 00:14 |
| Re: Performance trouble finding records through related records | Andy Colson | 03:41 |
| Re: Pushing IN (subquery) down through UNION ALL? | Robert Haas | 14:08 |
| Re: Pushing IN (subquery) down through UNION ALL? | Thom Brown | 14:11 |
| Re: Pushing IN (subquery) down through UNION ALL? | Robert Haas | 14:22 |
| Re: Pushing IN (subquery) down through UNION ALL? | Thom Brown | 14:23 |
| Re: Anyone tried Flashcache with PostgreSQL? | Robert Haas | 15:29 |
| Re: Query on view radically slower than query on underlying table | Robert Haas | 15:39 |
| Re: Vacuum problem due to temp tables | Robert Haas | 15:44 |
| Re: Performance Test for PostgreSQL9 | Robert Haas | 18:19 |
| Re: Performance Test for PostgreSQL9 | Joshua D. Drake | 18:29 |
| Thread | Author | Time |
|---|---|---|
| Re: Calculating 95th percentiles | Pierre C | 07:54 |
| Table partitioning | Tobias Brox | 09:37 |
| Re: Table partitioning | Mark Thornton | 09:57 |
| Re: Table partitioning | Mark Thornton | 09:59 |
| Re: Table partitioning | Tobias Brox | 10:09 |
| Thread | Author | Time |
|---|---|---|
| Re: Calculating 95th percentiles | marcin mank | 00:34 |
| Re: Linux I/O schedulers - CFQ & random seeks | Omar Kilani | 00:38 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance issues | Tom Lane | 00:38 |
| How to tune this query | Adarsh Sharma | 05:01 |
| Re: How to tune this query | Jaiswal Dhaval Sudhirkumar | 06:24 |
| Re: Performance issues | Andreas Forø Tollefsen | 08:42 |
| Re: Performance trouble finding records through related records | sverhagen | 11:17 |
| Re: Performance trouble finding records through related records | sverhagen | 11:31 |
| Re: Performance issues | Andy Colson | 15:21 |
| Table partitioning problem | Samba GUEYE | 15:45 |
| Re: Performance issues | Andreas Forø Tollefsen | 16:58 |
| Re: Performance issues | Andreas Forø Tollefsen | 17:00 |
| Re: Linux I/O schedulers - CFQ & random seeks | Mindaugas Riauba | 18:27 |
| Re: Performance issues | Andy Colson | 19:13 |
| Re: Query performance with disabled hashjoin and mergejoin | Robert Haas | 20:57 |
| Re: Query performance with disabled hashjoin and mergejoin | Tom Lane | 21:24 |
| Re: Query performance with disabled hashjoin and mergejoin | Merlin Moncure | 21:56 |
| Thread | Author | Time |
|---|---|---|
| Re: Query performance with disabled hashjoin and mergejoin | Robert Haas | 16:48 |
| Re: Table partitioning problem | Jim Nasby | 22:01 |
| Re: Slow join on partitioned table | Conor Walsh | 22:42 |
| Re: NULLS LAST performance | Jim Nasby | 23:01 |
| Thread | Author | Time |
|---|---|---|
| Re: Table partitioning problem | Samba GUEYE | 08:25 |
| Basic performance tuning on dedicated server | runner | 09:12 |
| Re: Performance trouble finding records through related records | sverhagen | 14:10 |
| Tuning massive UPDATES and GROUP BY's? | fork | 15:40 |
| Re: NULLS LAST performance | Robert Haas | 15:55 |
| unexpected stable function behavior | Julius Tuskenis | 16:26 |
| Re: NULLS LAST performance | Merlin Moncure | 16:32 |
| Re: Tuning massive UPDATES and GROUP BY's? | Merlin Moncure | 16:45 |
| Re: Basic performance tuning on dedicated server | Merlin Moncure | 18:02 |
| Re: Tuning massive UPDATES and GROUP BY's? | fork | 18:04 |
| Re: unexpected stable function behavior | Merlin Moncure | 21:14 |
| big joins not converging | Dan Ancona | 21:25 |
| Re: big joins not converging | Steve Atkins | 22:13 |
| Re: Tuning massive UPDATES and GROUP BY's? | Marti Raudsepp | 22:42 |
| Re: big joins not converging | fork | 23:48 |
| Thread | Author | Time |
|---|---|---|
| Re: big joins not converging | Dan Ancona | 00:43 |
| Re: NULLS LAST performance | Robert Haas | 04:36 |
| ANTI-JOIN needs table, index scan not possible? | hans wulf | 15:32 |
| Re: big joins not converging | fork | 16:46 |
| Re: ANTI-JOIN needs table, index scan not possible? | Maciek Sakrejda | 17:18 |
| Re: ANTI-JOIN needs table, index scan not possible? | hans wulf | 17:54 |
| Re: Table partitioning problem | Robert Haas | 18:31 |
| Re: Tuning massive UPDATES and GROUP BY's? | fork | 19:06 |
| Re: ANTI-JOIN needs table, index scan not possible? | Kenneth Marshall | 22:16 |
| Re: ANTI-JOIN needs table, index scan not possible? | Kevin Grittner | 22:32 |
| Thread | Author | Time |
|---|---|---|
| Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1 | John Surcombe | 10:07 |
| Re: Tuning massive UPDATES and GROUP BY's? | Marti Raudsepp | 17:07 |
| Thread | Author | Time |
|---|---|---|
| Re: Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1 | Jeremy | 12:21 |
| Re: Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1 | Tom Lane | 16:24 |
| Re: Tuning massive UPDATES and GROUP BY's? | runner | 16:36 |
| Re: Planner wrongly shuns multi-column index for select .. order by col1, col2 limit 1 | Tom Lane | 22:10 |
| Thread | Author | Time |
|---|---|---|
| Re: Bug in the planner? | Tom Lane | 00:56 |
| Re: unexpected stable function behavior | Julius Tuskenis | 08:04 |
| Re: unexpected stable function behavior | Julius Tuskenis | 08:12 |
| Re: Table partitioning problem | Samba GUEYE | 10:10 |
| Re: Index use difference betweer LIKE, LIKE ANY? 📎 | Chetan Suttraway | 12:30 |
| Re: Table partitioning problem | Shaun Thomas | 13:18 |
| pg_xlog size | Tech Madhu | 15:09 |
| Re: Table partitioning problem | Samba GUEYE | 15:19 |
| Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 | Timothy Garnett | 18:23 |
| Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 | Timothy Garnett | 18:39 |
| Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 | Timothy Garnett | 18:42 |
| Thread | Author | Time |
|---|---|---|
| big distinct clause vs. group by | Uwe Bartels | 08:45 |
| Help with Query Tuning | Adarsh Sharma | 09:13 |
| Custom operator class costs | Ben Beecher | 14:10 |
| Re: Help with Query Tuning | Kenneth Marshall | 16:36 |
| Re: Adding additional index causes 20,000x slowdown for certain select queries - postgres 9.0.3 | Kevin Grittner | 16:40 |