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)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 5 6 9 12 14 15 16 19 20 21 22 23 24 26 27 28 29 30 31

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
Re: Query Performance / Planner estimate off Mats Olsen 06:21
Re: Query Performance / Planner estimate off Justin Pryzby 06:37
Re: Query Performance / Planner estimate off Mats Olsen 07:36
Re: Query Performance / Planner estimate off Justin Pryzby 13:48

Oct. 23, 2020

Thread Author Time
Re: Query Performance / Planner estimate off Mats Olsen 12:16

Oct. 24, 2020

Thread Author Time
Profiling tool for postgresql queries Debajyoti Datta 22:33

Oct. 26, 2020

Thread Author Time
Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join Ehrenreich, Sigrid 15:58
Understanding bad estimate (related to FKs?) Philip Semanchuk 16:50
Re: Understanding bad estimate (related to FKs?) Justin Pryzby 17:04
Re: Understanding bad estimate (related to FKs?) Philip Semanchuk 17:14
Re: Understanding bad estimate (related to FKs?) Michael Lewis 17:20
Re: Understanding bad estimate (related to FKs?) Philip Semanchuk 18:55
Re: Postgres Optimizer ignores information about foreign key relationship, severely misestimating number of returned rows in join Justin Pryzby 20:34
Re: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join David Rowley 22:25
Re: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join Tom Lane 22:54

Oct. 27, 2020

Thread Author Time
RE: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join Ehrenreich, Sigrid 07:50

Oct. 28, 2020

Thread Author Time
Re: Query Performance / Planner estimate off Mats Olsen 06:45
Re: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join Tom Lane 16:55
query plan using partial index expects a much larger number of rows than is possible Olivier Poquet 22:46
Re: query plan using partial index expects a much larger number of rows than is possible Tom Lane 23:30

Oct. 29, 2020

Thread Author Time
Re: query plan using partial index expects a much larger number of rows than is possible Olivier Poquet 00:53
Re: Understanding bad estimate (related to FKs?) Justin Pryzby 01:13
RE: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join Ehrenreich, Sigrid 06:31
Re: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join Magnus Hagander 09:57
RE: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join Ehrenreich, Sigrid 12:12
Re: query plan using partial index expects a much larger number of rows than is possible Michael Lewis 15:08
Re: Understanding bad estimate (related to FKs?) Philip Semanchuk 15:25
Re: Understanding bad estimate (related to FKs?) Tomas Vondra 22:48

Oct. 30, 2020

Thread Author Time
Re: Understanding bad estimate (related to FKs?) Philip Semanchuk 14:56

Oct. 31, 2020

Thread Author Time
Re: Understanding bad estimate (related to FKs?) Guillaume Lelarge 13:53

Browse Archives

Prev | Next
Jump to day: 1 5 6 9 12 14 15 16 19 20 21 22 23 24 26 27 28 29 30 31