pgsql-performance since 2024-06-17 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

June 17, 2024

Thread Author Time
performance of sql and plpgsql functions Julius Tuskenis 09:35
Re: performance of sql and plpgsql functions Pavel Stehule 09:44
Re: performance of sql and plpgsql functions Julius Tuskenis 11:01
Re: performance of sql and plpgsql functions Philip Semanchuk 12:59
Re: performance of sql and plpgsql functions Julius Tuskenis 13:54
Re: performance of sql and plpgsql functions Pavel Stehule 14:07
Re: performance of sql and plpgsql functions Tom Lane 14:24

June 18, 2024

Thread Author Time
Re: performance of sql and plpgsql functions Julius Tuskenis 13:03

June 24, 2024

Thread Author Time
Row level security Thomas Simpson 22:28

June 27, 2024

Thread Author Time
Inconsistent query performance based on relation hit frequency Laura Hausmann 00:50
Re: Inconsistent query performance based on relation hit frequency Andrei Lepikhov 10:31
Re: Row level security Andrew Okhmat 10:45
Re: Inconsistent query performance based on relation hit frequency Achilleas Mantzios - cloud 13:27
Re: Inconsistent query performance based on relation hit frequency Laura Hausmann 14:58
Re: Inconsistent query performance based on relation hit frequency Achilleas Mantzios 19:22

July 1, 2024

Thread Author Time
a lot of shared buffers hit when planning for a simple query with primary access path James Pang 09:45
Re: a lot of shared buffers hit when planning for a simple query with primary access path David Rowley 10:10
Re: a lot of shared buffers hit when planning for a simple query with primary access path Pavel Stehule 10:20
Re: a lot of shared buffers hit when planning for a simple query with primary access path David Rowley 10:52
Re: a lot of shared buffers hit when planning for a simple query with primary access path James Pang 10:58
Re: a lot of shared buffers hit when planning for a simple query with primary access path Andrei Lepikhov 11:31

July 3, 2024

Thread Author Time
Hash Right join and seq scan James Pang 04:57
Re: Hash Right join and seq scan James Pang 06:51
Re: Hash Right join and seq scan James Pang 06:53
Re: Hash Right join and seq scan Tomas Vondra 17:40

July 4, 2024

Thread Author Time
How to solve my slow disk i/o throughput during index scan FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT) 13:25
Re: How to solve my slow disk i/o throughput during index scan Andrei Lepikhov 14:36
RE: How to solve my slow disk i/o throughput during index scan FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT) 15:23

July 5, 2024

Thread Author Time
Re: Hash Right join and seq scan 📎 James Pang 00:50
Re: How to solve my slow disk i/o throughput during index scan Andrei Lepikhov 02:04
Re: Hash Right join and seq scan David Rowley 02:15
Re: Hash Right join and seq scan James Pang 14:43

July 6, 2024

Thread Author Time
Re: Hash Right join and seq scan David Rowley 00:32

July 7, 2024

Thread Author Time
Low performance between datacenters Tamás PAPP 18:17
Re: Low performance between datacenters Fernando Hevia 20:23

July 8, 2024

Thread Author Time
Re: Low performance between datacenters Vitalii Tymchyshyn 00:42
Re: Hash Right join and seq scan 📎 James Pang 02:21
Re: Hash Right join and seq scan Justin Pryzby 02:26
Re: Low performance between datacenters Andrei Lepikhov 07:24

July 10, 2024

Thread Author Time
Query performance issue Dheeraj Sonawane 07:11
Re: Query performance issue Tom Lane 13:40
Specific objects backup in PostgreSQL nikhil kumar 18:05
Re: Specific objects backup in PostgreSQL David G. Johnston 18:41
Re: Specific objects backup in PostgreSQL Olivier Gautherot 18:42
Re: Specific objects backup in PostgreSQL Anthony Sotolongo 20:04

July 11, 2024

Thread Author Time
Re: Specific objects backup in PostgreSQL nikhil kumar 03:29
RE: How to solve my slow disk i/o throughput during index scan FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT) 14:59
RE: How to solve my slow disk i/o throughput during index scan FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT) 15:09
Re: How to solve my slow disk i/o throughput during index scan David G. Johnston 15:19
Re: How to solve my slow disk i/o throughput during index scan Andrei Lepikhov 15:22
Re: How to solve my slow disk i/o throughput during index scan Andrei Lepikhov 15:34
inequality predicate not pushed down in JOIN? Paul George 23:31
Re: inequality predicate not pushed down in JOIN? Andrei Lepikhov 23:49

July 12, 2024

Thread Author Time
Re: inequality predicate not pushed down in JOIN? Paul George 00:07
Re: inequality predicate not pushed down in JOIN? Jerry Brenner 00:58

July 19, 2024

Thread Author Time
Re: proposal: schema variables Laurenz Albe 11:41

July 20, 2024

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

July 22, 2024

Thread Author Time
Re: proposal: schema variables 📎 Pavel Stehule 06:37
Re: proposal: schema variables Laurenz Albe 08:23
Re: proposal: schema variables Pavel Stehule 08:55

July 23, 2024

Thread Author Time
Re: proposal: schema variables Laurenz Albe 14:34
Re: proposal: schema variables Laurenz Albe 21:41

July 24, 2024

Thread Author Time
Re: proposal: schema variables 📎 Pavel Stehule 15:19
Re: proposal: schema variables Laurenz Albe 17:02
Re: proposal: schema variables 📎 Pavel Stehule 18:01
Re: proposal: schema variables Pavel Stehule 19:03

July 25, 2024

Thread Author Time
Re: proposal: schema variables Laurenz Albe 13:52
Re: proposal: schema variables 📎 Pavel Stehule 16:32

July 26, 2024

Thread Author Time
Outer cost higher than the inner cost 📎 Stanisław Skonieczny 13:25
Re: Outer cost higher than the inner cost Tom Lane 14:30

July 27, 2024

Thread Author Time
Re: proposal: schema variables 📎 Laurenz Albe 14:19

July 29, 2024

Thread Author Time
Re: proposal: schema variables 📎 Laurenz Albe 09:56
Help with row estimate problem Jon Zeppieri 20:51

July 30, 2024

Thread Author Time
Re: Help with row estimate problem Andrei Lepikhov 15:34
Re: Help with row estimate problem Jon Zeppieri 17:22
Re: proposal: schema variables 📎 Laurenz Albe 19:46
Re: proposal: schema variables 📎 Pavel Stehule 20:56

July 31, 2024

Thread Author Time
logical replication out of memory James Pang 02:17
Re: logical replication out of memory James Pang 02:30
Re: logical replication out of memory khan Affan 05:41
Re: proposal: schema variables Pavel Stehule 06:41
Re: logical replication out of memory James Pang 06:48
Re: proposal: schema variables Laurenz Albe 06:57
Re: proposal: schema variables Pavel Stehule 07:04
Re: logical replication out of memory khan Affan 07:06
Re: proposal: schema variables 📎 Laurenz Albe 09:45
Re: proposal: schema variables 📎 Pavel Stehule 22:05

Aug. 1, 2024

Thread Author Time
Re: proposal: schema variables 📎 Pavel Stehule 06:12
Re: proposal: schema variables Erik Rijkers 07:45
Re: proposal: schema variables Pavel Stehule 07:48
Re: proposal: schema variables Laurenz Albe 11:22
Re: proposal: schema variables Pavel Stehule 11:24
Re: proposal: schema variables 📎 Pavel Stehule 22:02

Aug. 3, 2024

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

Aug. 7, 2024

Thread Author Time
Re: proposal: schema variables 📎 Pavel Stehule 10:00
Postgres index usage Dirschel, Steve 17:06
RE: Postgres index usage Dirschel, Steve 17:23
Re: Postgres index usage Tom Lane 17:36
Re: Postgres index usage Greg Sabino Mullane 18:18
Partition pruning with array-contains check and current_setting function Marcelo Zabani 21:10

Aug. 8, 2024

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

Aug. 15, 2024

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

Aug. 19, 2024

Thread Author Time
Trying to understand why a query is filtering when there is a composite index Stephen Samuel (Sam) 01:55
Re: Trying to understand why a query is filtering when there is a composite index Peter Geoghegan 01:59
Re: Trying to understand why a query is filtering when there is a composite index Stephen Samuel (Sam) 02:01
Re: Trying to understand why a query is filtering when there is a composite index Peter Geoghegan 02:08
Re: Trying to understand why a query is filtering when there is a composite index Stephen Samuel (Sam) 02:09
Re: Trying to understand why a query is filtering when there is a composite index Tom Lane 02:50
Re: Trying to understand why a query is filtering when there is a composite index Peter Geoghegan 03:11
Re: Trying to understand why a query is filtering when there is a composite index Tom Lane 04:06
Re: Trying to understand why a query is filtering when there is a composite index Stephen Samuel (Sam) 04:16
Re: Trying to understand why a query is filtering when there is a composite index Shiv Iyer 08:05
Re: Trying to understand why a query is filtering when there is a composite index Peter Geoghegan 15:21
Re: Trying to understand why a query is filtering when there is a composite index Stephen Samuel (Sam) 23:44
Re: Trying to understand why a query is filtering when there is a composite index Tom Lane 23:55

Aug. 20, 2024

Thread Author Time
Re: Trying to understand why a query is filtering when there is a composite index Stephen Samuel (Sam) 00:00

Aug. 22, 2024

Thread Author Time
checking for a NULL date in a partitioned table kills performance Sbob 21:44
checking for a NULL date in a partitioned table kills performance (accidentally sent to the admin list before) Sbob 21:47
Re: checking for a NULL date in a partitioned table kills performance Rui DeSousa 23:06
Re: checking for a NULL date in a partitioned table kills performance Sbob 23:26
Re: checking for a NULL date in a partitioned table kills performance Sbob 23:32
Re: checking for a NULL date in a partitioned table kills performance (accidentally sent to the admin list before) Vitalii Tymchyshyn 23:54

Aug. 23, 2024

Thread Author Time
Re: checking for a NULL date in a partitioned table kills performance David G. Johnston 00:01
Re: checking for a NULL date in a partitioned table kills performance Tom Lane 00:05
Re: checking for a NULL date in a partitioned table kills performance Rui DeSousa 00:07
Re: checking for a NULL date in a partitioned table kills performance Muhammad Usman Khan 04:40
Re: checking for a NULL date in a partitioned table kills performance shammat 06:45
Re: checking for a NULL date in a partitioned table kills performance Rui DeSousa 09:54
Re: checking for a NULL date in a partitioned table kills performance Doug Reynolds 11:39
Re: checking for a NULL date in a partitioned table kills performance Sbob 13:47
Re: checking for a NULL date in a partitioned table kills performance Scott Ribe 15:17
Re: checking for a NULL date in a partitioned table kills performance Doug Reynolds 15:42
Re: checking for a NULL date in a partitioned table kills performance Wetmore, Matthew (CTR) 15:49
Re: checking for a NULL date in a partitioned table kills performance Scott Ribe 16:08

Aug. 27, 2024

Thread Author Time
Re: proposal: schema variables Laurenz Albe 06:15
Re: proposal: schema variables Pavel Stehule 06:52
Re: proposal: schema variables Laurenz Albe 14:52

Aug. 29, 2024

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

Sept. 2, 2024

Thread Author Time
Re: proposal: schema variables Laurenz Albe 14:00

Sept. 3, 2024

Thread Author Time
Re: proposal: schema variables 📎 Pavel Stehule 11:41

Sept. 8, 2024

Thread Author Time
Estimate of the inner_rows 陈雁飞 08:21
Re: Estimate of the inner_rows Tom Lane 16:50

Sept. 9, 2024

Thread Author Time
Re: Estimate of the inner_rows Tom Lane 03:30

Sept. 10, 2024

Thread Author Time
many backends hang on MultiXactOffsetSLRU James Pang 07:33
Re: many backends hang on MultiXactOffsetSLRU Amine Tengilimoglu 08:12
Re: many backends hang on MultiXactOffsetSLRU Alvaro Herrera 08:13
Re: many backends hang on MultiXactOffsetSLRU Alvaro Herrera 08:15
Re: many backends hang on MultiXactOffsetSLRU James Pang 08:34
Re: many backends hang on MultiXactOffsetSLRU Amine Tengilimoglu 08:53
Re: many backends hang on MultiXactOffsetSLRU Alvaro Herrera 09:00
Has gen_random_uuid() gotten much slower in v17? 📎 David Mullineux 13:58

Sept. 11, 2024

Thread Author Time
Re: many backends hang on MultiXactOffsetSLRU James Pang 07:00
Re: Has gen_random_uuid() gotten much slower in v17? Peter Eisentraut 09:40
Re: Has gen_random_uuid() gotten much slower in v17? David Mullineux 10:47
Re: Partition pruning with array-contains check and current_setting function Marcelo Zabani 19:11

Sept. 12, 2024

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

Sept. 18, 2024

Thread Author Time
Re: proposal: schema variables 📎 Pavel Stehule 06:21

Sept. 22, 2024

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

Oct. 5, 2024

Thread Author Time
Performance degradation in Index searches with special characters Andrey Stikheev 09:23

Oct. 6, 2024

Thread Author Time
Re: Performance degradation in Index searches with special characters Tom Lane 16:39
Re: Performance degradation in Index searches with special characters Andrey Stikheev 17:28
Re: Performance degradation in Index searches with special characters Joe Conway 17:45
Re: Performance degradation in Index searches with special characters Tom Lane 18:13
Re: Performance degradation in Index searches with special characters Shiv Iyer 20:02
Re: Performance degradation in Index searches with special characters Thomas Munro 20:24

Oct. 7, 2024

Thread Author Time
Re: Performance degradation in Index searches with special characters Joe Conway 16:48
Re: Performance degradation in Index searches with special characters Andrey Stikheev 17:16

Oct. 8, 2024

Thread Author Time
Bloom filters and the planner / parallel execution Daniel Westermann (DWE) 11:56

Oct. 9, 2024

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

Oct. 23, 2024

Thread Author Time
Re: proposal: schema variables 📎 Laurenz Albe 04:11

Oct. 24, 2024

Thread Author Time
Adding exclusion constraint in a big table Marcelo Fernandes 06:43
Re: proposal: schema variables 📎 Laurenz Albe 08:29
Unexpected Performance for the Function simplify_function Ba Jinsheng 19:43
Re: Unexpected Performance for the Function simplify_function Shiv Iyer 19:48
Re: Unexpected Performance for the Function simplify_function Tom Lane 20:49
Re: Unexpected Performance for the Function simplify_function Tom Lane 20:51
Re: Unexpected Performance for the Function simplify_function David G. Johnston 21:05
Re: Unexpected Performance for the Function simplify_function Greg Sabino Mullane 23:09

Oct. 25, 2024

Thread Author Time
Re: Unexpected Performance for the Function simplify_function Andrei Lepikhov 02:13
Re: proposal: schema variables Pavel Stehule 05:21
lwlock:LockManager wait_events James Pang 06:36
Re: lwlock:LockManager wait_events Laurenz Albe 07:36
Re: proposal: schema variables Laurenz Albe 07:41
Re: proposal: schema variables James Pang 07:58
Re: proposal: schema variables James Pang 07:59
Re: lwlock:LockManager wait_events Sean Massey 08:37
Re: Unexpected Performance for the Function simplify_function Ba Jinsheng 09:26
Re: Unexpected Performance for the Function simplify_function Ba Jinsheng 09:29
Re: Unexpected Performance for the Function simplify_function Andrei Lepikhov 09:38
Re: Unexpected Performance for the Function simplify_function David Rowley 10:20
Re: lwlock:LockManager wait_events SAMEER KUMAR 12:09
Re: proposal: schema variables 📎 Pavel Stehule 20:38

Oct. 26, 2024

Thread Author Time
Re: Unexpected Performance for the Function simplify_function Tom Lane 06:28
Re: Unexpected Performance for the Function simplify_function Ba Jinsheng 07:31

Oct. 28, 2024

Thread Author Time
Re: proposal: schema variables 📎 Pavel Stehule 07:01

Oct. 29, 2024

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

Nov. 1, 2024

Thread Author Time
Postgresql 14/15/16/17 partition pruning on dependent table during join Stepan Yankevych 13:21

Nov. 2, 2024

Thread Author Time
Re: proposal: schema variables Laurenz Albe 05:46
Re: proposal: schema variables Pavel Stehule 07:36

Browse Archives

Prev | Next