pgsql-performance - July 2025

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)

Browse Archives

Prev | Next

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

Browse Archives

Prev | Next