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: Index bloat and REINDEX/VACUUM optimization for partial index | jayaprabhakar k | 01:05 |
| Re: Index bloat and REINDEX/VACUUM optimization for partial index | Jeff Janes | 03:01 |
| Re: Index bloat and REINDEX/VACUUM optimization for partial index | Jeff Janes | 03:18 |
| Re: Queries containing ORDER BY and LIMIT started to work slowly 📎 | Rondat Flyag | 13:41 |
| Re: Queries containing ORDER BY and LIMIT started to work slowly 📎 | Rondat Flyag | 13:45 |
| Re: Index bloat and REINDEX/VACUUM optimization for partial index | Maxim Boguk | 18:01 |
| Thread | Author | Time |
|---|---|---|
| query pg_stat_ssl hang 100%cpu | James Pang (chaolpan) | 01:34 |
| query pg_stat_ssl hang 100%cpu | James Pang (chaolpan) | 01:40 |
| Re: Index bloat and REINDEX/VACUUM optimization for partial index | jayaprabhakar k | 06:50 |
| Thread | Author | Time |
|---|---|---|
| FW: query pg_stat_ssl hang 100%cpu | James Pang (chaolpan) | 01:35 |
| Re: FW: query pg_stat_ssl hang 100%cpu | Michael Paquier | 04:04 |
| RE: FW: query pg_stat_ssl hang 100%cpu | James Pang (chaolpan) | 08:46 |
| RE: FW: query pg_stat_ssl hang 100%cpu | James Pang (chaolpan) | 08:54 |
| Re: FW: query pg_stat_ssl hang 100%cpu | Thomas Munro | 09:31 |
| RE: FW: query pg_stat_ssl hang 100%cpu | James Pang (chaolpan) | 09:38 |
| RE: FW: query pg_stat_ssl hang 100%cpu | James Pang (chaolpan) | 09:54 |
| Re: FW: query pg_stat_ssl hang 100%cpu | Thomas Munro | 10:01 |
| RE: FW: query pg_stat_ssl hang 100%cpu | James Pang (chaolpan) | 10:31 |
| Re: FW: query pg_stat_ssl hang 100%cpu | Thomas Munro | 10:36 |
| RE: FW: query pg_stat_ssl hang 100%cpu | James Pang (chaolpan) | 10:39 |
| Re: FW: query pg_stat_ssl hang 100%cpu | Thomas Munro | 10:59 |
| Re: FW: query pg_stat_ssl hang 100%cpu 📎 | Thomas Munro | 23:45 |
| Thread | Author | Time |
|---|---|---|
| Re: FW: query pg_stat_ssl hang 100%cpu | Michael Paquier | 02:48 |
| Planning time is time-consuming | Mikhail Balayan | 10:51 |
| Thread | Author | Time |
|---|---|---|
| Re: FW: query pg_stat_ssl hang 100%cpu | Thomas Munro | 22:37 |
| Re: FW: query pg_stat_ssl hang 100%cpu | Michael Paquier | 22:47 |
| Thread | Author | Time |
|---|---|---|
| Re: Planning time is time-consuming | Laurenz Albe | 01:15 |
| Re: Planning time is time-consuming | Anupam b | 01:23 |
| Re: Planning time is time-consuming | Andreas Kretschmer | 04:45 |
| Fwd: Planning time is time-consuming | Mikhail Balayan | 04:55 |
| Fwd: Planning time is time-consuming | Mikhail Balayan | 04:57 |
| Re: Fwd: Planning time is time-consuming | Laurenz Albe | 08:13 |
| Re: Planning time is time-consuming | David Rowley | 08:24 |
| Re: Planning time is time-consuming | David Rowley | 10:17 |
| Re: Range partitioning query performance with date_trunc (vs timescaledb) | Philippe Pepiot | 12:21 |
| Re: Planning time is time-consuming | Frits Hoogland | 13:54 |
| Re: Planning time is time-consuming | Tom Lane | 14:27 |
| Re: Planning time is time-consuming | Imre Samu | 15:17 |
| Thread | Author | Time |
|---|---|---|
| Re: Planning time is time-consuming | David Rowley | 03:06 |
| Thread | Author | Time |
|---|---|---|
| Re: FW: query pg_stat_ssl hang 100%cpu | Thomas Munro | 03:11 |
| Multixact wraparound monitoring | bruno da silva | 12:21 |
| Thread | Author | Time |
|---|---|---|
| Re: Multixact wraparound monitoring | Wyatt Alt | 05:14 |
| Re: Multixact wraparound monitoring | Alvaro Herrera | 11:23 |
| Re: Multixact wraparound monitoring | bruno da silva | 19:35 |
| Thread | Author | Time |
|---|---|---|
| Re: Multixact wraparound monitoring | Alvaro Herrera | 09:48 |
| pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit | Achilleas Mantzios - cloud | 14:30 |
| Re: pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit | Tom Lane | 15:23 |
| Re: pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit | Achilleas Mantzios | 19:31 |
| Re: pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit | Tom Lane | 19:42 |
| Re: pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit | Achilleas Mantzios | 20:36 |
| Re: pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit | Thomas Munro | 23:08 |
| Thread | Author | Time |
|---|---|---|
| Re: pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit | Achilleas Mantzios | 03:27 |
| Thread | Author | Time |
|---|---|---|
| Dirty reads on index scan, | Koen De Groote | 15:05 |
| Re: Dirty reads on index scan, | Laurenz Albe | 19:30 |
| Thread | Author | Time |
|---|---|---|
| Re: Dirty reads on index scan, | Koen De Groote | 08:35 |
| Re: Dirty reads on index scan, | Laurenz Albe | 09:14 |
| Re: Dirty reads on index scan, | Frits Hoogland | 13:22 |
| Re: Dirty reads on index scan, | Koen De Groote | 13:54 |
| Thread | Author | Time |
|---|---|---|
| Re: Dirty reads on index scan, | Jeff Janes | 20:17 |