pgsql-performance  

Messages by Date

• 2025/11/10 Re: Multicolumn index scan efficiency Peter Geoghegan
• 2025/11/09 Re: Multicolumn index scan efficiency Vitalii Tymchyshyn
• 2025/11/09 Re: Multicolumn index scan efficiency Peter Geoghegan
• 2025/11/09 Multicolumn index scan efficiency Vitalii Tymchyshyn
• 2025/11/07 Re: Index Searches higher than expected for skip scan Peter Geoghegan
• 2025/11/07 Re: Index Searches higher than expected for skip scan Michael Christofides
• 2025/11/06 Re: Index Searches higher than expected for skip scan Peter Geoghegan
• 2025/11/06 Re: Index Searches higher than expected for skip scan Peter Geoghegan
• 2025/11/06 Index Searches higher than expected for skip scan Michael Christofides
• 2025/11/05 RE: [EXT] Re: Problem getting query to use index inside a function Dirschel, Steve
• 2025/11/05 Re: [EXT] Re: Problem getting query to use index inside a function Tom Lane
• 2025/11/05 RE: [EXT] Re: Problem getting query to use index inside a function Dirschel, Steve
• 2025/11/05 Re: Problem getting query to use index inside a function Tom Lane
• 2025/11/05 Problem getting query to use index inside a function Dirschel, Steve
• 2025/11/05 trgm and index-usage when using similarity function Andreas Joseph Krogh
• 2025/10/30 Re: GEQO plans much slower than standard join plans David Rowley
• 2025/10/29 Re: GEQO plans much slower than standard join plans Carlo Sganzerla
• 2025/10/28 Re: GEQO plans much slower than standard join plans Tomas Vondra
• 2025/10/28 Re: GEQO plans much slower than standard join plans Carlo Sganzerla
• 2025/10/27 Re: GEQO plans much slower than standard join plans Tomas Vondra
• 2025/10/27 GEQO plans much slower than standard join plans Carlo Sganzerla
• 2025/10/24 Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18 Jonathan Reis
• 2025/10/24 Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18 Greg Sabino Mullane
• 2025/10/23 Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18 Laurenz Albe
• 2025/10/23 Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18 Jonathan Reis
• 2025/10/23 Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18 David Rowley
• 2025/10/23 Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18 Laurenz Albe
• 2025/10/23 Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18 Jonathan Reis
• 2025/10/23 Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18 Greg Sabino Mullane
• 2025/10/22 Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18 Olof Salberger
• 2025/10/22 Re: Performance implications of partitioning by UUIDv7 range in PostgreSQL v18 David Rowley
• 2025/10/22 Performance implications of partitioning by UUIDv7 range in PostgreSQL v18 Jonathan Reis
• 2025/10/18 Re: Partition pruning is not happening (even in PG18) David Rowley
• 2025/10/18 Re: Indexes on expressions with multiple columns and operators Andrei Lepikhov
• 2025/10/18 Re: Question about nested loops.. Andrei Lepikhov
• 2025/10/18 Re: Partition pruning is not happening (even in PG18) Lauro Ojeda
• 2025/10/18 Re: Indexes on expressions with multiple columns and operators Tom Lane
• 2025/10/18 Re: Indexes on expressions with multiple columns and operators Andrei Lepikhov
• 2025/10/17 Re: Poor performance with row wise comparisons Peter Geoghegan
• 2025/10/17 Re: Question about nested loops.. Andrei Lepikhov
• 2025/10/17 Re: Poor performance with row wise comparisons David G. Johnston
• 2025/10/17 Re: Indexes on expressions with multiple columns and operators Frédéric Yhuel
• 2025/10/17 Re: Indexes on expressions with multiple columns and operators Andrei Lepikhov
• 2025/10/17 Re: Indexes on expressions with multiple columns and operators Andrei Lepikhov
• 2025/10/11 Re: Poor performance with row wise comparisons lokesh
• 2025/10/09 Question about nested loops.. Frits Jalvingh
• 2025/09/29 Re: Partition pruning is not happening (even in PG18) Chetan
• 2025/09/27 Re: Indexes on expressions with multiple columns and operators Frédéric Yhuel
• 2025/09/25 Re: Indexes on expressions with multiple columns and operators Frédéric Yhuel
• 2025/09/25 Re: Partition pruning is not happening (even in PG18) David Rowley
• 2025/09/25 Re: Partition pruning is not happening (even in PG18) Michał Kłeczek
• 2025/09/25 Re: Partition pruning is not happening (even in PG18) Michał Kłeczek
• 2025/09/25 Partition pruning is not happening (even in PG18) Lauro Ojeda
• 2025/09/25 Re: Indexes on expressions with multiple columns and operators Frédéric Yhuel
• 2025/09/23 Re: Very expensive update to update a single row Sean M
• 2025/09/23 Very expensive update to update a single row Dirschel, Steve
• 2025/09/23 Re: Indexes on expressions with multiple columns and operators Andrei Lepikhov
• 2025/09/22 Re: Indexes on expressions with multiple columns and operators Frédéric Yhuel
• 2025/09/22 Re: Indexes on expressions with multiple columns and operators Andrei Lepikhov
• 2025/09/22 Re: Indexes on expressions with multiple columns and operators Frédéric Yhuel
• 2025/09/20 Re: Indexes on expressions with multiple columns and operators Tom Lane
• 2025/09/19 Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column Tom Lane
• 2025/09/19 Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column Matt Long
• 2025/09/19 Re: Indexes on expressions with multiple columns and operators Jehan-Guillaume de Rorthais
• 2025/09/19 Re: Why isn't PG using an index-only scan? Andrei Lepikhov
• 2025/09/19 Re: Indexes on expressions with multiple columns and operators Frédéric Yhuel
• 2025/09/18 Re: Why isn't PG using an index-only scan? David Rowley
• 2025/09/18 Re: Why isn't PG using an index-only scan? Jean-Christophe BOGGIO
• 2025/09/18 Re: Indexes on expressions with multiple columns and operators Tom Lane
• 2025/09/18 Re: Why isn't PG using an index-only scan? David Rowley
• 2025/09/18 Re: Indexes on expressions with multiple columns and operators Tom Lane
• 2025/09/18 Re: Indexes on expressions with multiple columns and operators Ranier Vilela
• 2025/09/18 Re: Indexes on expressions with multiple columns and operators Tom Lane
• 2025/09/18 Re: Indexes on expressions with multiple columns and operators Jehan-Guillaume de Rorthais
• 2025/09/18 Re: Why isn't PG using an index-only scan? Andrei Lepikhov
• 2025/09/18 Re: Why isn't PG using an index-only scan? Andrei Lepikhov
• 2025/09/18 Re: Why isn't PG using an index-only scan? David Rowley
• 2025/09/18 Re: Why isn't PG using an index-only scan? David Rowley
• 2025/09/17 Why isn't PG using an index-only scan? Jean-Christophe BOGGIO
• 2025/09/17 Re: Indexes on expressions with multiple columns and operators Frédéric Yhuel
• 2025/09/17 Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column Tom Lane
• 2025/09/17 Indexes on expressions with multiple columns and operators Frédéric Yhuel
• 2025/09/17 Re: Indexes on expressions with multiple columns and operators Frédéric Yhuel
• 2025/09/17 Re: Indexes on expressions with multiple columns and operators Tom Lane
• 2025/09/17 Re: Indexes on expressions with multiple columns and operators Laurenz Albe
• 2025/09/09 Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column Tom Lane
• 2025/09/08 Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column Matt Long
• 2025/09/02 Re: Planner makes sub-optimal execution plan Alena Rybakina
• 2025/09/01 Re: Planner makes sub-optimal execution plan David Rowley
• 2025/09/01 Planner makes sub-optimal execution plan Алексей Борщёв
• 2025/08/29 Re: Any way to get nested loop index joins on CTEs? Renan Alves Fonseca
• 2025/08/26 Re: Keeping some tables in cache Laurenz Albe
• 2025/08/26 Re: Keeping some tables in cache Achilleas Mantzios
• 2025/08/26 Keeping some tables in cache Ertan Küçükoglu
• 2025/08/19 Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet Frédéric Yhuel
• 2025/08/19 Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet Frits Hoogland
• 2025/08/18 Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet Frédéric Yhuel
• 2025/08/15 Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet Jorge Rodriguez
• 2025/08/12 Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet Bruce Momjian
• 2025/08/08 Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet Frits Hoogland
• 2025/08/06 Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet Joe Conway
• 2025/08/06 Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet Frits Hoogland
• 2025/08/06 Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet Joe Conway
• 2025/08/06 Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet Priya V
• 2025/08/06 Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet Frits Hoogland
• 2025/08/05 Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet Joe Conway
• 2025/08/05 Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet Priya V
• 2025/07/28 Making Postgres slower Bruce Momjian
• 2025/07/23 Re: [PATCH] ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized Dimitrios Apostolou
• 2025/07/20 Re: [PATCH] ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized Stepan Neretin
• 2025/07/19 Re: Question: Is it valid for a parent node's total cost to be lower than a child's total cost in EXPLAIN? Tom Lane
• 2025/07/19 Question: Is it valid for a parent node's total cost to be lower than a child's total cost in EXPLAIN? Xuan Chen
• 2025/07/18 Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column Tom Lane
• 2025/07/18 Re: Is there a way to identify a plan generated by GECO? Jerry Brenner
• 2025/07/17 Re: Is there a way to identify a plan generated by GECO? Tom Lane
• 2025/07/17 Re: Is there a way to identify a plan generated by GECO? Jerry Brenner
• 2025/07/17 Re: Is there a way to identify a plan generated by GECO? Tom Lane
• 2025/07/17 Re: Is there a way to identify a plan generated by GECO? Nikolay Samokhvalov
• 2025/07/17 Is there a way to identify a plan generated by GECO? Jerry Brenner
• 2025/07/16 Re: Any way to get nested loop index joins on CTEs? Jean-Christophe BOGGIO
• 2025/07/15 Any way to get nested loop index joins on CTEs? Clemens Eisserer
• 2025/07/08 Re: WAL Replay Buffer Invalidation Conflicts During Page Truncation on Read Replicas Dharin Shah
• 2025/07/08 Re: WAL Replay Buffer Invalidation Conflicts During Page Truncation on Read Replicas Álvaro Herrera
• 2025/07/08 WAL Replay Buffer Invalidation Conflicts During Page Truncation on Read Replicas Dharin Shah
• 2025/07/04 Re: Guidance Needed: Scaling PostgreSQL for 12 TB Data Growth - New Feature Implementation Greg Sabino Mullane
• 2025/06/26 Re: many sessions waiting DataFileRead and extend Robert Haas
• 2025/06/26 Re: many sessions waiting DataFileRead and extend James Pang
• 2025/06/26 Re: many sessions waiting DataFileRead and extend Frits Hoogland
• 2025/06/26 Re: many sessions waiting DataFileRead and extend James Pang
• 2025/06/25 Re: many sessions waiting DataFileRead and extend James Pang
• 2025/06/25 Re: many sessions waiting DataFileRead and extend Frits Hoogland
• 2025/06/25 Re: many sessions waiting DataFileRead and extend James Pang
• 2025/06/25 Re: many sessions waiting DataFileRead and extend Tatsuo Ishii
• 2025/06/25 Re: many sessions waiting DataFileRead and extend Laurenz Albe
• 2025/06/25 Re: many sessions waiting DataFileRead and extend James Pang
• 2025/06/25 Re: many deletes and inserts on pg_class, total rows is 14200 rows in "pg_class", any idea why so many inserts/deletes on "pg_class" it's self? David G. Johnston
• 2025/06/25 many deletes and inserts on pg_class, total rows is 14200 rows in "pg_class", any idea why so many inserts/deletes on "pg_class" it's self? James Pang
• 2025/06/25 Re: many sessions waiting DataFileRead and extend Frits Hoogland
• 2025/06/25 Guidance Needed: Scaling PostgreSQL for 12 TB Data Growth - New Feature Implementation Motog Plus
• 2025/06/25 Re: many sessions waiting DataFileRead and extend James Pang
• 2025/06/24 Re: many sessions waiting DataFileRead and extend Laurenz Albe
• 2025/06/24 many sessions waiting DataFileRead and extend James Pang
• 2025/06/17 Re: [PATCH] ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized Dimitrios Apostolou
• 2025/06/13 Re: Performance implications of 8K pread()s Dimitrios Apostolou
• 2025/06/09 [PATCH] ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized Dimitrios Apostolou
• 2025/06/06 Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column Tom Lane
• 2025/06/06 RE: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column Mark Frost
• 2025/06/06 Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column Frédéric Yhuel
• 2025/06/05 Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column Tom Lane
• 2025/06/05 Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column Tom Lane
• 2025/06/05 Re: Database creation performance drop going from pg 14 to pg 15+ Mahdi Bahrami
• 2025/06/05 Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column Frédéric Yhuel
• 2025/06/05 Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column Mark Frost
• 2025/06/05 Re: ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized Frédéric Yhuel
• 2025/06/05 Re: ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized Frédéric Yhuel
• 2025/06/04 Re: ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized Dimitrios Apostolou
• 2025/06/04 Re: ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized Frédéric Yhuel
• 2025/06/03 ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized Dimitrios Apostolou
• 2025/05/28 Re: Database creation performance drop going from pg 14 to pg 15+ Mahdi Bahrami
• 2025/05/28 Re: Database creation performance drop going from pg 14 to pg 15+ Thomas Munro
• 2025/05/28 Re: Database creation performance drop going from pg 14 to pg 15+ Mahdi Bahrami
• 2025/05/27 Re: Database creation performance drop going from pg 14 to pg 15+ Álvaro Herrera
• 2025/05/18 Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Andrei Lepikhov
• 2025/05/15 Re: a lot of session wait on lock relation James Pang
• 2025/05/15 Re: a lot of session wait on lock relation James Pang
• 2025/05/15 Re: a lot of session wait on lock relation Tom Lane
• 2025/05/15 Re: a lot of session wait on lock relation Laurenz Albe
• 2025/05/15 Re: a lot of session wait on lock relation Chetan
• 2025/05/15 a lot of session wait on lock relation James Pang
• 2025/05/13 Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Maxim Boguk
• 2025/05/13 Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) David Rowley
• 2025/05/12 Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Andrei Lepikhov
• 2025/05/12 Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Tom Lane
• 2025/05/12 Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Maxim Boguk
• 2025/05/12 Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Andrei Lepikhov
• 2025/05/12 Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Tom Lane
• 2025/05/12 Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Maxim Boguk
• 2025/05/12 Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) David Rowley
• 2025/05/12 Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Maxim Boguk
• 2025/05/12 Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Maxim Boguk
• 2025/05/12 Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Andrei Lepikhov
• 2025/05/12 Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Maxim Boguk
• 2025/05/12 Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Andrei Lepikhov
• 2025/05/12 inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Maxim Boguk
• 2025/05/05 Re: Vacuum Questions Craig Jackson
• 2025/05/05 Re: Vacuum Questions Craig Jackson
• 2025/05/03 RE: Vacuum Questions msalais
• 2025/05/02 Re: Vacuum Questions John Naylor
• 2025/05/02 Re: Vacuum Questions Leo
• 2025/05/02 Vacuum Questions Leo
• 2025/04/30 Re: PostgreSQL Choosing Full Index Over Partial Index Tom Lane
• 2025/04/30 Re: PostgreSQL Choosing Full Index Over Partial Index Felipe López Montes
• 2025/04/28 Re: PostgreSQL Choosing Full Index Over Partial Index Tom Lane
• 2025/04/28 Re: PostgreSQL Choosing Full Index Over Partial Index Felipe López Montes
• 2025/04/28 Re: PostgreSQL Choosing Full Index Over Partial Index Laurenz Albe
• 2025/04/28 PostgreSQL Choosing Full Index Over Partial Index Felipe López Montes
• 2025/04/16 Re: Constraints elimination during runtime Laurenz Albe
• 2025/04/16 Constraints elimination during runtime Weck, Luis
• 2025/04/15 Re: many sessions wait on LWlock WALWrite suddenly Yura Sokolov
• 2025/04/15 Re: many sessions wait on LWlock WALWrite suddenly Yura Sokolov

• Earlier messages