pgsql-performance  

Messages by Date

• 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
• 2025/04/15 Re: many sessions wait on LWlock WALWrite suddenly Andres Freund
• 2025/04/15 Re: many sessions wait on LWlock WALWrite suddenly Andres Freund
• 2025/04/15 Re: many sessions wait on LWlock WALWrite suddenly Yura Sokolov
• 2025/04/13 session waiting IO while background writer writing data James Pang
• 2025/04/11 Re: many sessions wait on LWlock WALWrite suddenly MichaelDBA
• 2025/04/11 Re: many sessions wait on LWlock WALWrite suddenly Laurenz Albe
• 2025/04/11 many sessions wait on LWlock WALWrite suddenly James Pang
• 2025/04/09 Re: parallel pg_restore blocks on heavy random read I/O on all children processes Hannu Krosing
• 2025/04/09 Question on what Duration in the log Vitale, Anthony, Sony Music
• 2025/04/09 RE: Question on what Duration in the log Vitale, Anthony, Sony Music
• 2025/04/09 Re: Question on what Duration in the log Tom Lane
• 2025/04/07 Re: Memory Not Released After Batch Completion – Checkpointer/Background Writer Behavior , postgres 15 Евгений Чекан
• 2025/04/06 Re: Memory Not Released After Batch Completion – Checkpointer/Background Writer Behavior , postgres 15 Motog Plus
• 2025/04/06 Memory Not Released After Batch Completion – Checkpointer/Background Writer Behavior , postgres 15 Motog Plus
• 2025/04/04 Re: parallel pg_restore blocks on heavy random read I/O on all children processes Tom Lane
• 2025/04/04 Fwd: Very slow query performance when using CTE Chris Joysn
• 2025/04/03 Re: Very slow query performance when using CTE Chris Joysn
• 2025/04/03 Re: partition table optimizer join cost misestimation James Pang
• 2025/04/03 Re: Very slow query performance when using CTE Michael Christofides
• 2025/04/02 Re: partition table optimizer join cost misestimation Andrei Lepikhov
• 2025/04/02 Re: partition table optimizer join cost misestimation James Pang
• 2025/04/02 Re: partition table optimizer join cost misestimation Andrei Lepikhov
• 2025/04/02 partition table optimizer join cost misestimation James Pang
• 2025/04/01 Re: Very slow query performance when using CTE Renan Alves Fonseca
• 2025/04/01 Re: Very slow query performance when using CTE Tom Lane
• 2025/04/01 Very slow query performance when using CTE Chris Joysn
• 2025/03/28 Re: parallel pg_restore blocks on heavy random read I/O on all children processes Dimitrios Apostolou
• 2025/03/27 Re: parallel pg_restore blocks on heavy random read I/O on all children processes Dimitrios Apostolou
• 2025/03/24 Re: parallel pg_restore blocks on heavy random read I/O on all children processes Dimitrios Apostolou
• 2025/03/23 Re: parallel pg_restore blocks on heavy random read I/O on all children processes Dimitrios Apostolou
• 2025/03/20 Re: parallel pg_restore blocks on heavy random read I/O on all children processes Tom Lane
• 2025/03/20 parallel pg_restore blocks on heavy random read I/O on all children processes Dimitrios Apostolou
• 2025/03/19 Re: PostgreSQL 16 - Detach partition with FK - Error Álvaro Herrera
• 2025/03/19 PostgreSQL 16 - Detach partition with FK - Error Adithya Kumaranchath
• 2025/03/18 Re: Bad perf when using DECLARE CURSOR on big table kimaidou
• 2025/03/17 Background writer not active Motog Plus
• 2025/03/17 Re: Efficient pagination using multi-column cursors large . goose2829
• 2025/03/17 Re: Bulk DML performance Renan Alves Fonseca
• 2025/03/17 Re: Bad perf when using DECLARE CURSOR on big table Tom Lane
• 2025/03/17 Bad perf when using DECLARE CURSOR on big table kimaidou
• 2025/03/17 Re: Bulk DML performance Greg Sabino Mullane
• 2025/03/17 Re: Bulk DML performance Álvaro Herrera
• 2025/03/17 RE: Bulk DML performance bill.poole
• 2025/03/17 RE: Bulk DML performance bill.poole
• 2025/03/17 RE: Bulk DML performance bill.poole
• 2025/03/13 Re: Bulk DML performance Renan Alves Fonseca
• 2025/03/13 Re: Bulk DML performance Laurenz Albe
• 2025/03/13 Re: Bulk DML performance Laurenz Albe
• 2025/03/13 Re: Bulk DML performance Laurenz Albe
• 2025/03/13 Bulk DML performance bill.poole
• 2025/03/05 Asking for OK for a nasty trick to resolve PG CVE-2025-1094 i Abraham, Danny
• 2025/03/03 Slow performance of collate "en_US.utf8" Alexey Borschev
• 2025/02/28 Re: Slow performance of collate "en_US.utf8" Joe Conway

• Earlier messages