pgsql-performance  

Messages by Thread

• Partition pruning is not happening (even in PG18) Lauro Ojeda
  • Re: Partition pruning is not happening (even in PG18) Michał Kłeczek
  • Re: Partition pruning is not happening (even in PG18) Michał Kłeczek
  • Re: Partition pruning is not happening (even in PG18) David Rowley
  • Re: Partition pruning is not happening (even in PG18) Chetan
• Very expensive update to update a single row Dirschel, Steve
  • Re: Very expensive update to update a single row Sean M
• Why isn't PG using an index-only scan? Jean-Christophe BOGGIO
  • Re: Why isn't PG using an index-only scan? David Rowley
  • Re: Why isn't PG using an index-only scan? Andrei Lepikhov
  • Re: Why isn't PG using an index-only scan? David Rowley
  • Re: Why isn't PG using an index-only scan? Andrei Lepikhov
  • Re: Why isn't PG using an index-only scan? David Rowley
  • Re: Why isn't PG using an index-only scan? Andrei Lepikhov
  • Re: Why isn't PG using an index-only scan? Jean-Christophe BOGGIO
  • Re: Why isn't PG using an index-only scan? David Rowley
• Indexes on expressions with multiple columns and operators Frédéric Yhuel
  • Re: Indexes on expressions with multiple columns and operators Laurenz Albe
  • Re: Indexes on expressions with multiple columns and operators Tom Lane
  • Re: Indexes on expressions with multiple columns and operators Frédéric Yhuel
  • Re: Indexes on expressions with multiple columns and operators Frédéric Yhuel
  • Re: Indexes on expressions with multiple columns and operators Tom Lane
  • Re: Indexes on expressions with multiple columns and operators Tom Lane
  • Re: Indexes on expressions with multiple columns and operators Ranier Vilela
  • Re: Indexes on expressions with multiple columns and operators Frédéric Yhuel
  • Re: Indexes on expressions with multiple columns and operators Tom Lane
  • Re: Indexes on expressions with multiple columns and operators Frédéric Yhuel
  • Re: Indexes on expressions with multiple columns and operators Andrei Lepikhov
  • Re: Indexes on expressions with multiple columns and operators Frédéric Yhuel
  • Re: Indexes on expressions with multiple columns and operators Frédéric Yhuel
  • Re: Indexes on expressions with multiple columns and operators Andrei Lepikhov
  • Re: Indexes on expressions with multiple columns and operators Frédéric Yhuel
  • Re: Indexes on expressions with multiple columns and operators Frédéric Yhuel
  • Re: Indexes on expressions with multiple columns and operators Jehan-Guillaume de Rorthais
  • Re: Indexes on expressions with multiple columns and operators Tom Lane
  • Re: Indexes on expressions with multiple columns and operators Jehan-Guillaume de Rorthais
• Planner makes sub-optimal execution plan Алексей Борщёв
  • Re: Planner makes sub-optimal execution plan Alena Rybakina
  • Re: Planner makes sub-optimal execution plan David Rowley
• Keeping some tables in cache Ertan Küçükoglu
  • Re: Keeping some tables in cache Achilleas Mantzios
  • Re: Keeping some tables in cache Laurenz Albe
• Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet Priya V
  • Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet Joe Conway
  • Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet Frits Hoogland
  • Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet Priya V
  • Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet Joe Conway
  • Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet Frits Hoogland
  • Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet Joe Conway
  • Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet Frits Hoogland
  • Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet Frédéric Yhuel
  • Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet Frits Hoogland
  • Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet Frédéric Yhuel
  • Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet Bruce Momjian
  • Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet Jorge Rodriguez
• Making Postgres slower Bruce Momjian
• Question: Is it valid for a parent node's total cost to be lower than a child's total cost in EXPLAIN? Xuan Chen
  • 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
• Is there a way to identify a plan generated by GECO? Jerry Brenner
  • Re: Is there a way to identify a plan generated by GECO? Nikolay Samokhvalov
  • Re: Is there a way to identify a plan generated by GECO? Tom Lane
  • Re: Is there a way to identify a plan generated by GECO? Jerry Brenner
  • Re: Is there a way to identify a plan generated by GECO? Tom Lane
  • Re: Is there a way to identify a plan generated by GECO? Jerry Brenner
• Any way to get nested loop index joins on CTEs? Clemens Eisserer
  • Re: Any way to get nested loop index joins on CTEs? Jean-Christophe BOGGIO
  • Re: Any way to get nested loop index joins on CTEs? Renan Alves Fonseca
• WAL Replay Buffer Invalidation Conflicts During Page Truncation on Read Replicas Dharin Shah
  • Re: WAL Replay Buffer Invalidation Conflicts During Page Truncation on Read Replicas Álvaro Herrera
  • Re: WAL Replay Buffer Invalidation Conflicts During Page Truncation on Read Replicas Dharin Shah
• 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
  • 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
• Guidance Needed: Scaling PostgreSQL for 12 TB Data Growth - New Feature Implementation Motog Plus
  • Re: Guidance Needed: Scaling PostgreSQL for 12 TB Data Growth - New Feature Implementation Greg Sabino Mullane
• many sessions waiting DataFileRead and extend James Pang
  • Re: many sessions waiting DataFileRead and extend Laurenz Albe
  • Re: many sessions waiting DataFileRead and extend James Pang
  • Re: many sessions waiting DataFileRead and extend Frits Hoogland
  • Re: many sessions waiting DataFileRead and extend James Pang
  • Re: many sessions waiting DataFileRead and extend Laurenz Albe
  • Re: many sessions waiting DataFileRead and extend Tatsuo Ishii
  • Re: many sessions waiting DataFileRead and extend James Pang
  • Re: many sessions waiting DataFileRead and extend Frits Hoogland
  • Re: many sessions waiting DataFileRead and extend James Pang
  • Re: many sessions waiting DataFileRead and extend James Pang
  • Re: many sessions waiting DataFileRead and extend Frits Hoogland
  • Re: many sessions waiting DataFileRead and extend James Pang
  • Re: many sessions waiting DataFileRead and extend Robert Haas
• Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column Mark Frost
  • Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column Frédéric Yhuel
  • RE: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column Mark Frost
  • Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column Tom Lane
  • Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column Tom Lane
  • Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column Matt Long
  • Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column Tom Lane
  • Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column Tom Lane
  • Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column Matt Long
  • Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column Tom Lane
  • Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column Tom Lane
  • Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column Tom Lane
  • Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column Frédéric Yhuel
• ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized Dimitrios Apostolou
  • Re: ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized Frédéric Yhuel
  • Re: ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized Dimitrios Apostolou
  • Re: ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized Frédéric Yhuel
  • Re: ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized Frédéric Yhuel
  • [PATCH] ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized Dimitrios Apostolou
  • Re: [PATCH] ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized Dimitrios Apostolou
  • Re: [PATCH] ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized Stepan Neretin
  • Re: [PATCH] ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized Dimitrios Apostolou
• Re: Database creation performance drop going from pg 14 to pg 15+ Álvaro Herrera
  • Re: Database creation performance drop going from pg 14 to pg 15+ Mahdi Bahrami
  • Re: Database creation performance drop going from pg 14 to pg 15+ Thomas Munro
  • Re: Database creation performance drop going from pg 14 to pg 15+ Mahdi Bahrami
  • Re: Database creation performance drop going from pg 14 to pg 15+ Mahdi Bahrami
• a lot of session wait on lock relation James Pang
  • Re: a lot of session wait on lock relation Chetan
  • Re: a lot of session wait on lock relation Laurenz Albe
  • Re: a lot of session wait on lock relation Tom Lane
  • Re: a lot of session wait on lock relation James Pang
  • Re: a lot of session wait on lock relation James Pang
• inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Maxim Boguk
  • Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Andrei Lepikhov
  • Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Maxim Boguk
  • Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Andrei Lepikhov
  • Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Maxim Boguk
  • Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Andrei Lepikhov
  • Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Andrei Lepikhov
  • Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Maxim Boguk
  • Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) David Rowley
  • Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Maxim Boguk
  • Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Tom Lane
  • Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Maxim Boguk
  • Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Tom Lane
  • Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Andrei Lepikhov
  • Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Maxim Boguk
  • Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) David Rowley
• Vacuum Questions Leo
  • Re: Vacuum Questions Leo
  • Re: Vacuum Questions John Naylor
  • RE: Vacuum Questions msalais
  • Re: Vacuum Questions Craig Jackson
  • Re: Vacuum Questions Craig Jackson
• PostgreSQL Choosing Full Index Over Partial Index Felipe López Montes
  • Re: PostgreSQL Choosing Full Index Over Partial Index Laurenz Albe
  • Re: PostgreSQL Choosing Full Index Over Partial Index Felipe López Montes
  • Re: PostgreSQL Choosing Full Index Over Partial Index Tom Lane
  • Re: PostgreSQL Choosing Full Index Over Partial Index Felipe López Montes
  • Re: PostgreSQL Choosing Full Index Over Partial Index Tom Lane
• Constraints elimination during runtime Weck, Luis
  • Re: Constraints elimination during runtime Laurenz Albe
• session waiting IO while background writer writing data James Pang
• many sessions wait on LWlock WALWrite suddenly James Pang
  • Re: many sessions wait on LWlock WALWrite suddenly Laurenz Albe
  • Re: many sessions wait on LWlock WALWrite suddenly MichaelDBA
  • Re: many sessions wait on LWlock WALWrite suddenly Yura Sokolov
  • Re: many sessions wait on LWlock WALWrite suddenly Andres Freund
  • Re: many sessions wait on LWlock WALWrite suddenly Yura Sokolov
  • Re: many sessions wait on LWlock WALWrite suddenly Andres Freund
  • Re: many sessions wait on LWlock WALWrite suddenly Yura Sokolov
• Question on what Duration in the log Vitale, Anthony, Sony Music
  • Re: Question on what Duration in the log Tom Lane
  • RE: Question on what Duration in the log Vitale, Anthony, Sony Music
• Memory Not Released After Batch Completion – Checkpointer/Background Writer Behavior , postgres 15 Motog Plus
  • Re: Memory Not Released After Batch Completion – Checkpointer/Background Writer Behavior , postgres 15 Евгений Чекан
  • Re: Memory Not Released After Batch Completion – Checkpointer/Background Writer Behavior , postgres 15 Motog Plus
• partition table optimizer join cost misestimation James Pang
  • Re: partition table optimizer join cost misestimation Andrei Lepikhov
  • Re: partition table optimizer join cost misestimation James Pang
  • Re: partition table optimizer join cost misestimation Andrei Lepikhov
  • Re: partition table optimizer join cost misestimation James Pang
• Very slow query performance when using CTE Chris Joysn
  • Re: Very slow query performance when using CTE Tom Lane
  • Fwd: Very slow query performance when using CTE Chris Joysn
  • Re: Very slow query performance when using CTE Renan Alves Fonseca
  • Re: Very slow query performance when using CTE Michael Christofides
  • Re: Very slow query performance when using CTE Chris Joysn
• parallel pg_restore blocks on heavy random read I/O on all children processes Dimitrios Apostolou
  • Re: parallel pg_restore blocks on heavy random read I/O on all children processes Tom Lane
  • Re: parallel pg_restore blocks on heavy random read I/O on all children processes Dimitrios Apostolou
  • Re: parallel pg_restore blocks on heavy random read I/O on all children processes Tom Lane
  • Re: parallel pg_restore blocks on heavy random read I/O on all children processes Dimitrios Apostolou
  • Re: parallel pg_restore blocks on heavy random read I/O on all children processes Dimitrios Apostolou
  • Re: parallel pg_restore blocks on heavy random read I/O on all children processes Dimitrios Apostolou
  • Re: parallel pg_restore blocks on heavy random read I/O on all children processes Hannu Krosing
• PostgreSQL 16 - Detach partition with FK - Error Adithya Kumaranchath
  • Re: PostgreSQL 16 - Detach partition with FK - Error Álvaro Herrera
• Background writer not active Motog Plus
• Bad perf when using DECLARE CURSOR on big table kimaidou
  • Re: Bad perf when using DECLARE CURSOR on big table Tom Lane
  • Re: Bad perf when using DECLARE CURSOR on big table kimaidou
• Bulk DML performance bill.poole
  • Re: Bulk DML performance Laurenz Albe
  • RE: Bulk DML performance bill.poole
  • Re: Bulk DML performance Laurenz Albe
  • Re: Bulk DML performance Laurenz Albe
  • RE: Bulk DML performance bill.poole
  • Re: Bulk DML performance Álvaro Herrera
  • Re: Bulk DML performance Renan Alves Fonseca
  • Re: Bulk DML performance Greg Sabino Mullane

• Earlier messages