Mailing lists [pgsql-performance]

1 October 2020

• 07:51   Re: SSL connection getting rejected on AWS RDS Hannah Huang

5 October 2020

• 08:02   Too many waits on extension of relation avinash varma
• 19:44   Re: Too many waits on extension of relation Michael Lewis
• 20:06   Re: Too many waits on extension of relation avinash varma
• 20:38   Re: Too many waits on extension of relation Sushant Pawar
• 21:03   Re: Too many waits on extension of relation MichaelDBA

6 October 2020

• 06:59   Re: Too many waits on extension of relation avinash varma

9 October 2020

• 08:39   Indexing an XMLTABLE query? Kanninen Anssi EXT
• 08:59   Re: Indexing an XMLTABLE query? Pavel Stehule

12 October 2020

• 09:46   Re: Performance issue when we use policies for Row Level Security along with functions Gopisetty, Ramesh
• 10:26   Performance issue when we use policies for Row Level Security along with functions David G. Johnston

14 October 2020

• 20:30   Slow Query Parth Shah
• 22:17   Re: Slow Query Michael Lewis

15 October 2020

• 04:11   Re: Slow Query Parth Shah
• 07:51   Re: Slow Query Michael Lewis
• 08:21   Poor Performance running Django unit tests after upgrading from 10.6 Roger Hunwicks
• 13:59   Re: Poor Performance running Django unit tests after upgrading from 10.6 Andrew Dunstan
• 16:56   Re: Poor Performance running Django unit tests after upgrading from 10.6 Tom Lane
• 18:04   CPU Consuming query. Sequential scan despite indexing. aditya desai
• 19:26   Re: CPU Consuming query. Sequential scan despite indexing. Michael Lewis

16 October 2020

• 11:36   Re: CPU Consuming query. Sequential scan despite indexing. Laurenz Albe

19 October 2020

• 19:20   Re: CPU Consuming query. Sequential scan despite indexing. Michael Lewis

20 October 2020

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

21 October 2020

• 15:38   Re: Query Performance / Planner estimate off Sebastian Dressler
• 17:42   Re: Query Performance / Planner estimate off Mats Olsen
• 18:29   Re: Query Performance / Planner estimate off Michael Lewis
• 18:35   Re: Query Performance / Planner estimate off Sebastian Dressler

22 October 2020

• 03:32   Query performance Nagaraj Raj
• 04:09   Re: Query performance Justin Pryzby
• 04:11   Re: Query performance David G. Johnston
• 08:21   Re: CPU Consuming query. Sequential scan despite indexing. aditya desai
• 08:27   Re: CPU Consuming query. Sequential scan despite indexing. aditya desai
• 08:32   Re: CPU Consuming query. Sequential scan despite indexing. David G. Johnston
• 08:36   Re: CPU Consuming query. Sequential scan despite indexing. aditya desai
• 09:21   Re: Query Performance / Planner estimate off Mats Olsen
• 09:37   Re: Query Performance / Planner estimate off Justin Pryzby
• 10:36   Re: Query Performance / Planner estimate off Mats Olsen

23 October 2020

• 15:16   Re: Query Performance / Planner estimate off Mats Olsen

25 October 2020

• 01:33   Profiling tool for postgresql queries  Debajyoti Datta

26 October 2020

• 18:58   Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join Ehrenreich, Sigrid
• 19:50   Understanding bad estimate (related to FKs?) Philip Semanchuk
• 20:04   Re: Understanding bad estimate (related to FKs?) Justin Pryzby
• 20:14   Re: Understanding bad estimate (related to FKs?) Philip Semanchuk
• 20:20   Re: Understanding bad estimate (related to FKs?) Michael Lewis
• 21:55   Re: Understanding bad estimate (related to FKs?) Philip Semanchuk
• 23:34   Re: Postgres Optimizer ignores information about foreign key relationship, severely misestimating number of returned rows in join Justin Pryzby

27 October 2020

• 01:25   Re: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join David Rowley
• 01:54   Re: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join Tom Lane
• 10:50   RE: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join Ehrenreich, Sigrid

28 October 2020

• 09:45   Re: Query Performance / Planner estimate off Mats Olsen
• 19:55   Re: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join Tom Lane

29 October 2020

• 01:46   query plan using partial index expects a much larger number of rows than is possible Olivier Poquet
• 02:30   Re: query plan using partial index expects a much larger number of rows than is possible Tom Lane
• 03:53   Re: query plan using partial index expects a much larger number of rows than is possible Olivier Poquet
• 09:31   RE: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join Ehrenreich, Sigrid
• 12:57   Re: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join Magnus Hagander
• 15:12   RE: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join Ehrenreich, Sigrid
• 18:08   Re: query plan using partial index expects a much larger number of rows than is possible Michael Lewis
• 18:25   Re: Understanding bad estimate (related to FKs?) Philip Semanchuk

30 October 2020

• 01:48   Re: Understanding bad estimate (related to FKs?) Tomas Vondra
• 17:56   Re: Understanding bad estimate (related to FKs?) Philip Semanchuk

31 October 2020

• 16:53   Re: Understanding bad estimate (related to FKs?) Guillaume Lelarge