pgsql-performance before 2025-11-10 00:00

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.

Search the Archives

(enter a message-id to go directly to that message)

Advanced Search

Browse Archives

Prev | Next

May 20, 2025

Thread	Author	Time
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

May 21, 2025

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

May 27, 2025

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

May 28, 2025

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

June 3, 2025

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

June 4, 2025

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

June 5, 2025

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

June 6, 2025

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

June 7, 2025

Thread	Author	Time
Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column 📎	Tom Lane	01:29

June 10, 2025

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

June 13, 2025

Thread	Author	Time
Re: proposal: schema variables 📎	Pavel Stehule	04:53
Re: Performance implications of 8K pread()s	Dimitrios Apostolou	12:15

June 17, 2025

Thread	Author	Time
Re: [PATCH] ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized	Dimitrios Apostolou	16:23

June 24, 2025

Thread	Author	Time
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	14:22
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	14:31

June 25, 2025

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

June 26, 2025

Thread	Author	Time
Re: many sessions waiting DataFileRead and extend	James Pang	02:32
Re: many sessions waiting DataFileRead and extend	Laurenz Albe	03:03
Re: many sessions waiting DataFileRead and extend	Tatsuo Ishii	03:25
Re: many sessions waiting DataFileRead and extend 📎	James Pang	03:48
Re: Guidance Needed: Scaling PostgreSQL for 12 TB Data Growth - New Feature Implementation	Motog Plus	05:11
Guidance Needed: Scaling PostgreSQL for 12 TB Data Growth - New Feature Implementation	David G. Johnston	05:40
Re: Guidance Needed: Scaling PostgreSQL for 12 TB Data Growth - New Feature Implementation	Motog Plus	06:34
Re: many sessions waiting DataFileRead and extend	Frits Hoogland	06:40
Re: many sessions waiting DataFileRead and extend	James Pang	06:47
Re: many sessions waiting DataFileRead and extend	James Pang	07:22
Re: many sessions waiting DataFileRead and extend	Frits Hoogland	08:07
Re: many sessions waiting DataFileRead and extend	James Pang	08:58
Re: many sessions waiting DataFileRead and extend	Robert Haas	12:19
Re: Guidance Needed: Scaling PostgreSQL for 12 TB Data Growth - New Feature Implementation	Ron Johnson	12:49
Re: Guidance Needed: Scaling PostgreSQL for 12 TB Data Growth - New Feature Implementation	Claus Koch	13:11
Re: Guidance Needed: Scaling PostgreSQL for 12 TB Data Growth - New Feature Implementation	Motog Plus	13:43
Re: Guidance Needed: Scaling PostgreSQL for 12 TB Data Growth - New Feature Implementation	Paul Smith*	14:30
Re: Guidance Needed: Scaling PostgreSQL for 12 TB Data Growth - New Feature Implementation	Ron Johnson	14:54

July 4, 2025

Thread	Author	Time
Re: Guidance Needed: Scaling PostgreSQL for 12 TB Data Growth - New Feature Implementation	Greg Sabino Mullane	13:45

July 8, 2025

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

July 11, 2025

Thread	Author	Time
Re: proposal: schema variables 📎	Pavel Stehule	19:55

July 15, 2025

Thread	Author	Time
Any way to get nested loop index joins on CTEs?	Clemens Eisserer	13:29

July 16, 2025

Thread	Author	Time
Re: Any way to get nested loop index joins on CTEs?	Jean-Christophe BOGGIO	11:24

July 18, 2025

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

July 19, 2025

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

July 20, 2025

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

July 21, 2025

Thread	Author	Time
Re: [PATCH] ALTER TABLE ADD FOREIGN KEY to partitioned table, is not parallelized 📎	Stepan Neretin	05:58

July 22, 2025

Thread	Author	Time
Re: proposal: schema variables 📎	Pavel Stehule	05:53

July 23, 2025

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

July 28, 2025

Thread	Author	Time
Making Postgres slower	Bruce Momjian	13:31

Aug. 5, 2025

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

Aug. 6, 2025

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

Aug. 7, 2025

Thread	Author	Time
Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet	Joe Conway	01:12

Aug. 8, 2025

Thread	Author	Time
Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet	Frits Hoogland	08:21

Aug. 12, 2025

Thread	Author	Time
Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet	Bruce Momjian	17:49

Aug. 13, 2025

Thread	Author	Time
Re: proposal: schema variables 📎	Pavel Stehule	19:24

Aug. 15, 2025

Thread	Author	Time
Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet	Jorge Rodriguez	15:14

Aug. 18, 2025

Thread	Author	Time
Re: Safe vm.overcommit_ratio for Large Multi-Instance PostgreSQL Fleet	Frédéric Yhuel	16:17

Aug. 19, 2025

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

Aug. 26, 2025

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

Aug. 29, 2025

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

Sept. 1, 2025

Thread	Author	Time
Planner makes sub-optimal execution plan	Алексей Борщёв	09:07
Re: Planner makes sub-optimal execution plan	Alena Rybakina	12:41

Sept. 2, 2025

Thread	Author	Time
Re: Planner makes sub-optimal execution plan	David Rowley	04:41

Sept. 8, 2025

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

Sept. 9, 2025

Thread	Author	Time
Re: Poor row estimates from planner, stat `most_common_elems` sometimes missing for a text[] column	Tom Lane	19:19

Sept. 13, 2025

Thread	Author	Time
Re: proposal: schema variables 📎	Pavel Stehule	09:28

Sept. 15, 2025

Thread	Author	Time
Re: proposal: schema variables	Jim Jones	08:21
Re: proposal: schema variables 📎	Pavel Stehule	16:55

Sept. 17, 2025

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

Sept. 18, 2025

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

Sept. 19, 2025

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

Sept. 20, 2025

Thread	Author	Time
Re: Indexes on expressions with multiple columns and operators	Tom Lane	16:51

Sept. 22, 2025

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

Sept. 23, 2025

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

Sept. 25, 2025

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

Sept. 29, 2025

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

Oct. 6, 2025

Thread	Author	Time
Re: proposal: schema variables 📎	Pavel Stehule	05:54

Oct. 9, 2025

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

Oct. 10, 2025

Thread	Author	Time
Re: Poor performance with row wise comparisons	lokesh	04:21
Re: Question about nested loops..	Andrei Lepikhov	09:28

Oct. 11, 2025

Thread	Author	Time
Re: Poor performance with row wise comparisons	David G. Johnston	23:03

Oct. 12, 2025

Thread	Author	Time
Re: proposal: schema variables 📎	Pavel Stehule	04:57

Oct. 13, 2025

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

Oct. 14, 2025

Thread	Author	Time
Re: Indexes on expressions with multiple columns and operators	Andrei Lepikhov	09:29

Oct. 22, 2025

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

Oct. 23, 2025

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

Oct. 24, 2025

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

Oct. 27, 2025

Thread	Author	Time
GEQO plans much slower than standard join plans 📎	Carlo Sganzerla	18:17

Oct. 28, 2025

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

Oct. 29, 2025

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

Oct. 30, 2025

Thread	Author	Time
Re: proposal: schema variables 📎	Pavel Stehule	16:27

Oct. 31, 2025

Thread	Author	Time
Re: GEQO plans much slower than standard join plans	David Rowley	01:19

Nov. 2, 2025

Thread	Author	Time
Re: proposal: schema variables 📎	Pavel Stehule	20:40

Nov. 5, 2025

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

Nov. 6, 2025

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

Nov. 7, 2025

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

Browse Archives

Prev | Next