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: Postgresql TPS Bottleneck | Mladen Gogala | 02:40 |
| Thread | Author | Time |
|---|---|---|
| Re: HIGH IO and Less CPU utilization | Rambabu g | 07:47 |
| Thread | Author | Time |
|---|---|---|
| Slow Planning Times | Saurabh Sehgal | 00:26 |
| Re: Slow Planning Times | Saurabh Sehgal | 00:40 |
| Re: Slow Planning Times | David G. Johnston | 00:54 |
| Re: Slow Planning Times | Saurabh Sehgal | 01:47 |
| Re: Slow Planning Times | Tom Lane | 02:57 |
| Re: Slow Planning Times | Saurabh Sehgal | 04:09 |
| Thread | Author | Time |
|---|---|---|
| Performance for SQL queries on Azure PostgreSQL PaaS instance | Kumar, Mukesh | 09:10 |
| Re: Performance for SQL queries on Azure PostgreSQL PaaS instance | Frits Jalvingh | 14:23 |
| Re: Performance for SQL queries on Azure PostgreSQL PaaS instance | Tomas Vondra | 15:06 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance for SQL queries on Azure PostgreSQL PaaS instance | Laurenz Albe | 08:34 |
| RE: Performance for SQL queries on Azure PostgreSQL PaaS instance | Kumar, Mukesh | 08:42 |
| Re: Performance for SQL queries on Azure PostgreSQL PaaS instance | andrew cooke | 11:17 |
| RE: An I/O error occurred while sending to the backend (PG 13.4) | [email protected] | 15:36 |
| Re: An I/O error occurred while sending to the backend (PG 13.4) | Justin Pryzby | 15:43 |
| Thread | Author | Time |
|---|---|---|
| Query Tunning related to function 📎 | Kumar, Mukesh | 06:03 |
| SQL performance issue after migration from Oracle to Aurora postgres | Goti | 09:35 |
| Re: Query Tunning related to function | Ranier Vilela | 14:26 |
| Re: SQL performance issue after migration from Oracle to Aurora postgres | Andrew Dunstan | 14:40 |
| RE: Query Tunning related to function | Kumar, Mukesh | 14:44 |
| RE: Query Tunning related to function | Michel SALAIS | 18:14 |
| RE: Query Tunning related to function | Kumar, Mukesh | 18:45 |
| Re: Performance for SQL queries on Azure PostgreSQL PaaS instance | overland | 20:20 |
| Re: Query Tunning related to function | Bhupendra Babu | 22:13 |
| Query Planner not taking advantage of HASH PARTITION | Benjamin Tingle | 23:36 |
| Thread | Author | Time |
|---|---|---|
| RE: Query Tunning related to function 📎 | Kumar, Mukesh | 06:13 |
| RE: Query Tunning related to function | Kumar, Mukesh | 16:46 |
| Thread | Author | Time |
|---|---|---|
| Re: Query Tunning related to function | Justin Pryzby | 03:13 |
| Re: Query Planner not taking advantage of HASH PARTITION | Tom Lane | 16:09 |
| Re: Query Tunning related to function | David G. Johnston | 16:47 |
| Re: Query Planner not taking advantage of HASH PARTITION | Benjamin Tingle | 17:07 |
| Re: Query Planner not taking advantage of HASH PARTITION | Tom Lane | 18:20 |
| Re: Query Planner not taking advantage of HASH PARTITION | Alvaro Herrera | 18:50 |
| Thread | Author | Time |
|---|---|---|
| How to find the final transformed query in postgresql | Goti | 14:02 |
| Re: How to find the final transformed query in postgresql | Tom Lane | 14:13 |
| Re: How to find the final transformed query in postgresql | Goti | 14:31 |
| Thread | Author | Time |
|---|---|---|
| How to find all SQLs executed by a transaction id? | Patil, Ravi | 12:35 |
| significant jump in sql statement timing for on server vs a remote connection | Sbob | 21:00 |
| Re: significant jump in sql statement timing for on server vs a remote connection | Justin Pryzby | 21:04 |
| Thread | Author | Time |
|---|---|---|
| Re: significant jump in sql statement timing for on server vs a remote connection | Jeff Janes | 04:17 |
| Re: Postgresql TPS Bottleneck | wakandavision | 06:49 |
| Re: significant jump in sql statement timing for on server vs a remote connection | Sbob | 15:16 |
| Re: Postgresql TPS Bottleneck 📎 | Jeff Janes | 15:49 |
| Re: significant jump in sql statement timing for on server vs a remote connection | Ranier Vilela | 15:51 |
| Re: Postgresql TPS Bottleneck | wakandavision | 16:35 |
| Re: Postgresql TPS Bottleneck | Benedict Holland | 18:18 |
| Thread | Author | Time |
|---|---|---|
| Re: Query Planner not taking advantage of HASH PARTITION | Benjamin Tingle | 02:11 |
| Re: Query Planner not taking advantage of HASH PARTITION | Justin Pryzby | 11:52 |
| Thread | Author | Time |
|---|---|---|
| Performance differential when 0 values present vs when 1 values present. Planner return 52k rows when 0 expected. | Emil Iggland | 14:53 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance differential when 0 values present vs when 1 values present. Planner return 52k rows when 0 expected. | Tom Lane | 16:00 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance differential when 0 values present vs when 1 values present. Planner return 52k rows when 0 expected. | Emil Iggland | 07:41 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance differential when 0 values present vs when 1 values present. Planner return 52k rows when 0 expected. | David Rowley | 08:22 |
| Fwd: Array of integer indexed nested-loop semi join | Mickael van der Beek | 12:18 |
| Re: Array of integer indexed nested-loop semi join | Jeff Janes | 14:28 |
| Re: Array of integer indexed nested-loop semi join | Mickael van der Beek | 14:54 |
| Thread | Author | Time |
|---|---|---|
| Unworkable plan above certain row count | André Hänsel | 00:52 |
| Re: Unworkable plan above certain row count | Tom Lane | 02:08 |
| Re: Performance differential when 0 values present vs when 1 values present. Planner return 52k rows when 0 expected. | Emil Iggland | 08:09 |
| LISTEN NOTIFY sometimes huge delay | Peter Eser HEUFT [Germany] | 14:28 |
| Re: LISTEN NOTIFY sometimes huge delay | Tom Lane | 16:38 |
| Thread | Author | Time |
|---|---|---|
| FATAL: canceling authentication due to timeout | aditya desai | 10:59 |
| Fwd: FATAL: canceling authentication due to timeout | aditya desai | 11:23 |