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 |
|---|---|---|
| Useless memoize path generated for unique join on primary keys | Benjamin Coutu | 11:05 |
| Re: Useless memoize path generated for unique join on primary keys | David Rowley | 11:43 |
| Re: Useless memoize path generated for unique join on primary keys | Benjamin Coutu | 12:21 |
| Re: Useless memoize path generated for unique join on primary keys | David Rowley | 12:31 |
| Window partial fetch optimization | Levi Aul | 18:11 |
| Re: Window partial fetch optimization | David Rowley | 22:12 |
| Thread | Author | Time |
|---|---|---|
| Re: Window partial fetch optimization | Jeff Janes | 21:56 |
| Why is there a Sort after an Index Only Scan? | André Hänsel | 23:15 |
| Re: Why is there a Sort after an Index Only Scan? | Jeff Janes | 23:37 |
| Re: Why is there a Sort after an Index Only Scan? | David Rowley | 23:42 |
| Thread | Author | Time |
|---|---|---|
| RE: Why is there a Sort after an Index Only Scan? | André Hänsel | 01:12 |
| Re: Why is there a Sort after an Index Only Scan? | Tom Lane | 02:08 |
| Thread | Author | Time |
|---|---|---|
| DB connection issue suggestions | Sudhir Guna | 16:59 |
| Re: DB connection issue suggestions 📎 | MichaelDBA Vitale | 18:13 |
| Re: DB connection issue suggestions | Justin Pryzby | 18:15 |
| Re: DB connection issue suggestions | Ranier Vilela | 18:54 |
| Thread | Author | Time |
|---|---|---|
| Re: DB connection issue suggestions | Sudhir Guna | 01:44 |
| Re: DB connection issue suggestions | Sudhir Guna | 01:46 |
| Re: DB connection issue suggestions | Sudhir Guna | 01:52 |
| Re: DB connection issue suggestions | Laurenz Albe | 06:13 |
| Re: DB connection issue suggestions | Anbazhagan M | 06:30 |
| Re: DB connection issue suggestions | Sudhir Guna | 07:11 |
| Re: DB connection issue suggestions | Ranier Vilela | 11:45 |
| Re: DB connection issue suggestions | Justin Pryzby | 19:09 |
| Thread | Author | Time |
|---|---|---|
| Re: DB connection issue suggestions | Sudhir Guna | 04:53 |
| Thread | Author | Time |
|---|---|---|
| Re: DB connection issue suggestions | Justin Pryzby | 04:08 |
| Thread | Author | Time |
|---|---|---|
| Need help on Query Tunning and Not using the Index Scan | Kumar, Mukesh | 07:37 |
| Selecting RAM and CPU based on max_connections | aditya desai | 08:27 |
| Re: Selecting RAM and CPU based on max_connections | Andreas Kretschmer | 10:15 |
| Re: Selecting RAM and CPU based on max_connections | Laurenz Albe | 10:31 |
| Re: Need help on Query Tunning and Not using the Index Scan | Laurenz Albe | 10:37 |
| Re: Array of integer indexed nested-loop semi join | Mickael van der Beek | 10:42 |
| Re: Selecting RAM and CPU based on max_connections | aditya desai | 15:40 |
| Re: Selecting RAM and CPU based on max_connections | Ganesh Korde | 17:59 |
| Thread | Author | Time |
|---|---|---|
| Re: Array of integer indexed nested-loop semi join | Jeff Janes | 02:45 |
| Re: Array of integer indexed nested-loop semi join | Mickael van der Beek | 07:57 |
| Re: Array of integer indexed nested-loop semi join | Jeff Janes | 14:10 |
| Re: Array of integer indexed nested-loop semi join | Mickael van der Beek | 14:46 |
| Thread | Author | Time |
|---|---|---|
| How to monitor Postgres real memory usage | 徐志宇徐 | 16:25 |
| Re: How to monitor Postgres real memory usage | Justin Pryzby | 17:40 |
| Thread | Author | Time |
|---|---|---|
| Re: How to monitor Postgres real memory usage 📎 | 徐志宇徐 | 15:36 |
| Re: How to monitor Postgres real memory usage | 徐志宇徐 | 15:47 |
| Re: How to monitor Postgres real memory usage | Justin Pryzby | 16:05 |
| Re: How to monitor Postgres real memory usage | 徐志宇徐 | 17:39 |
| Re: How to monitor Postgres real memory usage | Justin Pryzby | 23:35 |
| Thread | Author | Time |
|---|---|---|
| rows selectivity overestimate for @> operator for arrays | Alexey Ermakov | 13:39 |
| Re: How to monitor Postgres real memory usage 📎 | 徐志宇徐 | 17:40 |
| Re: How to monitor Postgres real memory usage | Justin Pryzby | 17:56 |
| Re: rows selectivity overestimate for @> operator for arrays | Tom Lane | 18:02 |
| Thread | Author | Time |
|---|---|---|
| postgres backend process hang on " D " state | James Pang (chaolpan) | 13:20 |
| Re: postgres backend process hang on " D " state | Ranier Vilela | 13:30 |
| Re: postgres backend process hang on " D " state | Justin Pryzby | 15:01 |
| Thread | Author | Time |
|---|---|---|
| RE: postgres backend process hang on " D " state | James Pang (chaolpan) | 01:19 |
| Re: postgres backend process hang on " D " state | Justin Pryzby | 02:19 |
| Re: postgres backend process hang on " D " state | Tom Lane | 02:21 |
| RE: postgres backend process hang on " D " state | James Pang (chaolpan) | 02:58 |
| RE: postgres backend process hang on " D " state | James Pang (chaolpan) | 02:59 |
| Thread | Author | Time |
|---|---|---|
| RE: postgres backend process hang on " D " state | James Pang (chaolpan) | 02:08 |
| REINDEXdb performance degrading gradually PG13.4 | Praneel Devisetty | 15:14 |
| REINDEXdb performance degrading gradually PG13.4 | David G. Johnston | 15:42 |
| Logical reads | Goti | 16:56 |