pgsql-performance - October 2020

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

Oct. 1, 2020

Thread Author Time
Re: proposal: schema variables Michael Paquier 03:38
Re: SSL connection getting rejected on AWS RDS Hannah Huang 04:51
Re: proposal: schema variables 📎 Pavel Stehule 05:08

Oct. 5, 2020

Thread Author Time
Too many waits on extension of relation avinash varma 05:02
Re: Too many waits on extension of relation Michael Lewis 16:44
Re: Too many waits on extension of relation avinash varma 17:06
Re: Too many waits on extension of relation Sushant Pawar 17:38
Re: Too many waits on extension of relation MichaelDBA 18:03

Oct. 6, 2020

Thread Author Time
Re: Too many waits on extension of relation Laurenz Albe 03:37
Re: Too many waits on extension of relation avinash varma 03:59

Oct. 9, 2020

Thread Author Time
Indexing an XMLTABLE query? Kanninen Anssi EXT 05:39
Re: Indexing an XMLTABLE query? Pavel Stehule 05:59

Oct. 12, 2020

Thread Author Time
Re: Performance issue when we use policies for Row Level Security along with functions Gopisetty, Ramesh 06:46
Performance issue when we use policies for Row Level Security along with functions David G. Johnston 07:26

Oct. 14, 2020

Thread Author Time
Slow Query Parth Shah 17:30
Re: Slow Query Michael Lewis 19:17

Oct. 15, 2020

Thread Author Time
Re: Slow Query 📎 Parth Shah 01:11
Re: Slow Query Michael Lewis 04:51
Poor Performance running Django unit tests after upgrading from 10.6 Roger Hunwicks 05:21
Re: Poor Performance running Django unit tests after upgrading from 10.6 Laurenz Albe 06:56
Re: Poor Performance running Django unit tests after upgrading from 10.6 Andrew Dunstan 10:59
Re: Poor Performance running Django unit tests after upgrading from 10.6 Tom Lane 13:56
CPU Consuming query. Sequential scan despite indexing. aditya desai 15:04
Re: CPU Consuming query. Sequential scan despite indexing. Michael Lewis 16:26

Oct. 16, 2020

Thread Author Time
Re: CPU Consuming query. Sequential scan despite indexing. Laurenz Albe 08:36

Oct. 19, 2020

Thread Author Time
Re: CPU Consuming query. Sequential scan despite indexing. Michael Lewis 16:20

Oct. 20, 2020

Thread Author Time
Re: CPU Consuming query. Sequential scan despite indexing. aditya desai 07:17
Query Performance / Planner estimate off Mats Julian Olsen 09:37
Re: Query Performance / Planner estimate off David Rowley 09:50
Re: Query Performance / Planner estimate off Mats Julian Olsen 09:59
Re: Query Performance / Planner estimate off Pavel Stehule 10:50
Re: Query Performance / Planner estimate off Mats Julian Olsen 11:09
Re: Query Performance / Planner estimate off Pavel Stehule 11:15
Re: Query Performance / Planner estimate off Mats Julian Olsen 11:20
Re: CPU Consuming query. Sequential scan despite indexing. aditya desai 12:30
Re: CPU Consuming query. Sequential scan despite indexing. aditya desai 12:56
Re: Query Performance / Planner estimate off Victor Yegorov 13:04
Re: Query Performance / Planner estimate off Victor Yegorov 13:22
Re: Query Performance / Planner estimate off Sushant Pawar 13:40
Re: Query Performance / Planner estimate off Mats Olsen 14:50
Re: Query Performance / Planner estimate off Mats Olsen 16:45
Re: Query Performance / Planner estimate off Victor Yegorov 16:51
Re: Query Performance / Planner estimate off Mats Olsen 17:02
Re: Query Performance / Planner estimate off Mats Olsen 17:40
Re: Query Performance / Planner estimate off Mats Olsen 17:43

Oct. 21, 2020

Thread Author Time
Re: Query Performance / Planner estimate off Sebastian Dressler 12:38
Re: Query Performance / Planner estimate off Mats Olsen 14:42
Re: Query Performance / Planner estimate off Michael Lewis 15:29
Re: Query Performance / Planner estimate off Sebastian Dressler 15:35

Oct. 22, 2020

Thread Author Time
Query performance Nagaraj Raj 00:32
Re: Query performance Justin Pryzby 01:09
Re: Query performance David G. Johnston 01:11
Re: CPU Consuming query. Sequential scan despite indexing. aditya desai 05:21
Re: CPU Consuming query. Sequential scan despite indexing. aditya desai 05:27
Re: CPU Consuming query. Sequential scan despite indexing. David G. Johnston 05:32
Re: CPU Consuming query. Sequential scan despite indexing. aditya desai 05:36