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 |
|---|---|---|
| Query performance issue | Nagaraj Raj | 21:18 |
| Re: Query performance issue | Thomas Kellerer | 21:23 |
| Re: Query performance issue | Nagaraj Raj | 21:24 |
| Re: Query performance issue | Tomas Vondra | 21:36 |
| Re: Query performance issue | Michael Lewis | 21:39 |
| Re: Query performance issue | Michael Lewis | 21:41 |
| Re: Query performance issue | Nagaraj Raj | 21:44 |
| Re: Query performance issue | Michael Lewis | 21:55 |
| Re: Query performance issue | Nagaraj Raj | 22:20 |
| Thread | Author | Time |
|---|---|---|
| Re: Query performance issue | David Rowley | 08:16 |
| Re: Query performance issue | Michael Lewis | 13:42 |
| Re: Query performance issue | Nagaraj Raj | 21:49 |
| Thread | Author | Time |
|---|---|---|
| Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED | Raj | 18:04 |
| Thread | Author | Time |
|---|---|---|
| AW: Query performance issue | Dirk Krautschick | 10:29 |
| Query Performance in bundled requests | Dirk Krautschick | 10:30 |
| Re: Query Performance in bundled requests | Justin Pryzby | 10:49 |
| AWS RDS PostgreSQL CPU Spiking to 100% | aditya desai | 13:33 |
| Re: AWS RDS PostgreSQL CPU Spiking to 100% | Pavel Stehule | 14:36 |
| Re: AWS RDS PostgreSQL CPU Spiking to 100% | Jeff Janes | 16:05 |
| Thread | Author | Time |
|---|---|---|
| Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED | Jim Jarvie | 18:29 |
| Thread | Author | Time |
|---|---|---|
| Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED | David Rowley | 13:52 |
| Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED | Alvaro Herrera | 14:55 |
| Performance Issue (Not using Index when joining two tables). | Gopisetty, Ramesh | 14:58 |
| Re: Performance Issue (Not using Index when joining two tables). | Tomas Vondra | 16:47 |
| Re: Performance Issue (Not using Index when joining two tables). | Tom Lane | 17:07 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance Issue (Not using Index when joining two tables). | Michael Lewis | 02:51 |
| Re: Performance Issue (Not using Index when joining two tables). | Gopisetty, Ramesh | 03:18 |
| Re: Performance Issue (Not using Index when joining two tables). | Tom Lane | 17:40 |
| autoanalyze creates bad plan, manual analyze fixes it? | Robert Treat | 23:11 |
| Re: autoanalyze creates bad plan, manual analyze fixes it? | Justin Pryzby | 23:41 |
| Thread | Author | Time |
|---|---|---|
| Re: autoanalyze creates bad plan, manual analyze fixes it? | Pavel Stehule | 04:53 |
| Re: autoanalyze creates bad plan, manual analyze fixes it? | Robert Treat | 05:21 |
| Single column vs composite partial index | Nagaraj Raj | 22:33 |
| Thread | Author | Time |
|---|---|---|
| Performance issue when we use policies for Row Level Security along with functions | Gopisetty, Ramesh | 03:39 |
| Re: Single column vs composite partial index | Justin Pryzby | 04:18 |
| Re: Single column vs composite partial index | Nagaraj Raj | 06:59 |
| Re: Performance issue when we use policies for Row Level Security along with functions | luis.roberto | 10:52 |
| Re: Performance issue when we use policies for Row Level Security along with functions | Tom Lane | 14:17 |
| Thread | Author | Time |
|---|---|---|
| Re: Single column vs composite partial index | Michael Lewis | 20:54 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables | Michael Paquier | 03:56 |
| Re: proposal: schema variables | Pavel Stehule | 03:58 |
| Re: proposal: schema variables 📎 | Pavel Stehule | 18:49 |
| Thread | Author | Time |
|---|---|---|
| How to encrypt database password in pgpass or unix file to run batch jobs through shell script | aditya desai | 09:34 |
| Re: How to encrypt database password in pgpass or unix file to run batch jobs through shell script | Bruce Momjian | 19:51 |
| Thread | Author | Time |
|---|---|---|
| Re: AWS RDS PostgreSQL CPU Spiking to 100% | aditya desai | 15:51 |
| Re: AWS RDS PostgreSQL CPU Spiking to 100% | Prince Pathria | 16:09 |
| Is it possible to specify minimum number of rows planner should consider? | Timothy Garnett | 20:12 |
| Re: Is it possible to specify minimum number of rows planner should consider? | Tom Lane | 21:06 |
| Re: Is it possible to specify minimum number of rows planner should consider? | Matthew Bellew | 21:45 |
| Thread | Author | Time |
|---|---|---|
| Re: Is it possible to specify minimum number of rows planner should consider? | Timothy Garnett | 00:22 |
| Thread | Author | Time |
|---|---|---|
| Re: AWS RDS PostgreSQL CPU Spiking to 100% | aditya desai | 07:13 |
| SSL connection getting rejected on AWS RDS | aditya desai | 07:19 |
| Re: SSL connection getting rejected on AWS RDS | Hannah Huang | 11:17 |
| Re: SSL connection getting rejected on AWS RDS | aditya desai | 15:50 |