pgsql-performance - May 2025

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

May 2, 2025

Thread Author Time
Vacuum Questions Leo 14:23
Re: Vacuum Questions Leo 16:04
Re: Vacuum Questions John Naylor 23:49

May 3, 2025

Thread Author Time
RE: Vacuum Questions msalais 19:46

May 5, 2025

Thread Author Time
Re: Vacuum Questions Craig Jackson 14:33
Re: Vacuum Questions Craig Jackson 14:35

May 12, 2025

Thread Author Time
inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Maxim Boguk 11:49
Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Andrei Lepikhov 12:08
Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Maxim Boguk 13:08
Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Andrei Lepikhov 13:48
Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Maxim Boguk 14:04
Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Maxim Boguk 14:21
Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) David Rowley 15:01
Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Maxim Boguk 15:18
Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Tom Lane 15:33
Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Andrei Lepikhov 17:22
Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Maxim Boguk 17:55
Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Tom Lane 18:07

May 13, 2025

Thread Author Time
Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Andrei Lepikhov 04:25
Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) David Rowley 11:20

May 14, 2025

Thread Author Time
Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Maxim Boguk 00:47

May 15, 2025

Thread Author Time
Re: Re: proposal: schema variables 📎 Pavel Stehule 06:48
a lot of session wait on lock relation James Pang 08:27
Re: a lot of session wait on lock relation Chetan 09:31
Re: a lot of session wait on lock relation Laurenz Albe 12:08
Re: a lot of session wait on lock relation Tom Lane 13:24
Re: a lot of session wait on lock relation James Pang 13:32
Re: a lot of session wait on lock relation James Pang 13:43
Database creation performance drop going from pg 14 to pg 15+ 📎 Mahdi Bahrami 16:28

May 18, 2025

Thread Author Time
Re: inefficient/wrong plan cache mode selection for queries with partitioned tables (postgresql 17) Andrei Lepikhov 16:54

May 20, 2025

Thread Author Time
Re: Re: proposal: schema variables Bruce Momjian 14:56
Re: Re: proposal: schema variables Marcos Pegoraro 16:33
Re: Re: proposal: schema variables Bruce Momjian 16:39
Re: proposal: schema variables Daniel Gustafsson 18:47
Re: proposal: schema variables Bruce Momjian 20:28
Re: Re: proposal: schema variables Pavel Stehule 20:28
Re: proposal: schema variables Laurenz Albe 20:36
Re: proposal: schema variables Bruce Momjian 21:06
Re: Re: proposal: schema variables Bruce Momjian 21:10

May 21, 2025

Thread Author Time
Re: Re: proposal: schema variables Michael Paquier 00:21
Re: proposal: schema variables Pavel Stehule 05:15
Re: Re: proposal: schema variables Pavel Stehule 05:49
Re: proposal: schema variables Laurenz Albe 06:27
Re: proposal: schema variables Pavel Stehule 06:36
Re: proposal: schema variables Pavel Stehule 07:12
Re: proposal: schema variables Bruce Momjian 20:41
Re: proposal: schema variables Bruce Momjian 21:22
Re: Re: proposal: schema variables Bruce Momjian 21:23

May 27, 2025

Thread Author Time
Re: Database creation performance drop going from pg 14 to pg 15+ 📎 Mahdi Bahrami 08:12
Re: Database creation performance drop going from pg 14 to pg 15+ Álvaro Herrera 15:07

May 28, 2025

Thread Author Time
Re: Database creation performance drop going from pg 14 to pg 15+ Mahdi Bahrami 11:09
Re: Database creation performance drop going from pg 14 to pg 15+ Thomas Munro 11:29
Re: Database creation performance drop going from pg 14 to pg 15+ Mahdi Bahrami 12:15

Browse Archives

Prev | Next