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

Thread	Author	Time
BDR that performs	Smith, Travis	12:08
Re: BDR that performs	Bruce Momjian	12:35
Re: BDR that performs	Hari Kiran	12:40
Re: BDR that performs	P C	12:41
Re: BDR that performs	Bruce Momjian	14:57

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

Browse Archives

Prev | Next