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: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet | Bruce Momjian | 17:49 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 19:24 |
| Thread | Author | Time |
|---|---|---|
| Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet | Jorge Rodriguez | 15:14 |
| Thread | Author | Time |
|---|---|---|
| Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet | Frédéric Yhuel | 16:17 |
| Thread | Author | Time |
|---|---|---|
| Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet | Frits Hoogland | 15:37 |
| Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet | Frédéric Yhuel | 17:40 |
| Thread | Author | Time |
|---|---|---|
| Keeping some tables in cache | Ertan Küçükoglu | 08:21 |
| Re: Keeping some tables in cache | Achilleas Mantzios | 09:04 |
| Re: Keeping some tables in cache | Laurenz Albe | 12:21 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 07:03 |
| Re: Any way to get nested loop index joins on CTEs? | Renan Alves Fonseca | 16:38 |
| Thread | Author | Time |
|---|---|---|
| Planner makes sub-optimal execution plan | Алексей Борщёв | 09:07 |
| Re: Planner makes sub-optimal execution plan | Alena Rybakina | 12:41 |
| Thread | Author | Time |
|---|---|---|
| Re: Planner makes sub-optimal execution plan | David Rowley | 04:41 |
| Thread | Author | Time |
|---|---|---|
| Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column | Matt Long | 19:13 |
| Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column 📎 | Tom Lane | 23:37 |
| Thread | Author | Time |
|---|---|---|
| Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column | Tom Lane | 19:19 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 09:28 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables | Jim Jones | 08:21 |
| Re: proposal: schema variables 📎 | Pavel Stehule | 16:55 |
| Thread | Author | Time |
|---|---|---|
| Indexes on expressions with multiple columns and operators 📎 | Frédéric Yhuel | 13:55 |
| Re: Indexes on expressions with multiple columns and operators | Laurenz Albe | 14:22 |
| Re: Indexes on expressions with multiple columns and operators | Tom Lane | 14:41 |
| Re: Indexes on expressions with multiple columns and operators | Frédéric Yhuel | 14:57 |
| Re: Indexes on expressions with multiple columns and operators | Frédéric Yhuel | 15:33 |
| Thread | Author | Time |
|---|---|---|
| Why isn't PG using an index-only scan? | Jean-Christophe BOGGIO | 06:36 |
| Re: Why isn't PG using an index-only scan? | David Rowley | 07:20 |
| Re: Why isn't PG using an index-only scan? | Jean-Christophe BOGGIO | 07:45 |
| Re: Why isn't PG using an index-only scan? | Andrei Lepikhov | 07:55 |
| Re: Why isn't PG using an index-only scan? | David Rowley | 11:32 |
| Re: Why isn't PG using an index-only scan? | David Rowley | 11:35 |
| Re: Why isn't PG using an index-only scan? | Andrei Lepikhov | 11:55 |
| Re: Indexes on expressions with multiple columns and operators | Jehan-Guillaume de Rorthais | 15:26 |
| Re: Indexes on expressions with multiple columns and operators | Tom Lane | 15:32 |
| Re: Indexes on expressions with multiple columns and operators 📎 | Tom Lane | 16:40 |
| Re: Indexes on expressions with multiple columns and operators | Ranier Vilela | 16:48 |
| Re: Indexes on expressions with multiple columns and operators | Tom Lane | 16:59 |
| Thread | Author | Time |
|---|---|---|
| Re: Why isn't PG using an index-only scan? | David Rowley | 01:05 |
| Re: Indexes on expressions with multiple columns and operators | Frédéric Yhuel | 07:50 |
| Re: Why isn't PG using an index-only scan? | Andrei Lepikhov | 07:50 |
| Re: Indexes on expressions with multiple columns and operators | Jehan-Guillaume de Rorthais | 14:37 |
| Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column | Matt Long | 18:26 |
| Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column | Tom Lane | 19:23 |
| Thread | Author | Time |
|---|---|---|
| Re: Indexes on expressions with multiple columns and operators | Tom Lane | 16:51 |
| Thread | Author | Time |
|---|---|---|
| Re: Indexes on expressions with multiple columns and operators | Frédéric Yhuel | 13:37 |
| Re: Indexes on expressions with multiple columns and operators | Andrei Lepikhov | 13:57 |
| Re: Indexes on expressions with multiple columns and operators | Frédéric Yhuel | 16:09 |
| Re: Indexes on expressions with multiple columns and operators | Andrei Lepikhov | 21:15 |
| Thread | Author | Time |
|---|---|---|
| Re: Indexes on expressions with multiple columns and operators | Frédéric Yhuel | 10:20 |
| Re: Indexes on expressions with multiple columns and operators | Andrei Lepikhov | 10:43 |
| Re: Indexes on expressions with multiple columns and operators | Frédéric Yhuel | 13:31 |
| Very expensive update to update a single row | Dirschel, Steve | 19:40 |
| Re: Very expensive update to update a single row | Sean M | 21:12 |
| Thread | Author | Time |
|---|---|---|
| Re: Indexes on expressions with multiple columns and operators | Frédéric Yhuel | 10:41 |
| Re: Indexes on expressions with multiple columns and operators | Frédéric Yhuel | 10:43 |
| Partition pruning is not happening (even in PG18) | Lauro Ojeda | 19:34 |
| Re: Partition pruning is not happening (even in PG18) | Michał Kłeczek | 20:10 |
| Re: Partition pruning is not happening (even in PG18) | Michał Kłeczek | 20:13 |
| Re: Partition pruning is not happening (even in PG18) | David Rowley | 20:17 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 10:13 |
| Re: Partition pruning is not happening (even in PG18) | Lauro Ojeda | 13:49 |
| Re: Partition pruning is not happening (even in PG18) | Chetan | 20:05 |
| Re: Partition pruning is not happening (even in PG18) | David Rowley | 20:08 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 05:54 |
| Thread | Author | Time |
|---|---|---|
| Question about nested loops.. | Frits Jalvingh | 08:52 |
| Re: Question about nested loops.. | Andrei Lepikhov | 10:00 |
| Re: Poor performance with row wise comparisons | Peter Geoghegan | 21:53 |
| Thread | Author | Time |
|---|---|---|
| Re: Poor performance with row wise comparisons | lokesh | 04:21 |
| Re: Question about nested loops.. | Andrei Lepikhov | 09:28 |
| Thread | Author | Time |
|---|---|---|
| Re: Poor performance with row wise comparisons | David G. Johnston | 23:03 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 04:57 |
| Thread | Author | Time |
|---|---|---|
| Re: Indexes on expressions with multiple columns and operators | Andrei Lepikhov | 13:56 |
| Re: Indexes on expressions with multiple columns and operators | Andrei Lepikhov | 14:00 |
| Re: Indexes on expressions with multiple columns and operators | Tom Lane | 14:55 |
| Thread | Author | Time |
|---|---|---|
| Re: Indexes on expressions with multiple columns and operators | Andrei Lepikhov | 09:29 |
| Thread | Author | Time |
|---|---|---|
| Performance implications of partitioning by UUIDv7 range in PostgreSQL v18 | Jonathan Reis | 03:37 |
| Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18 | David Rowley | 19:55 |
| Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18 | Olof Salberger | 21:05 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18 | Greg Sabino Mullane | 16:51 |
| Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18 | Jonathan Reis | 20:11 |
| Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18 | Laurenz Albe | 20:38 |
| Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18 | David Rowley | 22:54 |
| Thread | Author | Time |
|---|---|---|
| Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18 | Jonathan Reis | 02:14 |
| Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18 | Laurenz Albe | 05:04 |
| Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18 | Greg Sabino Mullane | 12:38 |
| Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18 | Jonathan Reis | 15:24 |
| Thread | Author | Time |
|---|---|---|
| GEQO plans much slower than standard join plans 📎 | Carlo Sganzerla | 18:17 |
| Thread | Author | Time |
|---|---|---|
| Re: GEQO plans much slower than standard join plans | Tomas Vondra | 01:24 |
| Re: GEQO plans much slower than standard join plans 📎 | Carlo Sganzerla | 15:43 |
| Thread | Author | Time |
|---|---|---|
| Re: GEQO plans much slower than standard join plans | Tomas Vondra | 02:05 |
| Re: GEQO plans much slower than standard join plans | Carlo Sganzerla | 14:57 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 16:27 |
| Thread | Author | Time |
|---|---|---|
| Re: GEQO plans much slower than standard join plans | David Rowley | 01:19 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 20:40 |
| Thread | Author | Time |
|---|---|---|
| trgm and index-usage when using similarity function | Andreas Joseph Krogh | 08:18 |
| Problem getting query to use index inside a function | Dirschel, Steve | 16:02 |
| Re: Problem getting query to use index inside a function | Tom Lane | 16:18 |
| RE: [EXT] Re: Problem getting query to use index inside a function | Dirschel, Steve | 16:55 |
| Re: [EXT] Re: Problem getting query to use index inside a function | Tom Lane | 19:17 |
| RE: [EXT] Re: Problem getting query to use index inside a function | Dirschel, Steve | 20:18 |
| Thread | Author | Time |
|---|---|---|
| Index Searches higher than expected for skip scan | Michael Christofides | 19:00 |
| Re: Index Searches higher than expected for skip scan 📎 | Peter Geoghegan | 19:54 |
| Re: Index Searches higher than expected for skip scan | Peter Geoghegan | 20:39 |
| Thread | Author | Time |
|---|---|---|
| Re: Index Searches higher than expected for skip scan | Michael Christofides | 11:16 |
| Re: Index Searches higher than expected for skip scan | Peter Geoghegan | 15:00 |
| Thread | Author | Time |
|---|---|---|
| Multicolumn index scan efficiency | Vitalii Tymchyshyn | 02:44 |
| Re: Multicolumn index scan efficiency | Peter Geoghegan | 04:20 |
| Re: Multicolumn index scan efficiency | Vitalii Tymchyshyn | 05:12 |
| Re: proposal: schema variables 📎 | Pavel Stehule | 06:40 |
| Re: Multicolumn index scan efficiency | Peter Geoghegan | 17:00 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 19:59 |
| Re: proposal: schema variables 📎 | Pavel Stehule | 21:19 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables | Pavel Stehule | 04:43 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 06:01 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 04:27 |
| Re: proposal: schema variables | Jim Jones | 13:44 |
| Client-server communication for FETCH | Tim Fors | 18:02 |
| Re: Client-server communication for FETCH | Tom Lane | 18:41 |
| Re: Client-server communication for FETCH | Tim Fors | 19:45 |
| Thread | Author | Time |
|---|---|---|
| Why is my query 3 times faster on my workstation than on my server? | Vincent Veyron | 18:46 |
| Re: Why is my query 3 times faster on my workstation than on my server? | Pavel Stehule | 18:53 |
| Re: Why is my query 3 times faster on my workstation than on my server? | Tom Lane | 19:06 |
| RE: Why is my query 3 times faster on my workstation than on my server? | Clay Jackson (cjackson) | 19:51 |
| Re: Why is my query 3 times faster on my workstation than on my server? | Vincent Veyron | 22:56 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 06:50 |
| Re: Client-server communication for FETCH | Jan Claeys | 09:08 |
| Seeking guidance on extremely slow pg_restore despite strong I/O performance | MentionTheElephant | 10:30 |
| Re: Seeking guidance on extremely slow pg_restore despite strong I/O performance | pg254kl | 20:27 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables | Jim Jones | 11:29 |
| Thread | Author | Time |
|---|---|---|
| Re: Seeking guidance on extremely slow pg_restore despite strong I/O performance | Jeff Janes | 00:53 |
| Re: proposal: schema variables 📎 | Pavel Stehule | 08:15 |
| Re: proposal: schema variables 📎 | Pavel Stehule | 13:57 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 05:51 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 14:46 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 04:42 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 07:52 |
| Thread | Author | Time |
|---|---|---|
| Surprising optimizer behavior with a subquery, a GROUP BY, and a range filter | wotq | 20:26 |
| Re: Surprising optimizer behavior with a subquery, a GROUP BY, and a range filter | Tom Lane | 20:46 |
| Thread | Author | Time |
|---|---|---|
| Unexpected planner choice in simple JOIN | Mark Kirkwood | 01:35 |
| Re: Unexpected planner choice in simple JOIN | Mark Kirkwood | 03:34 |
| Re: Unexpected planner choice in simple JOIN | David Rowley | 03:56 |
| Re: Unexpected planner choice in simple JOIN | Mark Kirkwood | 04:03 |
| Re: Unexpected planner choice in simple JOIN | David Rowley | 04:14 |
| Re: Unexpected planner choice in simple JOIN | Mark Kirkwood | 04:24 |
| Re: Unexpected planner choice in simple JOIN | Tom Lane | 04:34 |
| Re: Unexpected planner choice in simple JOIN | Mark Kirkwood | 04:44 |
| Re: Unexpected planner choice in simple JOIN | Tom Lane | 04:51 |
| Re: Unexpected planner choice in simple JOIN | Mark Kirkwood | 04:55 |