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: Speeding up JSON + TSQUERY + GIN | Sven R. Kunze | 14:02 |
| Re: Speeding up JSON + TSQUERY + GIN | Jeff Janes | 17:04 |
| anti-join with small table via text/varchar cannot estimate rows correctly | Stefan Andreatta | 22:00 |
| Re: anti-join with small table via text/varchar cannot estimate rows correctly | David G. Johnston | 22:12 |
| Thread | Author | Time |
|---|---|---|
| Performance issue in PostgreSQL server... | Dinesh Chandra 12108 | 10:29 |
| Re: Performance issue in PostgreSQL server... | Nur Agus | 12:23 |
| Re: Performance issue in PostgreSQL server... | Dinesh Chandra 12108 | 12:44 |
| Re: Suggestions for a HBA controller (6 x SSDs + madam RAID10) | Merlin Moncure | 15:03 |
| Re: Performance issue in PostgreSQL server... | Tom Lane | 15:19 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance issue in PostgreSQL server... | Jeff Janes | 04:23 |
| Re: Speeding up JSON + TSQUERY + GIN | Jeff Janes | 04:25 |
| Re: Performance issue in PostgreSQL server... | Justin Pryzby | 05:24 |
| Re: Performance issue in PostgreSQL server... | Dinesh Chandra 12108 | 12:17 |
| Performance issue after upgrading from 9.4 to 9.6 | Piotr Gasidło | 13:20 |
| Huge difference between ASC and DESC ordering | twoflower | 14:22 |
| Re: Huge difference between ASC and DESC ordering | Jeff Janes | 16:19 |
| Re: Huge difference between ASC and DESC ordering | twoflower | 16:46 |
| Re: Huge difference between ASC and DESC ordering | Jeff Janes | 17:11 |
| Re: Speeding up JSON + TSQUERY + GIN | Sven R. Kunze | 21:10 |
| Thread | Author | Time |
|---|---|---|
| Re: Huge difference between ASC and DESC ordering | twoflower | 08:40 |
| Thread | Author | Time |
|---|---|---|
| Please help with a slow query: there are millions of records, what can we do? | Pat Maddox | 02:26 |
| Re: Please help with a slow query: there are millions of records, what can we do? | Albe Laurenz | 10:05 |
| Re: Please help with a slow query: there are millions of records, what can we do? | Jeff Janes | 18:00 |
| Thread | Author | Time |
|---|---|---|
| Auto generate number in Postgres-9.1. | Dinesh Chandra 12108 | 13:38 |
| Re: Auto generate number in Postgres-9.1. | Josh Berkus | 13:43 |
| Re: Auto generate number in Postgres-9.1. | Andreas Karlsson | 13:48 |
| Re: Auto generate number in Postgres-9.1. | John Gorman | 13:50 |
| Re: Auto generate number in Postgres-9.1. | Dinesh Chandra 12108 | 14:08 |
| Re: Auto generate number in Postgres-9.1. | Andreas Karlsson | 15:40 |
| Thread | Author | Time |
|---|---|---|
| Optimizing around retained tuples | James Parks | 19:24 |
| Thread | Author | Time |
|---|---|---|
| Re: Optimizing around retained tuples | Claudio Freire | 01:56 |
| Re: Optimizing around retained tuples | Claudio Freire | 01:58 |
| Re: Please help with a slow query: there are millions of records, what can we do? | Pat Maddox | 15:07 |
| Thread | Author | Time |
|---|---|---|
| Postgres not using all RAM (Huge Page activated on a 96GB RAM system) | Pietro Pugni | 09:58 |
| Re: Postgres not using all RAM (Huge Page activated on a 96GB RAM system) | Andrew Kerber | 14:00 |
| Re: Optimizing around retained tuples | Brad DeJong | 16:00 |
| Re: Postgres not using all RAM (Huge Page activated on a 96GB RAM system) | Scott Marlowe | 19:47 |
| Re: Postgres not using all RAM (Huge Page activated on a 96GB RAM system) | Álvaro Hernández Tortosa | 20:16 |
| Thread | Author | Time |
|---|---|---|
| Re: Postgres not using all RAM (Huge Page activated on a 96GB RAM system) | Shaun Thomas | 01:27 |
| Re: Postgres not using all RAM (Huge Page activated on a 96GB RAM system) | trafdev | 01:56 |
| Thread | Author | Time |
|---|---|---|
| self join estimate and constraint exclusion | Justin Pryzby | 19:33 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance issue after upgrading from 9.4 to 9.6 | Merlin Moncure | 13:21 |
| Re: Postgres not using all RAM (Huge Page activated on a 96GB RAM system) | Merlin Moncure | 13:27 |
| Best design for performance | Riaan Stander | 23:43 |
| Thread | Author | Time |
|---|---|---|
| Re: Best design for performance | Claudio Freire | 00:42 |
| Re: Best design for performance | Riaan Stander | 01:17 |
| Re: Best design for performance | Claudio Freire | 02:22 |
| Re: Best design for performance | Riaan Stander | 12:41 |
| Re: Best design for performance | Claudio Freire | 17:15 |
| Re: Best design for performance | Riaan Stander | 22:51 |