pgsql-performance since 2024-12-11 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

Dec. 11, 2024

Thread	Author	Time
Re: PostgreSQL and a Catch-22 Issue related to dead rows	Lars Aksel Opsahl	07:32
Re: PostgreSQL and a Catch-22 Issue related to dead rows	Lars Aksel Opsahl	13:29
Re: proposal: schema variables 📎	Pavel Stehule	20:51

Dec. 14, 2024

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

Dec. 18, 2024

Thread	Author	Time
Re: proposal: schema variables	jian he	03:00

Dec. 19, 2024

Thread	Author	Time
Re: proposal: schema variables 📎	Pavel Stehule	07:25
Aggressive vacuum	Graham Hay	13:37
Why a bitmap scan in this case?	Jon Zeppieri	17:52
Re: Why a bitmap scan in this case?	Greg Sabino Mullane	18:38
Re: Why a bitmap scan in this case?	Jon Zeppieri	19:09
Re: Why a bitmap scan in this case?	Jon Zeppieri	19:19

Dec. 20, 2024

Thread	Author	Time
Re: Re: proposal: schema variables	jian he	07:57
Re: Why a bitmap scan in this case?	Frédéric Yhuel	08:16
Re: Why a bitmap scan in this case?	Frédéric Yhuel	09:57
Re: proposal: schema variables 📎	Pavel Stehule	12:53
Re: Why a bitmap scan in this case?	Jon Zeppieri	21:01
Re: Re: proposal: schema variables 📎	Pavel Stehule	22:00

Dec. 21, 2024

Thread	Author	Time
huge shared_blocks_hit one select but manually run very fast	James Pang	11:50
Re: huge shared_blocks_hit one select but manually run very fast	David Mullineux	16:40

Dec. 22, 2024

Thread	Author	Time
Re: huge shared_blocks_hit one select but manually run very fast 📎	James Pang	03:38

Dec. 25, 2024

Thread	Author	Time
Re: huge shared_blocks_hit one select but manually run very fast	David Mullineux	14:07

Dec. 27, 2024

Thread	Author	Time
RE: CTE Inline On TPC-DS Query 95	msalais	11:34
Re: CTE Inline On TPC-DS Query 95	David Rowley	11:40
RE: Reg. Postgres Unique contraint	msalais	11:54
Re: Reg. Postgres Unique contraint	shammat	12:57
Re: Re: proposal: schema variables 📎	jian he	15:19

Dec. 28, 2024

Thread	Author	Time
Re: Re: proposal: schema variables	jian he	10:34
Re: Re: proposal: schema variables	Pavel Stehule	15:32
Re: Re: proposal: schema variables	jian he	16:46
Re: Re: proposal: schema variables	Pavel Stehule	17:29
Re: Re: proposal: schema variables 📎	Pavel Stehule	21:49

Dec. 29, 2024

Thread	Author	Time
Re: Re: proposal: schema variables	jian he	02:48
Re: Re: proposal: schema variables	Pavel Stehule	06:24
Re: Re: proposal: schema variables 📎	Pavel Stehule	08:42

Jan. 2, 2025

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

Jan. 3, 2025

Thread	Author	Time
Re: Re: proposal: schema variables 📎	jian he	07:18
Re: Re: proposal: schema variables 📎	Pavel Stehule	22:59

Jan. 4, 2025

Thread	Author	Time
Re: Re: proposal: schema variables 📎	Pavel Stehule	05:36
Question: consolidating strpos searches? 📎	James Addison	17:16
Re: Question: consolidating strpos searches?	Tom Lane	17:45
Re: Question: consolidating strpos searches?	Greg Sabino Mullane	19:03

Jan. 5, 2025

Thread	Author	Time
Re: Re: proposal: schema variables	jian he	04:52
Re: Re: proposal: schema variables	jian he	16:10

Jan. 6, 2025

Thread	Author	Time
Re: Re: proposal: schema variables 📎	jian he	07:58
Re: Re: proposal: schema variables	Pavel Stehule	08:39
Re: Re: proposal: schema variables	Pavel Stehule	10:01
Re: Re: proposal: schema variables 📎	Pavel Stehule	12:21
Re: Re: proposal: schema variables 📎	Pavel Stehule	19:10
Re: Aggressive vacuum	Slava Mudry	23:18

Jan. 7, 2025

Thread	Author	Time
Re: Re: proposal: schema variables	jian he	09:07
Re: Aggressive vacuum	Jeff Janes	19:30
Re: Re: proposal: schema variables 📎	Pavel Stehule	21:21

Jan. 8, 2025

Thread	Author	Time
Re: Re: proposal: schema variables	jian he	09:31
Re: Re: proposal: schema variables 📎	Pavel Stehule	16:33
Re: Re: proposal: schema variables 📎	Pavel Stehule	19:00

Jan. 9, 2025

Thread	Author	Time
Re: Re: proposal: schema variables 📎	Pavel Stehule	05:57
Unexpected Seq Scan's when using MERGE WHEN NOT MATCHED BY SOURCE 📎	Feike Steenbergen	12:25
Re: Unexpected Seq Scan's when using MERGE WHEN NOT MATCHED BY SOURCE	Feike Steenbergen	12:39
Re: Unexpected Seq Scan's when using MERGE WHEN NOT MATCHED BY SOURCE	David Mullineux	15:52
Re: Unexpected Seq Scan's when using MERGE WHEN NOT MATCHED BY SOURCE	Tom Lane	19:39

Jan. 15, 2025

Thread	Author	Time
Re: Re: proposal: schema variables 📎	Pavel Stehule	07:28
Query planning read a large amount of buffers for partitioned tables	bruno vieira da silva	18:29
Re: Query planning read a large amount of buffers for partitioned tables	bruno vieira da silva	18:32
Re: Query planning read a large amount of buffers for partitioned tables	David Rowley	20:01
Re: Question: consolidating strpos searches?	James Addison	23:58

Jan. 16, 2025

Thread	Author	Time
Re: Query planning read a large amount of buffers for partitioned tables	bruno vieira da silva	14:56

Jan. 17, 2025

Thread	Author	Time
Re: Re: proposal: schema variables 📎	Pavel Stehule	07:18
Re: Re: proposal: schema variables	Bruce Momjian	13:41
Re: Re: proposal: schema variables	Pavel Stehule	13:48
Re: Re: proposal: schema variables	Bruce Momjian	14:16
Re: Re: proposal: schema variables	Álvaro Herrera	14:47
Fwd: Re: proposal: schema variables	Pavel Stehule	15:32
Re: Fwd: Re: proposal: schema variables	Bruce Momjian	15:35
Re: Fwd: Re: proposal: schema variables	Pavel Stehule	15:55
Re: Fwd: Re: proposal: schema variables	Bruce Momjian	16:01
Re: Fwd: Re: proposal: schema variables	Julien Rouhaud	16:10
Re: Fwd: Re: proposal: schema variables	Laurenz Albe	16:43
Re: Fwd: Re: proposal: schema variables	Dmitry Dolgov	17:47
Re: Fwd: Re: proposal: schema variables	Wolfgang Walther	20:20
Re: Fwd: Re: proposal: schema variables	Marcos Pegoraro	21:30
Re: Fwd: Re: proposal: schema variables	Marcos Pegoraro	21:54

Jan. 18, 2025

Thread	Author	Time
Re: Fwd: Re: proposal: schema variables	Gilles Darold	07:24

Jan. 20, 2025

Thread	Author	Time
Re: Re: proposal: schema variables	Pavel Stehule	08:26
Re: Re: proposal: schema variables	Bruce Momjian	20:15
Re: Re: proposal: schema variables	Laurenz Albe	20:40

Jan. 25, 2025

Thread	Author	Time
Any risk or overhead considerations for frequently executing queries against catalog tables?	Frits Hoogland	11:23
Re: Any risk or overhead considerations for frequently executing queries against catalog tables?	Pavel Stehule	13:32
Read-only connectios optimizatios	Edson Richter	14:55
Re: Any risk or overhead considerations for frequently executing queries against catalog tables?	Frits Hoogland	16:59
Re: Read-only connectios optimizatios	Laurenz Albe	18:01
Re: Any risk or overhead considerations for frequently executing queries against catalog tables?	Pavel Stehule	18:18
Re: Any risk or overhead considerations for frequently executing queries against catalog tables?	Frits Hoogland	20:01
Re: Any risk or overhead considerations for frequently executing queries against catalog tables?	peter plachta	22:08
Re: Read-only connectios optimizatios	peter plachta	22:12
Re: Any risk or overhead considerations for frequently executing queries against catalog tables?	frits.hoogland	22:42

Jan. 26, 2025

Thread	Author	Time
Re: Any risk or overhead considerations for frequently executing queries against catalog tables?	Pavel Stehule	06:43
Reg pg_restore taking more time in windows compare to linux 📎	Praveen Kumar Mandula	07:14
Re: Any risk or overhead considerations for frequently executing queries against catalog tables?	Jeremy Schneider	17:56

Jan. 27, 2025

Thread	Author	Time
Re: Reg pg_restore taking more time in windows compare to linux	Laurenz Albe	08:53
Re: Unexpected Seq Scan's when using MERGE WHEN NOT MATCHED BY SOURCE	Feike Steenbergen	09:48
Re: [EXTERNAL] - Re: Reg pg_restore taking more time in windows compare to linux 📎	Praveen Kumar Mandula	12:29
Re: [EXTERNAL] - Re: Reg pg_restore taking more time in windows compare to linux	Laurenz Albe	15:06
RE: [EXT] Re: Read-only connectios optimizatios	Wong, Kam Fook (TR Technology)	17:41

Jan. 28, 2025

Thread	Author	Time
Why ORing with a false one-time filter turns an Index-Lookup into a SeqScan	Clemens Eisserer	14:58
Re: Why ORing with a false one-time filter turns an Index-Lookup into a SeqScan	Wetmore, Matthew (CTR)	15:34
Re: [EXTERNAL] - Re: Reg pg_restore taking more time in windows compare to linux	Laurenz Albe	17:12
Simple query with Planner underestimating rows.	Felipe López Montes	19:29

Jan. 29, 2025

Thread	Author	Time
Re: Simple query with Planner underestimating rows.	Greg Sabino Mullane	02:12
Re: Simple query with Planner underestimating rows.	Andrei Lepikhov	03:05
Re: Simple query with Planner underestimating rows.	Andrei Lepikhov	08:57
Re: Why ORing with a false one-time filter turns an Index-Lookup into a SeqScan	Clemens Eisserer	12:07
Re: Why ORing with a false one-time filter turns an Index-Lookup into a SeqScan	Tom Lane	15:10

Jan. 31, 2025

Thread	Author	Time
High System CPU Usage on Selects Seemingly Caused By Vacuum of Same Table	Joshua Banton	22:28
Re: High System CPU Usage on Selects Seemingly Caused By Vacuum of Same Table	Peter Geoghegan	22:45
Re: High System CPU Usage on Selects Seemingly Caused By Vacuum of Same Table	Joshua Banton	22:59

Feb. 3, 2025

Thread	Author	Time
Performance loss after upgrading from 12.15 to 17.2	Tobias Orlamünde	14:11
Re: Performance loss after upgrading from 12.15 to 17.2	Laurenz Albe	15:59

Feb. 6, 2025

Thread	Author	Time
Re: Re: proposal: schema variables	jian he	14:49
Poor performance with row wise comparisons	Jon Emord	21:13

Feb. 7, 2025

Thread	Author	Time
Re: Re: proposal: schema variables 📎	Pavel Stehule	07:24
Re: Re: proposal: schema variables	jian he	13:14
Re: Poor performance with row wise comparisons	Greg Sabino Mullane	14:43
Re: Poor performance with row wise comparisons	Jon Emord	16:16

Feb. 8, 2025

Thread	Author	Time
Re: lwlock:LockManager wait_events	kyle Hailey	19:41

Feb. 9, 2025

Thread	Author	Time
Re: Re: proposal: schema variables 📎	Pavel Stehule	20:56
Re: Poor performance with row wise comparisons	Tom Lane	22:40

Feb. 10, 2025

Thread	Author	Time
Re: Poor performance with row wise comparisons	Laurenz Albe	12:36

Feb. 11, 2025

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

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

Browse Archives

Prev | Next