pgsql-performance - August 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)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 3 7 8 15 19 20 22 23 27 29

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

Browse Archives

Prev | Next
Jump to day: 1 3 7 8 15 19 20 22 23 27 29