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

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
Re: Has gen_random_uuid() gotten much slower in v17? Tom Lane 22:26

Nov. 21, 2024

Thread Author Time
Re: proposal: schema variables Pavel Stehule 04:07
could not send data to client: Connection reset by peer James Pang 12:13

Nov. 22, 2024

Thread Author Time
Performance of Query 60 on TPC-DS Benchmark Ba Jinsheng 11:12
Re: Performance of Query 60 on TPC-DS Benchmark Andrei Lepikhov 14:32
Cardinality estimate of the inner relation Frédéric Yhuel 15:53

Nov. 23, 2024

Thread Author Time
Re: could not send data to client: Connection reset by peer Tomas Vondra 01:38
Re: Cardinality estimate of the inner relation Andrei Lepikhov 02:07

Nov. 24, 2024

Thread Author Time
Re: Performance of Query 60 on TPC-DS Benchmark Andrei Lepikhov 12:04

Nov. 25, 2024

Thread Author Time
Re: Cardinality estimate of the inner relation Frédéric Yhuel 12:46
Performance of TPC-DS Query 95 Ba Jinsheng 20:54
CTE Inline On TPC-DS Query 95 Ba Jinsheng 21:02
Re: Performance of TPC-DS Query 95 David Rowley 22:41

Nov. 26, 2024

Thread Author Time
Re: CTE Inline On TPC-DS Query 95 David Rowley 04:03
Re: proposal: schema variables 📎 Pavel Stehule 06:21
Re: Has gen_random_uuid() gotten much slower in v17? David Mullineux 15:23

Nov. 27, 2024

Thread Author Time
Reg. Postgres Unique contraint Sajjad Abid 04:14
Re: Reg. Postgres Unique contraint Diomedes Dominguez 04:18
Re: Reg. Postgres Unique contraint Sajjad Abid 04:27
Re: Reg. Postgres Unique contraint Burcin Yazici 06:22
Re: Reg. Postgres Unique contraint Vitalii Tymchyshyn 07:13
Re: proposal: schema variables 📎 Pavel Stehule 18:14

Nov. 28, 2024

Thread Author Time
Re: Performance of Query 60 on TPC-DS Benchmark Nikita Malakhov 07:58

Nov. 29, 2024

Thread Author Time
Re: Performance of Query 60 on TPC-DS Benchmark 📎 Nikita Malakhov 14:27

Dec. 5, 2024

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

Dec. 7, 2024

Thread Author Time
Re: proposal: schema variables jian he 02:13

Dec. 8, 2024

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

Dec. 9, 2024

Thread Author Time
Re: proposal: schema variables jian he 06:16
PostgreSQL and a Catch-22 Issue related to dead rows Lars Aksel Opsahl 11:02
Re: PostgreSQL and a Catch-22 Issue related to dead rows MichaelDBA@sqlexec.com 13:18
Re: PostgreSQL and a Catch-22 Issue related to dead rows Greg Sabino Mullane 13:35
Re: PostgreSQL and a Catch-22 Issue related to dead rows Lars Aksel Opsahl 13:37
Re: PostgreSQL and a Catch-22 Issue related to dead rows Lars Aksel Opsahl 13:56
Re: PostgreSQL and a Catch-22 Issue related to dead rows Rick Otten 14:25
Re: PostgreSQL and a Catch-22 Issue related to dead rows Christophe Pettus 14:32
Re: PostgreSQL and a Catch-22 Issue related to dead rows Tom Lane 16:07
Re: proposal: schema variables Pavel Stehule 16:54
can a blocked transaction affect the performance of one that is blocking it? Eric Schwarzenbach 18:42
Re: can a blocked transaction affect the performance of one that is blocking it? Nikolay Samokhvalov 23:10
Re: proposal: schema variables 📎 Pavel Stehule 23:20

Dec. 10, 2024

Thread Author Time
Re: proposal: schema variables jian he 03:32
Re: PostgreSQL and a Catch-22 Issue related to dead rows Lars Aksel Opsahl 05:19
Re: PostgreSQL and a Catch-22 Issue related to dead rows Lars Aksel Opsahl 05:32
Re: PostgreSQL and a Catch-22 Issue related to dead rows Lars Aksel Opsahl 08:55
Re: can a blocked transaction affect the performance of one that is blocking it? David Mullineux 09:22
Re: PostgreSQL and a Catch-22 Issue related to dead rows Greg Sabino Mullane 13:03
Re: PostgreSQL and a Catch-22 Issue related to dead rows Lars Aksel Opsahl 14:03
Re: PostgreSQL and a Catch-22 Issue related to dead rows Greg Sabino Mullane 15:31
Re: PostgreSQL and a Catch-22 Issue related to dead rows Hannu Krosing 20:26

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

Browse Archives

Prev | Next