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 |
|---|---|---|
| do temporary tables have hint bits? | Jon Nelson | 13:53 |
| Re: do temporary tables have hint bits? | Tom Lane | 14:57 |
| Re: temporary tables, indexes, and query plans | Tom Lane | 15:41 |
| Re: temporary tables, indexes, and query plans | Jon Nelson | 16:14 |
| Re: anti-join chosen even when slower than old plan | bricklen | 16:15 |
| Re: temporary tables, indexes, and query plans | Tom Lane | 16:42 |
| Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? | Marti Raudsepp | 17:38 |
| Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? | Tom Lane | 18:01 |
| Re: MVCC performance issue | Mladen Gogala | 18:38 |
| Thread | Author | Time |
|---|---|---|
| Re: MVCC performance issue | Craig Ringer | 00:10 |
| Re: anti-join chosen even when slower than old plan | Robert Haas | 00:20 |
| Re: temporary tables, indexes, and query plans | Robert Haas | 00:46 |
| Re: temporary tables, indexes, and query plans | Tom Lane | 00:54 |
| Re: temporary tables, indexes, and query plans | Robert Haas | 02:54 |
| Re: MVCC performance issue | Marti Raudsepp | 08:30 |
| Re: MVCC performance issue | Marti Raudsepp | 08:46 |
| Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? | Marti Raudsepp | 09:47 |
| Re: temporary tables, indexes, and query plans | Tom Lane | 15:55 |
| Re: Why dose the planner select one bad scan plan. | Robert Haas | 23:00 |
| Thread | Author | Time |
|---|---|---|
| Re: Query Performance SQL Server vs. Postgresql | Pavel Stehule | 06:14 |
| Re: autovacuum blocks the operations of other manual vacuum | kuopo | 07:10 |
| executor stats / page reclaims | Uwe Bartels | 10:10 |
| Low disk performance? | Martin Chlupac | 11:09 |
| Re: Low disk performance? | tv | 13:33 |
| Re: Query Performance SQL Server vs. Postgresql | Kevin Grittner | 21:00 |
| Thread | Author | Time |
|---|---|---|
| Re: best db schema for time series data? | Louis-David Mitterrand | 09:46 |
| Re: best db schema for time series data? | Louis-David Mitterrand | 09:50 |
| Should changing offset in LIMIT change query plan (at all/so early)? | goran | 12:33 |
| Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1? | Jignesh Shah | 14:52 |
| Re: best db schema for time series data? | Chris Browne | 17:13 |
| Thread | Author | Time |
|---|---|---|
| Re: best db schema for time series data? 📎 | Robert Klemme | 00:16 |
| Re: autovacuum blocks the operations of other manual vacuum | Alvaro Herrera | 01:49 |
| Re: autovacuum blocks the operations of other manual vacuum | tv | 04:43 |
| Re: How to achieve sustained disk performance of 1.25 GB write for 5 mins | Dimitri | 10:16 |
| Re: best db schema for time series data? | Bob Lunney | 16:27 |
| Thread | Author | Time |
|---|---|---|
| Performance under contention | Ivan Voras | 00:15 |
| Re: Performance under contention | Kevin Grittner | 01:47 |
| Re: Performance under contention | Ivan Voras | 02:18 |
| Re: Query Performance SQL Server vs. Postgresql | Humair Mohammed | 06:21 |
| Re: Performance under contention | Jignesh Shah | 06:54 |
| Slow SELECT on small table 📎 | Martin Boese | 08:59 |
| Re: Performance under contention | Omar Kilani | 10:01 |
| Re: Query Performance SQL Server vs. Postgresql | tv | 11:00 |
| Re: Query Performance SQL Server vs. Postgresql | Samuel Gendler | 11:02 |
| Re: Query Performance SQL Server vs. Postgresql | tv | 12:22 |
| Re: Slow SELECT on small table | Kevin Grittner | 15:11 |
| Re: Performance under contention | Kevin Grittner | 15:26 |
| Re: Performance under contention | Ivan Voras | 15:38 |
| Re: Performance under contention | Kevin Grittner | 17:47 |
| Thread | Author | Time |
|---|---|---|
| Re: Query Performance SQL Server vs. Postgresql | Humair Mohammed | 00:12 |
| Re: Query Performance SQL Server vs. Postgresql | Merlin Moncure | 14:20 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance under contention | Craig Ringer | 00:11 |
| Re: Performance under contention | Ivan Voras | 01:09 |
| Re: postmaster consuming /lots/ of memory with hash aggregate. why? | Robert Haas | 03:11 |
| Re: Performance under contention | Vitalii Tymchyshyn | 08:58 |
| Re: Performance under contention | Kevin Grittner | 14:46 |
| Optimizing query | pasman pasmański | 14:48 |
| problem with from_collapse_limit and joined views | Markus Schulz | 18:37 |
| Thread | Author | Time |
|---|---|---|
| Which gives good performance? separate database vs separate schema | Divakar Singh | 11:37 |
| Re: Which gives good performance? separate database vs separate schema | tv | 12:02 |
| Re: Which gives good performance? separate database vs separate schema | Thomas Kellerer | 12:03 |
| Re: Which gives good performance? separate database vs separate schema | tv | 12:09 |
| Re: Which gives good performance? separate database vs separate schema | Andres Freund | 12:10 |
| Re: Which gives good performance? separate database vs separate schema | tv | 12:25 |
| Re: Performance under contention | Ivan Voras | 12:39 |
| Re: Which gives good performance? separate database vs separate schema | Divakar Singh | 14:53 |
| Re: Which gives good performance? separate database vs separate schema | tv | 15:46 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance under contention | Greg Smith | 02:00 |
| Re: Performance under contention | Ivan Voras | 02:08 |
| Re: Optimizing query | Pierre C | 09:46 |
| Re: Which gives good performance? separate database vs separate schema | Robert Klemme | 11:38 |
| Update problem on large table | felix | 14:22 |
| Re: Optimizing query | pasman pasmański | 15:06 |
| Re: Update problem on large table | bricklen | 16:00 |
| Re: CPUs for new databases | Christian Elmerot @ One.com | 16:38 |
| Re: CPUs for new databases | Kevin Grittner | 17:46 |
| Re: CPUs for new databases | Greg Smith | 22:30 |
| Thread | Author | Time |
|---|---|---|
| SELECT INTO large FKyed table is slow | Mario Splivalo | 11:46 |
| Simple database, multiple instances? | Mario Splivalo | 12:02 |
| Re: SELECT INTO large FKyed table is slow | Pierre C | 18:56 |
| Re: SELECT INTO large FKyed table is slow | Mario Splivalo | 19:08 |
| Re: SELECT INTO large FKyed table is slow | Pierre C | 21:50 |
| Thread | Author | Time |
|---|---|---|
| Hi- Sleeptime reduction | aaliya zarrin | 04:39 |
| Re: Hi- Sleeptime reduction | Kevin Grittner | 05:09 |
| Full Text index is not using during OR operation | AI Rumman | 07:00 |
| Re: SELECT INTO large FKyed table is slow | Mark Kirkwood | 07:11 |
| Re: SELECT INTO large FKyed table is slow | Mario Splivalo | 12:23 |
| Re: SELECT INTO large FKyed table is slow | Mario Splivalo | 12:30 |
| Re: Full Text index is not using during OR operation | Oleg Bartunov | 12:37 |
| Re: Full Text index is not using during OR operation | AI Rumman | 14:03 |
| Re: Full Text index is not using during OR operation | Tobias Brox | 14:32 |
| Re: Full Text index is not using during OR operation | Oleg Bartunov | 15:02 |
| Re: SELECT INTO large FKyed table is slow | Pierre C | 16:47 |
| Re: SELECT INTO large FKyed table is slow | Pierre C | 16:53 |