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 |
|---|---|---|
| GCC 8.3.0 vs. 9.0.1 | Steven Winfield | 16:14 |
| Re: GCC 8.3.0 vs. 9.0.1 | Tom Lane | 17:05 |
| Re: GCC 8.3.0 vs. 9.0.1 | Peter Geoghegan | 17:28 |
| Re: GCC 8.3.0 vs. 9.0.1 | Andres Freund | 17:32 |
| Re: GCC 8.3.0 vs. 9.0.1 | Andres Freund | 17:42 |
| Re: GCC 8.3.0 vs. 9.0.1 | Andres Freund | 18:04 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: Generic Plans for Prepared Statement are 158155 times slower than Custom Plans | Deepak Somaiya | 04:14 |
| Re: [HACKERS] proposal: schema variables 📎 | Pavel Stehule | 04:34 |
| integrate Postgres Users Authentication with our own LDAP Server | M Tarkeshwar Rao | 04:51 |
| Re: integrate Postgres Users Authentication with our own LDAP Server | Achilleas Mantzios | 06:17 |
| Re: integrate Postgres Users Authentication with our own LDAP Server | Laurenz Albe | 06:42 |
| RE: integrate Postgres Users Authentication with our own LDAP Server | M Tarkeshwar Rao | 07:11 |
| Re: integrate Postgres Users Authentication with our own LDAP Server | Laurenz Albe | 07:23 |
| Re: integrate Postgres Users Authentication with our own LDAP Server | Tomas Vondra | 12:43 |
| RE: GCC 8.3.0 vs. 9.0.1 | Steven Winfield | 14:04 |
| Re: integrate Postgres Users Authentication with our own LDAP Server | Stephen Frost | 19:24 |
| Thread | Author | Time |
|---|---|---|
| Log size in bytes of query result | Franklin Haut | 14:10 |
| Re: Log size in bytes of query result | Laurenz Albe | 16:09 |
| Re: Log size in bytes of query result | Sergei Kornilov | 16:42 |
| Thread | Author | Time |
|---|---|---|
| Huge generated UNION ALL faster than JOIN? | Ancoron Luciferis | 14:08 |
| Re: Huge generated UNION ALL faster than JOIN? | Tom Lane | 18:08 |
| Re: Huge generated UNION ALL faster than JOIN? | Ancoron Luciferis | 22:23 |
| Thread | Author | Time |
|---|---|---|
| The wrong (?) query plan for queries with remote (postgres_fdw) tables 📎 | Vitaly Baranovsky | 16:08 |
| Thread | Author | Time |
|---|---|---|
| Analyze results in more expensive query plan | Jeremy Altavilla | 20:03 |
| Thread | Author | Time |
|---|---|---|
| RE: Re: Re: Generic Plans for Prepared Statement are 158155 times slower than Custom Plans | Naik, Sameer | 06:42 |
| using sequential scan instead of index for join with a union | Kent Tong | 09:15 |
| Re: using sequential scan instead of index for join with a union | Sergei Kornilov | 09:23 |
| Re: using sequential scan instead of index for join with a union | Kent Tong | 09:36 |
| Re: Analyze results in more expensive query plan | Tom Lane | 13:35 |
| Thread | Author | Time |
|---|---|---|
| Trying to handle db corruption 9.6 | Mariel Cherkassky | 14:39 |
| Re: Trying to handle db corruption 9.6 | Flo Rance | 14:49 |
| Re: Trying to handle db corruption 9.6 | Mariel Cherkassky | 15:00 |
| Re: Trying to handle db corruption 9.6 | Mariel Cherkassky | 16:07 |
| Re: Trying to handle db corruption 9.6 | Bimal | 16:20 |
| Re: Trying to handle db corruption 9.6 | Mariel Cherkassky | 17:20 |
| Re: Analyze results in more expensive query plan | Jeremy Altavilla | 20:19 |
| Re: Trying to handle db corruption 9.6 | Tomas Vondra | 20:55 |
| Re: Trying to handle db corruption 9.6 | Tomas Vondra | 21:04 |
| Re: Re: Re: Generic Plans for Prepared Statement are 158155 times slower than Custom Plans | Deepak Somaiya | 21:37 |
| Re: Generic Plans for Prepared Statement are 158155 times slower than Custom Plans | Tomas Vondra | 22:16 |
| Thread | Author | Time |
|---|---|---|
| Use Postgres as a column store by creating one table per column | Lev Kokotov | 04:28 |
| Re: Use Postgres as a column store by creating one table per column | Justin Pryzby | 04:43 |
| Re: Log size in bytes of query result | Franklin Haut | 12:50 |
| Re: Log size in bytes of query result | Dmitry Dolgov | 13:15 |
| pg_restore takes more time on creation of rules | Mariel Cherkassky | 15:26 |
| Re: pg_restore takes more time on creation of rules | Tomas Vondra | 15:41 |
| Re: pg_restore takes more time on creation of rules | Mariel Cherkassky | 15:44 |
| Re: pg_restore takes more time on creation of rules | Ron | 16:00 |
| Re: pg_restore takes more time on creation of rules | Mariel Cherkassky | 16:02 |
| Re: pg_restore takes more time on creation of rules | Ron | 16:27 |
| Re: pg_restore takes more time on creation of rules | Mariel Cherkassky | 16:44 |
| Re: pg_restore takes more time on creation of rules | Tomas Vondra | 17:00 |
| Re: Analyze results in more expensive query plan | Jeremy Altavilla | 22:21 |
| Thread | Author | Time |
|---|---|---|
| Re: Use Postgres as a column store by creating one table per column | George Neuner | 05:08 |
| RE: Re: Generic Plans for Prepared Statement are 158155 times slower than Custom Plans | Naik, Sameer | 06:37 |
| upgrade to PG11 on secondary fails (no initdb was launched) | Mariel Cherkassky | 08:20 |
| Fwd: upgrade to PG11 on secondary fails (no initdb was launched) | Mariel Cherkassky | 08:58 |
| Fwd: upgrade to PG11 on secondary fails (no initdb was launched) | Mariel Cherkassky | 11:07 |
| RE: upgrade to PG11 on secondary fails (no initdb was launched) | Greg Clough | 11:23 |
| Re: Fwd: upgrade to PG11 on secondary fails (no initdb was launched) | Fabio Pardi | 11:31 |
| Re: Fwd: upgrade to PG11 on secondary fails (no initdb was launched) | Stephen Frost | 15:06 |
| Re: upgrade to PG11 on secondary fails (no initdb was launched) | Stephen Frost | 15:08 |
| Re: Generic Plans for Prepared Statement are 158155 times slower than Custom Plans | Tom Lane | 17:17 |
| Thread | Author | Time |
|---|---|---|
| Re: [HACKERS] proposal: schema variables 📎 | Pavel Stehule | 17:12 |
| Re: Use Postgres as a column store by creating one table per column | Tomas Vondra | 18:06 |
| Re: Use Postgres as a column store by creating one table per column | Stephen Frost | 19:38 |
| Thread | Author | Time |
|---|---|---|
| Re: Use Postgres as a column store by creating one table per column | Mark Kirkwood | 03:55 |
| UUID v1 optimizations... | Ancoron Luciferis | 13:45 |
| Re: UUID v1 optimizations... | Peter Eisentraut | 14:19 |
| Re: UUID v1 optimizations... | Tom Lane | 14:57 |
| Re: UUID v1 optimizations... | Ancoron Luciferis | 17:27 |
| Re: UUID v1 optimizations... | Ancoron Luciferis | 18:20 |
| Re: UUID v1 optimizations... | Vitalii Tymchyshyn | 19:00 |
| Re: UUID v1 optimizations... | Ancoron Luciferis | 21:02 |
| Re: UUID v1 optimizations... | Ancoron Luciferis | 21:02 |
| Re: UUID v1 optimizations... | Tom Lane | 21:54 |
| Re: UUID v1 optimizations... | Tomas Vondra | 22:14 |
| Re: UUID v1 optimizations... | Tom Lane | 22:38 |
| Re: UUID v1 optimizations... | Ancoron Luciferis | 23:00 |
| Re: UUID v1 optimizations... | Tomas Vondra | 23:44 |
| Re: UUID v1 optimizations... | Ancoron Luciferis | 23:49 |
| Thread | Author | Time |
|---|---|---|
| Re: UUID v1 optimizations... | Tomas Vondra | 01:09 |
| Re: UUID v1 optimizations... | Morris de Oryx | 04:27 |
| Re: UUID v1 optimizations... | Ancoron Luciferis | 09:01 |
| Re: UUID v1 optimizations... | Ancoron Luciferis | 09:38 |
| Re: UUID v1 optimizations... | Morris de Oryx | 10:24 |
| Re: UUID v1 optimizations... | Tomas Vondra | 10:37 |
| Re: UUID v1 optimizations... | Morris de Oryx | 10:38 |
| Re: UUID v1 optimizations... | Morris de Oryx | 10:46 |
| Thread | Author | Time |
|---|---|---|
| improve wals replay on secondary | Mariel Cherkassky | 08:49 |
| Re: improve wals replay on secondary | Fabio Pardi | 09:12 |
| Re: improve wals replay on secondary | Fabio Pardi | 09:29 |
| Re: improve wals replay on secondary | Mariel Cherkassky | 10:17 |
| Re: improve wals replay on secondary | Fabio Pardi | 11:04 |
| Thread | Author | Time |
|---|---|---|
| Re: improve wals replay on secondary | Fabio Pardi | 10:54 |
| Thread | Author | Time |
|---|---|---|
| Re: improve wals replay on secondary | Mariel Cherkassky | 07:20 |
| JIT in PostgreSQL 12 ? | Tobias Gierke | 08:02 |
| Re: improve wals replay on secondary | Fabio Pardi | 08:20 |
| Re: improve wals replay on secondary | Mariel Cherkassky | 08:39 |
| Sv: JIT in PostgreSQL 12 ? | Andreas Joseph Krogh | 08:48 |
| Re: Sv: JIT in PostgreSQL 12 ? | Tobias Gierke | 09:13 |
| Re: Sv: JIT in PostgreSQL 12 ? | Andreas Joseph Krogh | 09:16 |
| Re: JIT in PostgreSQL 12 ? | Andreas Karlsson | 09:37 |
| Re: improve wals replay on secondary | Nikolay Samokhvalov | 10:54 |
| Re: improve wals replay on secondary | Mariel Cherkassky | 11:10 |
| Thread | Author | Time |
|---|---|---|
| Shortest offline window on database migration | Haroldo Kerry | 15:08 |
| Re: Shortest offline window on database migration | Tomas Vondra | 15:31 |
| RE: Shortest offline window on database migration | Steven Winfield | 15:54 |
| Re: Shortest offline window on database migration | Haroldo Kerry | 16:23 |
| Re: Shortest offline window on database migration | Haroldo Kerry | 21:52 |
| Thread | Author | Time |
|---|---|---|
| Re: Shortest offline window on database migration | Jeff Janes | 01:41 |
| Re: Shortest offline window on database migration | Ian Lawrence Barwick | 02:49 |
| Re: Shortest offline window on database migration | Fabio Pardi | 09:40 |
| Re: improve wals replay on secondary | Fabio Pardi | 11:54 |
| Re: Sv: JIT in PostgreSQL 12 ? | Justin Pryzby | 23:38 |
| 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 |
| Thread | Author | Time |
|---|---|---|
| Custom opclass for column statistics? | Ancoron Luciferis | 09:02 |
| Re: Custom opclass for column statistics? | Tomas Vondra | 13:38 |
| Re: Custom opclass for column statistics? | Tom Lane | 13:58 |
| Re: Custom opclass for column statistics? | Ancoron Luciferis | 15:35 |
| Re: Custom opclass for column statistics? | Tomas Vondra | 15:57 |