pgsql-performance since 2024-07-30 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

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
Re: Postgresql 14/15/16/17 partition pruning on dependent table during join	Vijaykumar Jain	20:21

Nov. 3, 2024

Thread	Author	Time
Re: Postgresql 14/15/16/17 partition pruning on dependent table during join	Andrei Lepikhov	02:42

Nov. 4, 2024

Thread	Author	Time
Re: Postgresql 14/15/16/17 partition pruning on dependent table during join	Stepan Yankevych	08:23
Performance of Query 2 in TPC-H	Ba Jinsheng	08:42
Re: proposal: schema variables	Laurenz Albe	09:24
Re: Postgresql 14/15/16/17 partition pruning on dependent table during join	Andrei Lepikhov	12:05

Nov. 5, 2024

Thread	Author	Time
Re: Performance of Query 2 in TPC-H 📎	Andrei Lepikhov	02:22
Re: Bloom filters and the planner / parallel execution	Rafia Sabih	13:22

Nov. 6, 2024

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

Nov. 7, 2024

Thread	Author	Time
Major performance degradation with joins in 15.8 or 15.7?	Ed Sabol	21:54
Re: Major performance degradation with joins in 15.8 or 15.7?	David Rowley	22:18

Nov. 8, 2024

Thread	Author	Time
Re: Major performance degradation with joins in 15.8 or 15.7?	Ed Sabol	01:21
Re: Major performance degradation with joins in 15.8 or 15.7?	Andrei Lepikhov	02:27
Re: Major performance degradation with joins in 15.8 or 15.7?	Ed Sabol	02:45
Re: Major performance degradation with joins in 15.8 or 15.7?	Andrei Lepikhov	02:54
tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4	Achilleas Mantzios	19:32
Re: Major performance degradation with joins in 15.8 or 15.7?	Ed Sabol	20:32

Nov. 9, 2024

Thread	Author	Time
Re: Major performance degradation with joins in 15.8 or 15.7?	Andrei Lepikhov	01:21
Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4	Tomas Vondra	10:49
Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4	Achilleas Mantzios	14:05
Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4	Achilleas Mantzios	14:08
Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4	Tomas Vondra	15:41

Nov. 10, 2024

Thread	Author	Time
Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4	Achilleas Mantzios	09:45
Re: proposal: schema variables	Dmitry Dolgov	15:24
Re: proposal: schema variables	Pavel Stehule	16:19
Re: proposal: schema variables	Dmitry Dolgov	17:41
Re: proposal: schema variables	Pavel Stehule	17:51
Re: proposal: schema variables	Pavel Stehule	18:04
Re: proposal: schema variables	Pavel Stehule	18:09
Performance of Query 4 on TPC-DS Benchmark	Ba Jinsheng	19:35
Re: Performance of Query 4 on TPC-DS Benchmark	Thomas Munro	19:58
Re: Performance of Query 4 on TPC-DS Benchmark	Alena Rybakina	20:16
Re: Performance of Query 4 on TPC-DS Benchmark	Alena Rybakina	20:18
Re: proposal: schema variables 📎	Pavel Stehule	22:41

Nov. 11, 2024

Thread	Author	Time
Re: Performance of Query 4 on TPC-DS Benchmark	Andrei Lepikhov	09:41
Re: Performance of Query 4 on TPC-DS Benchmark	Ba Jinsheng	10:49
Re: Performance of Query 4 on TPC-DS Benchmark	Ba Jinsheng	10:51

Nov. 12, 2024

Thread	Author	Time
Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4 📎	Achilleas Mantzios - cloud	10:37
Re: Performance of Query 4 on TPC-DS Benchmark 📎	Andrei Lepikhov	10:40
Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4	Tomas Vondra	13:17
Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4	Achilleas Mantzios	18:24
Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4	Tom Lane	19:37
Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4	Tomas Vondra	21:46

Nov. 13, 2024

Thread	Author	Time
Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4	Achilleas Mantzios - cloud	07:14
Re: tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4	Achilleas Mantzios - cloud	08:45
Re: proposal: schema variables 📎	Laurenz Albe	14:24
Re: proposal: schema variables	Pavel Stehule	15:06
Re: proposal: schema variables	Dmitry Dolgov	16:34
Re: proposal: schema variables	Pavel Stehule	18:18

Nov. 14, 2024

Thread	Author	Time
Re: proposal: schema variables	Pavel Stehule	07:41

Nov. 15, 2024

Thread	Author	Time
Re: proposal: schema variables	Pavel Stehule	04:45

Nov. 16, 2024

Thread	Author	Time
Re: proposal: schema variables	Pavel Stehule	06:10
Re: proposal: schema variables	Dmitry Dolgov	14:27
Re: proposal: schema variables	Pavel Stehule	14:34
Re: proposal: schema variables	Wolfgang Walther	14:56
Re: proposal: schema variables	Pavel Stehule	15:36
Re: proposal: schema variables 📎	Pavel Stehule	15:41
Re: proposal: schema variables	Wolfgang Walther	17:13
Re: proposal: schema variables	Pavel Stehule	22:07
Re: proposal: schema variables	Pavel Stehule	22:49

Nov. 17, 2024

Thread	Author	Time
Re: proposal: schema variables	Pavel Stehule	04:41
Re: proposal: schema variables	Pavel Stehule	04:53

Nov. 19, 2024

Thread	Author	Time
Re: proposal: schema variables 📎	Pavel Stehule	19:14
Re: proposal: schema variables 📎	Pavel Stehule	21:30

Nov. 20, 2024

Thread	Author	Time
Re: proposal: schema variables 📎	Pavel Stehule	07:25
Re: Has gen_random_uuid() gotten much slower in v17?	Frédéric Yhuel	10:35
Re: proposal: schema variables	Marcos Pegoraro	13:29
Re: proposal: schema variables	Pavel Stehule	13:52
Re: proposal: schema variables	Marcos Pegoraro	14:14
Re: proposal: schema variables	Pavel Stehule	14:57
Re: Has gen_random_uuid() gotten much slower in v17?	Tom Lane	15:46
Re: proposal: schema variables	Dmitry Dolgov	20:13
Re: Has gen_random_uuid() gotten much slower in v17?	David Mullineux	22:11

Browse Archives

Prev | Next