pgsql-performance - June 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

Browse Archives

Prev | Next

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

Browse Archives

Prev | Next