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: Shortest offline window on database migration | Haroldo Kerry | 13:17 |
| Thread | Author | Time |
|---|---|---|
| Strange query behaviour between 9.4 and 12beta1 | Vasilis Ventirozos | 14:34 |
| Re: Shortest offline window on database migration | Stephen Frost | 20:18 |
| Re: Strange query behaviour between 9.4 and 12beta1 | Tomas Vondra | 23:01 |
| Thread | Author | Time |
|---|---|---|
| Re: UUID v1 optimizations... | Ancoron Luciferis | 20:27 |
| Thread | Author | Time |
|---|---|---|
| Re: Fwd: upgrade to PG11 on secondary fails (no initdb was launched) | Bruce Momjian | 03:30 |
| Re: Fwd: upgrade to PG11 on secondary fails (no initdb was launched) | Fabio Pardi | 13:12 |
| wal_log_hints benchmarks | Fabio Pardi | 13:46 |
| Re: Fwd: upgrade to PG11 on secondary fails (no initdb was launched) | Bruce Momjian | 14:39 |
| Re: Fwd: upgrade to PG11 on secondary fails (no initdb was launched) | Bruce Momjian | 14:44 |
| Re: Fwd: upgrade to PG11 on secondary fails (no initdb was launched) | Stephen Frost | 16:15 |
| Re: Fwd: upgrade to PG11 on secondary fails (no initdb was launched) | Stephen Frost | 16:16 |
| Thread | Author | Time |
|---|---|---|
| Re: wal_log_hints benchmarks | Michael Paquier | 02:01 |
| Re: wal_log_hints benchmarks | Fabio Pardi | 07:53 |
| Thread | Author | Time |
|---|---|---|
| Incorrect index used in few cases.. | AminPG Jaffer | 13:11 |
| Re: Incorrect index used in few cases.. | Tom Lane | 13:35 |
| Re: Incorrect index used in few cases.. | AminPG Jaffer | 18:55 |
| Re: Incorrect index used in few cases.. 📎 | Tom Lane | 21:07 |
| Re: Incorrect index used in few cases.. | Peter Geoghegan | 21:49 |
| Re: Incorrect index used in few cases.. | Andres Freund | 22:13 |
| Re: Incorrect index used in few cases.. | Tom Lane | 22:23 |
| Thread | Author | Time |
|---|---|---|
| EXPLAIN ANALYZE of BRIN bitmap index scan with disjunction | Chris Wilson | 15:12 |
| Re: EXPLAIN ANALYZE of BRIN bitmap index scan with disjunction | Simon Riggs | 15:56 |
| RE: EXPLAIN ANALYZE of BRIN bitmap index scan with disjunction | Chris Wilson | 16:00 |
| Re: EXPLAIN ANALYZE of BRIN bitmap index scan with disjunction | Simon Riggs | 16:18 |
| Re: EXPLAIN ANALYZE of BRIN bitmap index scan with disjunction | Justin Pryzby | 16:30 |
| Re: EXPLAIN ANALYZE of BRIN bitmap index scan with disjunction | Simon Riggs | 16:51 |
| Re: EXPLAIN ANALYZE of BRIN bitmap index scan with disjunction | Michael Lewis | 18:09 |
| Re: EXPLAIN ANALYZE of BRIN bitmap index scan with disjunction | Justin Pryzby | 18:13 |
| Re: EXPLAIN ANALYZE of BRIN bitmap index scan with disjunction | Michael Lewis | 18:16 |
| Thread | Author | Time |
|---|---|---|
| Re: EXPLAIN ANALYZE of BRIN bitmap index scan with disjunction | Simon Riggs | 09:17 |
| RE: EXPLAIN ANALYZE of BRIN bitmap index scan with disjunction | Chris Wilson | 09:20 |
| RE: EXPLAIN ANALYZE of BRIN bitmap index scan with disjunction | Chris Wilson | 09:43 |
| Using indexes in RLS policies (sub)queries | Grégory EL MAJJOUTI | 12:22 |
| Thread | Author | Time |
|---|---|---|
| materialized view refresh of a foreign table | Rick Otten | 14:21 |
| monitoring tuple_count vs dead_tuple_count | Mariel Cherkassky | 14:24 |
| Re: Incorrect index used in few cases.. | AminPG Jaffer | 15:07 |
| Thread | Author | Time |
|---|---|---|
| scans on table fail to be excluded by partition bounds | Justin Pryzby | 17:31 |
| Thread | Author | Time |
|---|---|---|
| RE: scans on table fail to be excluded by partition bounds | Steven Winfield | 10:48 |
| Re: materialized view refresh of a foreign table | Rick Otten | 11:03 |
| Perplexing, regular decline in performance | Hugh Ranalli | 15:49 |
| Re: Perplexing, regular decline in performance | Benjamin Scherrey | 15:55 |
| Re: Perplexing, regular decline in performance | Justin Pryzby | 16:01 |
| Re: Perplexing, regular decline in performance | Benjamin Scherrey | 16:06 |
| Re: Perplexing, regular decline in performance | Justin Pryzby | 16:23 |
| Thread | Author | Time |
|---|---|---|
| Max_connections limit | Daulat Ram | 07:13 |
| Re: Max_connections limit | Laurenz Albe | 09:05 |
| Re: Max_connections limit | Hervé Schweitzer (HER) | 09:15 |
| Re: Max_connections limit | Rick Otten | 12:38 |
| Re: Incorrect index used in few cases.. | AminPG Jaffer | 14:24 |
| RE: Max_connections limit | Igor Neyman | 14:29 |
| Re: scans on table fail to be excluded by partition bounds | Justin Pryzby | 18:03 |
| Re: Perplexing, regular decline in performance | Hugh Ranalli | 18:06 |
| Re: Perplexing, regular decline in performance | Peter Geoghegan | 18:52 |
| Re: Perplexing, regular decline in performance | Hugh Ranalli | 19:00 |
| Re: Perplexing, regular decline in performance | Hugh Ranalli | 19:02 |
| Re: Perplexing, regular decline in performance | Peter Geoghegan | 19:05 |
| Re: Perplexing, regular decline in performance | Alvaro Herrera | 19:07 |
| Re: Perplexing, regular decline in performance | Tom Lane | 19:18 |
| Re: scans on table fail to be excluded by partition bounds | David Rowley | 22:09 |
| Thread | Author | Time |
|---|---|---|
| Re: Perplexing, regular decline in performance | Justin Pryzby | 00:24 |
| Thread | Author | Time |
|---|---|---|
| Re: [HACKERS] proposal: schema variables 📎 | Pavel Stehule | 03:10 |