pgsql-performance since 2025-02-12 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

Feb. 12, 2025

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

Feb. 16, 2025

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

Feb. 17, 2025

Thread Author Time
Re: Query planning read a large amount of buffers for partitioned tables bruno vieira da silva 20:18
Re: Query planning read a large amount of buffers for partitioned tables bruno vieira da silva 20:25
Re: Query planning read a large amount of buffers for partitioned tables bruno vieira da silva 20:27

Feb. 18, 2025

Thread Author Time
Re: Query planning read a large amount of buffers for partitioned tables David Rowley 12:16
Re: Query planning read a large amount of buffers for partitioned tables bruno vieira da silva 15:48

Feb. 20, 2025

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

Feb. 21, 2025

Thread Author Time
Unfortunate Nested Loop + Missing Autovacuum Lincoln Swaine-Moore 23:46

Feb. 22, 2025

Thread Author Time
Re: Unfortunate Nested Loop + Missing Autovacuum Andrei Lepikhov 08:37

Feb. 23, 2025

Thread Author Time
Re: Unfortunate Nested Loop + Missing Autovacuum Lincoln Swaine-Moore 22:49

Feb. 24, 2025

Thread Author Time
Re: Unfortunate Nested Loop + Missing Autovacuum Jeff Janes 02:08
Re: Unfortunate Nested Loop + Missing Autovacuum Andrei Lepikhov 14:01

Feb. 25, 2025

Thread Author Time
Re: Unfortunate Nested Loop + Missing Autovacuum Lincoln Swaine-Moore 02:17

Feb. 26, 2025

Thread Author Time
Efficient pagination using multi-column cursors large.goose2829 14:27
Re: Efficient pagination using multi-column cursors Peter Geoghegan 15:05
Re: Efficient pagination using multi-column cursors large.goose2829 15:40
Re: Efficient pagination using multi-column cursors Peter Geoghegan 16:14
Re: Efficient pagination using multi-column cursors Laurenz Albe 16:15

Feb. 27, 2025

Thread Author Time
Slow performance of collate "en_US.utf8" 📎 Alexey Borschev 13:54

Feb. 28, 2025

Thread Author Time
Re: Slow performance of collate "en_US.utf8" Achilleas Mantzios - cloud 12:59
Re: Slow performance of collate "en_US.utf8" Laurenz Albe 14:16
Re: Slow performance of collate "en_US.utf8" Joe Conway 20:02
Re: Slow performance of collate "en_US.utf8" Thomas Munro 22:49
Re: [PERFORM] Unused index influencing sequential scan plan Thom Brown 23:19

March 1, 2025

Thread Author Time
Re: Slow performance of collate "en_US.utf8" Joe Conway 00:11
Re: Re: proposal: schema variables 📎 Pavel Stehule 07:23

March 3, 2025

Thread Author Time
Slow performance of collate "en_US.utf8" Alexey Borschev 08:47

March 6, 2025

Thread Author Time
Asking for OK for a nasty trick to resolve PG CVE-2025-1094 i Abraham, Danny 07:39
Re: Asking for OK for a nasty trick to resolve PG CVE-2025-1094 i Laurenz Albe 08:11
Re: Asking for OK for a nasty trick to resolve PG CVE-2025-1094 i Ron Johnson 08:27
Re: [EXTERNAL] Re: Asking for OK for a nasty trick to resolve PG CVE-2025-1094 i Abraham, Danny 09:33
Re: [EXTERNAL] Re: Asking for OK for a nasty trick to resolve PG CVE-2025-1094 i Ron Johnson 10:08
Re: [EXTERNAL] Re: Asking for OK for a nasty trick to resolve PG CVE-2025-1094 i Laurenz Albe 12:32

March 7, 2025

Thread Author Time
Re: [EXTERNAL] Re: Asking for OK for a nasty trick to resolve PG CVE-2025-1094 i Greg Sabino Mullane 13:24

March 13, 2025

Thread Author Time
Bulk DML performance bill.poole 04:05
Re: Bulk DML performance Laurenz Albe 09:21
RE: Bulk DML performance bill.poole 10:13
Re: Bulk DML performance Laurenz Albe 11:28
Re: Bulk DML performance Laurenz Albe 11:29
RE: Bulk DML performance bill.poole 13:04
Re: Bulk DML performance Renan Alves Fonseca 21:25

March 14, 2025

Thread Author Time
RE: Bulk DML performance bill.poole 01:20

March 17, 2025

Thread Author Time
Re: Bulk DML performance Álvaro Herrera 10:53
Re: Bulk DML performance Greg Sabino Mullane 14:14
Bad perf when using DECLARE CURSOR on big table kimaidou 14:41
Re: Bad perf when using DECLARE CURSOR on big table Tom Lane 15:22
Re: Bulk DML performance Renan Alves Fonseca 17:45
Re: Re: proposal: schema variables 📎 Pavel Stehule 18:32
Re: Efficient pagination using multi-column cursors large.goose2829 19:52
Re: Re: proposal: schema variables Marcos Pegoraro 20:52

March 18, 2025

Thread Author Time
Background writer not active Motog Plus 04:04
Re: Re: proposal: schema variables Pavel Stehule 05:46
Re: Bad perf when using DECLARE CURSOR on big table kimaidou 07:48

March 19, 2025

Thread Author Time
PostgreSQL 16 - Detach partition with FK - Error Adithya Kumaranchath 12:07
Re: PostgreSQL 16 - Detach partition with FK - Error Álvaro Herrera 14:43
parallel pg_restore blocks on heavy random read I/O on all children processes Dimitrios Apostolou 18:46

March 20, 2025

Thread Author Time
Re: parallel pg_restore blocks on heavy random read I/O on all children processes Tom Lane 19:17
Re: parallel pg_restore blocks on heavy random read I/O on all children processes Dimitrios Apostolou 19:57

March 23, 2025

Thread Author Time
Re: parallel pg_restore blocks on heavy random read I/O on all children processes Tom Lane 15:46

March 24, 2025

Thread Author Time
Re: parallel pg_restore blocks on heavy random read I/O on all children processes Dimitrios Apostolou 16:43

March 27, 2025

Thread Author Time
Re: parallel pg_restore blocks on heavy random read I/O on all children processes Dimitrios Apostolou 23:45

March 29, 2025

Thread Author Time
Re: parallel pg_restore blocks on heavy random read I/O on all children processes Dimitrios Apostolou 00:48

April 1, 2025

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

April 2, 2025

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

April 3, 2025

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

April 5, 2025

Thread Author Time
Re: Re: proposal: schema variables 📎 Pavel Stehule 10:33

April 6, 2025

Thread Author Time
Memory Not Released After Batch Completion – Checkpointer/Background Writer Behavior , postgres 15 Motog Plus 12:36
Re: Memory Not Released After Batch Completion – Checkpointer/Background Writer Behavior , postgres 15 Евгений Чекан 14:05
Re: Memory Not Released After Batch Completion – Checkpointer/Background Writer Behavior , postgres 15 Motog Plus 16:02

April 9, 2025

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

April 10, 2025

Thread Author Time
Re: parallel pg_restore blocks on heavy random read I/O on all children processes Hannu Krosing 06:50

April 11, 2025

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

April 14, 2025

Thread Author Time
session waiting IO while background writer writing data James Pang 05:30

April 15, 2025

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

April 16, 2025

Thread Author Time
Constraints elimination during runtime Weck, Luis 11:16
Re: Constraints elimination during runtime Laurenz Albe 12:38

April 28, 2025

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

April 30, 2025

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

May 2, 2025

Thread Author Time
Vacuum Questions Leo 14:23
Re: Vacuum Questions Leo 16:04
Re: Vacuum Questions John Naylor 23:49

May 3, 2025

Thread Author Time
RE: Vacuum Questions msalais 19:46

May 5, 2025

Thread Author Time
Re: Vacuum Questions Craig Jackson 14:33
Re: Vacuum Questions Craig Jackson 14:35

May 12, 2025

Thread Author Time
inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Maxim Boguk 11:49
Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Andrei Lepikhov 12:08
Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Maxim Boguk 13:08
Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Andrei Lepikhov 13:48
Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Maxim Boguk 14:04
Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Maxim Boguk 14:21
Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) David Rowley 15:01
Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Maxim Boguk 15:18
Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Tom Lane 15:33
Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Andrei Lepikhov 17:22
Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Maxim Boguk 17:55
Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Tom Lane 18:07

May 13, 2025

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

May 14, 2025

Thread Author Time
Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Maxim Boguk 00:47

May 15, 2025

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

May 18, 2025

Thread Author Time
Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Andrei Lepikhov 16:54

May 20, 2025

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

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

Browse Archives

Prev | Next