pgsql-performance - December 2024

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)

Browse Archives

Prev | Next

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

Browse Archives

Prev | Next