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 |
|---|---|---|
| Very slow query performance when using CTE | Chris Joysn | 13:37 |
| Re: Very slow query performance when using CTE | Tom Lane | 14:28 |
| Re: Very slow query performance when using CTE | Renan Alves Fonseca | 20:03 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: proposal: schema variables 📎 | Pavel Stehule | 06:46 |
| partition table optimizer join cost misestimation 📎 | James Pang | 10:18 |
| Re: partition table optimizer join cost misestimation | Andrei Lepikhov | 11:03 |
| Thread | Author | Time |
|---|---|---|
| Re: partition table optimizer join cost misestimation 📎 | James Pang | 00:46 |
| Re: partition table optimizer join cost misestimation | Andrei Lepikhov | 06:32 |
| Fwd: Very slow query performance when using CTE | Chris Joysn | 07:20 |
| Fwd: Very slow query performance when using CTE | Chris Joysn | 07:21 |
| Re: Very slow query performance when using CTE | Michael Christofides | 09:10 |
| Re: partition table optimizer join cost misestimation | James Pang | 12:38 |
| Re: Very slow query performance when using CTE | Chris Joysn | 13:34 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: proposal: schema variables 📎 | Pavel Stehule | 10:33 |
| Thread | Author | Time |
|---|---|---|
| Question on what Duration in the log | Vitale, Anthony, Sony Music | 14:27 |
| Re: Question on what Duration in the log | Tom Lane | 15:02 |
| RE: Question on what Duration in the log | Vitale, Anthony, Sony Music | 15:47 |
| Thread | Author | Time |
|---|---|---|
| Re: parallel pg_restore blocks on heavy random read I/O on all children processes | Hannu Krosing | 06:50 |
| Thread | Author | Time |
|---|---|---|
| many sessions wait on LWlock WALWrite suddenly | James Pang | 14:36 |
| Re: many sessions wait on LWlock WALWrite suddenly | Laurenz Albe | 19:59 |
| Re: many sessions wait on LWlock WALWrite suddenly | MichaelDBA | 22:43 |
| Thread | Author | Time |
|---|---|---|
| session waiting IO while background writer writing data | James Pang | 05:30 |
| Thread | Author | Time |
|---|---|---|
| Re: many sessions wait on LWlock WALWrite suddenly | Yura Sokolov | 09:16 |
| Re: many sessions wait on LWlock WALWrite suddenly | Andres Freund | 10:00 |
| Re: many sessions wait on LWlock WALWrite suddenly | Yura Sokolov | 10:44 |
| Re: many sessions wait on LWlock WALWrite suddenly | Andres Freund | 10:53 |
| Re: many sessions wait on LWlock WALWrite suddenly | Yura Sokolov | 10:58 |
| Thread | Author | Time |
|---|---|---|
| Constraints elimination during runtime | Weck, Luis | 11:16 |
| Re: Constraints elimination during runtime | Laurenz Albe | 12:38 |
| Thread | Author | Time |
|---|---|---|
| PostgreSQL Choosing Full Index Over Partial Index | Felipe López Montes | 13:22 |
| Re: PostgreSQL Choosing Full Index Over Partial Index | Laurenz Albe | 13:35 |
| Re: PostgreSQL Choosing Full Index Over Partial Index | Felipe López Montes | 14:54 |
| Re: PostgreSQL Choosing Full Index Over Partial Index | Tom Lane | 15:07 |
| Thread | Author | Time |
|---|---|---|
| Re: PostgreSQL Choosing Full Index Over Partial Index | Felipe López Montes | 09:11 |
| Re: PostgreSQL Choosing Full Index Over Partial Index | Tom Lane | 14:14 |
| Thread | Author | Time |
|---|---|---|
| Vacuum Questions | Leo | 14:23 |
| Re: Vacuum Questions | Leo | 16:04 |
| Re: Vacuum Questions | John Naylor | 23:49 |
| Thread | Author | Time |
|---|---|---|
| RE: Vacuum Questions | msalais | 19:46 |
| Thread | Author | Time |
|---|---|---|
| Re: Vacuum Questions | Craig Jackson | 14:33 |
| Re: Vacuum Questions | Craig Jackson | 14:35 |
| Thread | Author | Time |
|---|---|---|
| Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) | Andrei Lepikhov | 04:25 |
| Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) | David Rowley | 11:20 |
| Thread | Author | Time |
|---|---|---|
| Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) | Maxim Boguk | 00:47 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: proposal: schema variables 📎 | Pavel Stehule | 06:48 |
| a lot of session wait on lock relation | James Pang | 08:27 |
| Re: a lot of session wait on lock relation | Chetan | 09:31 |
| Re: a lot of session wait on lock relation | Laurenz Albe | 12:08 |
| Re: a lot of session wait on lock relation | Tom Lane | 13:24 |
| Re: a lot of session wait on lock relation | James Pang | 13:32 |
| Re: a lot of session wait on lock relation | James Pang | 13:43 |
| Database creation performance drop going from pg 14 to pg 15+ 📎 | Mahdi Bahrami | 16:28 |
| Thread | Author | Time |
|---|---|---|
| Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) | Andrei Lepikhov | 16:54 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: proposal: schema variables | Bruce Momjian | 14:56 |
| Re: Re: proposal: schema variables | Marcos Pegoraro | 16:33 |
| Re: Re: proposal: schema variables | Bruce Momjian | 16:39 |
| Re: proposal: schema variables | Daniel Gustafsson | 18:47 |
| Re: proposal: schema variables | Bruce Momjian | 20:28 |
| Re: Re: proposal: schema variables | Pavel Stehule | 20:28 |
| Re: proposal: schema variables | Laurenz Albe | 20:36 |
| Re: proposal: schema variables | Bruce Momjian | 21:06 |
| Re: Re: proposal: schema variables | Bruce Momjian | 21:10 |
| Thread | Author | Time |
|---|---|---|
| Re: Re: proposal: schema variables | Michael Paquier | 00:21 |
| Re: proposal: schema variables | Pavel Stehule | 05:15 |
| Re: Re: proposal: schema variables | Pavel Stehule | 05:49 |
| Re: proposal: schema variables | Laurenz Albe | 06:27 |
| Re: proposal: schema variables | Pavel Stehule | 06:36 |
| Re: proposal: schema variables | Pavel Stehule | 07:12 |
| Re: proposal: schema variables | Bruce Momjian | 20:41 |
| Re: proposal: schema variables | Bruce Momjian | 21:22 |
| Re: Re: proposal: schema variables | Bruce Momjian | 21:23 |
| Thread | Author | Time |
|---|---|---|
| Re: Database creation performance drop going from pg 14 to pg 15+ 📎 | Mahdi Bahrami | 08:12 |
| Re: Database creation performance drop going from pg 14 to pg 15+ | Álvaro Herrera | 15:07 |
| Thread | Author | Time |
|---|---|---|
| Re: Database creation performance drop going from pg 14 to pg 15+ | Mahdi Bahrami | 11:09 |
| Re: Database creation performance drop going from pg 14 to pg 15+ | Thomas Munro | 11:29 |
| Re: Database creation performance drop going from pg 14 to pg 15+ | Mahdi Bahrami | 12:15 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 07:26 |
| Re: proposal: schema variables 📎 | Pavel Stehule | 11:43 |
| ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized | Dimitrios Apostolou | 15:34 |
| Thread | Author | Time |
|---|---|---|
| Re: ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized | Frédéric Yhuel | 07:00 |
| Re: ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized | Dimitrios Apostolou | 14:12 |
| Re: proposal: schema variables 📎 | Pavel Stehule | 20:22 |
| Thread | Author | Time |
|---|---|---|
| Re: ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized | Frédéric Yhuel | 14:13 |
| Re: ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized | Frédéric Yhuel | 14:51 |
| Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column | Mark Frost | 15:42 |
| Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column | Frédéric Yhuel | 17:09 |
| Re: Database creation performance drop going from pg 14 to pg 15+ | Mahdi Bahrami | 18:25 |
| Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column | Tom Lane | 18:57 |
| Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column | Tom Lane | 21:52 |
| Thread | Author | Time |
|---|---|---|
| Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column | Frédéric Yhuel | 08:07 |
| RE: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column | Mark Frost | 09:21 |
| Thread | Author | Time |
|---|---|---|
| Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column 📎 | Tom Lane | 01:29 |
| Thread | Author | Time |
|---|---|---|
| [PATCH] ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized 📎 | Dimitrios Apostolou | 00:51 |
| Re: proposal: schema variables 📎 | Pavel Stehule | 14:25 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 04:53 |
| Re: Performance implications of 8K pread()s | Dimitrios Apostolou | 12:15 |
| Thread | Author | Time |
|---|---|---|
| Re: [PATCH] ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized | Dimitrios Apostolou | 16:23 |
| Thread | Author | Time |
|---|---|---|
| many sessions waiting DataFileRead and extend | James Pang | 03:15 |
| Re: many sessions waiting DataFileRead and extend | Laurenz Albe | 05:59 |
| Guidance Needed: Scaling PostgreSQL for 12 TB Data Growth - New Feature Implementation | Motog Plus | 08:35 |
| Guidance Needed: Scaling PostgreSQL for 12 TB Data Growth - New Feature Implementation | Motog Plus | 08:48 |
| Re: many sessions waiting DataFileRead and extend | James Pang | 09:10 |
| Re: many sessions waiting DataFileRead and extend | Frits Hoogland | 14:27 |
| Re: proposal: schema variables 📎 | Pavel Stehule | 17:33 |
| Thread | Author | Time |
|---|---|---|
| Re: Guidance Needed: Scaling PostgreSQL for 12 TB Data Growth - New Feature Implementation | Greg Sabino Mullane | 13:45 |
| Thread | Author | Time |
|---|---|---|
| WAL Replay Buffer Invalidation Conflicts During Page Truncation on Read Replicas | Dharin Shah | 08:12 |
| Re: WAL Replay Buffer Invalidation Conflicts During Page Truncation on Read Replicas | Álvaro Herrera | 14:05 |
| Re: WAL Replay Buffer Invalidation Conflicts During Page Truncation on Read Replicas | Dharin Shah | 21:15 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 19:55 |
| Thread | Author | Time |
|---|---|---|
| Any way to get nested loop index joins on CTEs? | Clemens Eisserer | 13:29 |
| Thread | Author | Time |
|---|---|---|
| Re: Any way to get nested loop index joins on CTEs? | Jean-Christophe BOGGIO | 11:24 |
| Thread | Author | Time |
|---|---|---|
| Is there a way to identify a plan generated by GECO? | Jerry Brenner | 01:09 |
| Re: Is there a way to identify a plan generated by GECO? | Nikolay Samokhvalov | 01:43 |
| Re: Is there a way to identify a plan generated by GECO? | Tom Lane | 01:57 |
| Re: Is there a way to identify a plan generated by GECO? | Jerry Brenner | 02:30 |
| Re: Is there a way to identify a plan generated by GECO? | Tom Lane | 03:10 |
| Re: Is there a way to identify a plan generated by GECO? | Jerry Brenner | 13:20 |
| Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column 📎 | Tom Lane | 21:54 |
| Thread | Author | Time |
|---|---|---|
| Question: Is it valid for a parent node's total cost to be lower than a child's total cost in EXPLAIN? | Xuan Chen | 23:03 |
| Thread | Author | Time |
|---|---|---|
| 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 | 01:57 |
| Thread | Author | Time |
|---|---|---|
| Re: [PATCH] ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized 📎 | Stepan Neretin | 05:58 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 05:53 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 15:25 |
| Re: [PATCH] ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized | Dimitrios Apostolou | 21:23 |
| Thread | Author | Time |
|---|---|---|
| Making Postgres slower | Bruce Momjian | 13:31 |
| Thread | Author | Time |
|---|---|---|
| Re: proposal: schema variables 📎 | Pavel Stehule | 05:30 |
| Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet | Priya V | 17:01 |
| Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet | Joe Conway | 18:52 |
| Thread | Author | Time |
|---|---|---|
| Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet | Frits Hoogland | 08:47 |
| Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet | Priya V | 15:51 |
| Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet | Joe Conway | 16:33 |
| Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet | Frits Hoogland | 21:14 |
| Thread | Author | Time |
|---|---|---|
| Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet | Joe Conway | 01:12 |
| Thread | Author | Time |
|---|---|---|
| Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet | Frits Hoogland | 08:21 |
| 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 |