pgsql-performance

Messages by Date

2020/12/04 Re: Pg_locks and pg_stat_activity aditya desai
2020/12/03 Re: Pg_locks and pg_stat_activity Kyotaro Horiguchi
2020/12/03 Re: Temporarily disable not null constraints Justin Pryzby
2020/12/03 Re: Temporarily disable not null constraints Milos Babic
2020/12/03 Re: Temporarily disable not null constraints Michael Lewis
2020/12/03 Temporarily disable not null constraints Nagaraj Raj
2020/12/03 Re: time taking deletion on large tables Andrew Dunstan
2020/12/03 Re: time taking deletion on large tables Tom Lane
2020/12/03 Re: time taking deletion on large tables Justin Pryzby
2020/12/03 Re: time taking deletion on large tables Ravikumar Reddy
2020/12/03 time taking deletion on large tables Atul Kumar
2020/11/22 Re: Simple update query is slow Justin Pryzby
2020/11/22 Re: Simple update query is slow Nandakumar M
2020/11/22 Simple update query is slow Nandakumar M
2020/11/19 Re: How to prioritise walsender reading from pg_wal over WAL writes? Alexey Bashtanov
2020/11/19 Re: Postgres using nested loops despite setting enable_nestloop to false Frits Jalvingh
2020/11/18 Re: How to prioritise walsender reading from pg_wal over WAL writes? Laurenz Albe
2020/11/18 Re: How to prioritise walsender reading from pg_wal over WAL writes? Alexey Bashtanov
2020/11/18 Re: How to prioritise walsender reading from pg_wal over WAL writes? Laurenz Albe
2020/11/18 Re: How to prioritise walsender reading from pg_wal over WAL writes? Alexey Bashtanov
2020/11/17 Re: Postgres using nested loops despite setting enable_nestloop to false Frits Jalvingh
2020/11/17 Re: Postgres using nested loops despite setting enable_nestloop to false Tom Lane
2020/11/17 Re: Postgres using nested loops despite setting enable_nestloop to false Frits Jalvingh
2020/11/17 Re: Postgres using nested loops despite setting enable_nestloop to false Justin Pryzby
2020/11/17 Re: Postgres using nested loops despite setting enable_nestloop to false Frits Jalvingh
2020/11/17 Re: Postgres using nested loops despite setting enable_nestloop to false Frits Jalvingh
2020/11/17 Re: Postgres using nested loops despite setting enable_nestloop to false Justin Pryzby
2020/11/17 Install clustered postgres Nunzia Vairo
2020/11/17 Postgres using nested loops despite setting enable_nestloop to false Frits Jalvingh
2020/11/13 How to prioritise walsender reading from pg_wal over WAL writes? Alexey Bashtanov
2020/11/05 Re: Adding nextval() to a select caused hang/very slow execution Eric Raskin
2020/11/04 RE: Partition pruning with joins Ehrenreich, Sigrid
2020/11/04 Re: Low cost query - running longer David G. Johnston
2020/11/04 Low cost query - running longer Koteswara Rao Daliparthi
2020/11/04 Re: Adding nextval() to a select caused hang/very slow execution Eric Raskin
2020/11/04 Re: Adding nextval() to a select caused hang/very slow execution Eric Raskin
2020/11/04 Re: Adding nextval() to a select caused hang/very slow execution Eric Raskin
2020/11/04 Re: Adding nextval() to a select caused hang/very slow execution Eric Raskin
2020/11/04 Re: Adding nextval() to a select caused hang/very slow execution Eric Raskin
2020/11/04 RE: Adding nextval() to a select caused hang/very slow execution Eric Raskin
2020/11/04 Re: Adding nextval() to a select caused hang/very slow execution Tom Lane
2020/11/04 Adding nextval() to a select caused hang/very slow execution Eric Raskin
2020/11/04 Re: Adding nextval() to a select caused hang/very slow execution Michael Lewis
2020/11/04 Re: Partition pruning with joins David Rowley
2020/11/04 Re: Adding nextval() to a select caused hang/very slow execution Tom Lane
2020/11/04 Re: Adding nextval() to a select caused hang/very slow execution Tom Lane
2020/11/04 Re: Adding nextval() to a select caused hang/very slow execution Tom Lane
2020/11/04 Re: Adding nextval() to a select caused hang/very slow execution Tom Lane
2020/11/04 RE: Partition pruning with joins Ehrenreich, Sigrid
2020/11/03 Re: Partition pruning with joins Laurenz Albe
2020/11/03 Re: Understanding bad estimate (related to FKs?) Philip Semanchuk
2020/11/03 Re: Understanding bad estimate (related to FKs?) Philip Semanchuk
2020/11/03 Partition pruning with joins Ehrenreich, Sigrid
2020/11/02 Re: Understanding bad estimate (related to FKs?) Tomas Vondra
2020/11/02 Re: Understanding bad estimate (related to FKs?) Michael Lewis
2020/11/02 Re: Understanding bad estimate (related to FKs?) Guillaume Lelarge
2020/11/02 Re: Understanding bad estimate (related to FKs?) Tom Lane
2020/11/02 Re: Understanding bad estimate (related to FKs?) Justin Pryzby
2020/11/02 Re: Understanding bad estimate (related to FKs?) Philip Semanchuk
2020/10/31 Re: Understanding bad estimate (related to FKs?) Guillaume Lelarge
2020/10/30 Re: Understanding bad estimate (related to FKs?) Philip Semanchuk
2020/10/29 Re: Understanding bad estimate (related to FKs?) Tomas Vondra
2020/10/29 Re: Understanding bad estimate (related to FKs?) Philip Semanchuk
2020/10/29 Re: query plan using partial index expects a much larger number of rows than is possible Michael Lewis
2020/10/29 RE: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join Ehrenreich, Sigrid
2020/10/29 Re: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join Magnus Hagander
2020/10/29 RE: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join Ehrenreich, Sigrid
2020/10/28 Re: Understanding bad estimate (related to FKs?) Justin Pryzby
2020/10/28 Re: query plan using partial index expects a much larger number of rows than is possible Olivier Poquet
2020/10/28 Re: query plan using partial index expects a much larger number of rows than is possible Tom Lane
2020/10/28 query plan using partial index expects a much larger number of rows than is possible Olivier Poquet
2020/10/28 Re: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join Tom Lane
2020/10/27 Re: Query Performance / Planner estimate off Mats Olsen
2020/10/27 RE: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join Ehrenreich, Sigrid
2020/10/26 Re: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join Tom Lane
2020/10/26 Re: Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join David Rowley
2020/10/26 Re: Postgres Optimizer ignores information about foreign key relationship, severely misestimating number of returned rows in join Justin Pryzby
2020/10/26 Re: Understanding bad estimate (related to FKs?) Philip Semanchuk
2020/10/26 Postgres Optimizer ignores information about foreign key relationship, severly misestimating number of returned rows in join Ehrenreich, Sigrid
2020/10/26 Re: Understanding bad estimate (related to FKs?) Michael Lewis
2020/10/26 Re: Understanding bad estimate (related to FKs?) Philip Semanchuk
2020/10/26 Re: Understanding bad estimate (related to FKs?) Justin Pryzby
2020/10/26 Understanding bad estimate (related to FKs?) Philip Semanchuk
2020/10/25 Profiling tool for postgresql queries Debajyoti Datta
2020/10/23 Re: Query Performance / Planner estimate off Mats Olsen
2020/10/22 Re: Query Performance / Planner estimate off Justin Pryzby
2020/10/22 Re: Query Performance / Planner estimate off Mats Olsen
2020/10/21 Re: Query Performance / Planner estimate off Justin Pryzby
2020/10/21 Re: Query Performance / Planner estimate off Mats Olsen
2020/10/21 Re: CPU Consuming query. Sequential scan despite indexing. aditya desai
2020/10/21 Re: CPU Consuming query. Sequential scan despite indexing. David G. Johnston
2020/10/21 Re: CPU Consuming query. Sequential scan despite indexing. aditya desai
2020/10/21 Re: CPU Consuming query. Sequential scan despite indexing. aditya desai
2020/10/21 Re: Query performance David G. Johnston
2020/10/21 Re: Query performance Justin Pryzby
2020/10/21 Query performance Nagaraj Raj
2020/10/21 Re: Query Performance / Planner estimate off Sebastian Dressler
2020/10/21 Re: Query Performance / Planner estimate off Michael Lewis
2020/10/21 Re: Query Performance / Planner estimate off Mats Olsen
2020/10/21 Re: Query Performance / Planner estimate off Sebastian Dressler
2020/10/20 Re: Query Performance / Planner estimate off Mats Olsen
2020/10/20 Re: Query Performance / Planner estimate off Mats Olsen
2020/10/20 Re: Query Performance / Planner estimate off Mats Olsen
2020/10/20 Re: Query Performance / Planner estimate off Victor Yegorov
2020/10/20 Re: Query Performance / Planner estimate off Mats Olsen
2020/10/20 Re: Query Performance / Planner estimate off Mats Olsen
2020/10/20 Re: Query Performance / Planner estimate off Sushant Pawar
2020/10/20 Re: Query Performance / Planner estimate off Victor Yegorov
2020/10/20 Re: Query Performance / Planner estimate off Victor Yegorov
2020/10/20 Re: CPU Consuming query. Sequential scan despite indexing. aditya desai
2020/10/20 Re: CPU Consuming query. Sequential scan despite indexing. aditya desai
2020/10/20 Re: Query Performance / Planner estimate off Mats Julian Olsen
2020/10/20 Re: Query Performance / Planner estimate off Pavel Stehule
2020/10/20 Re: Query Performance / Planner estimate off Mats Julian Olsen
2020/10/20 Re: Query Performance / Planner estimate off Pavel Stehule
2020/10/20 Re: Query Performance / Planner estimate off Mats Julian Olsen
2020/10/20 Re: Query Performance / Planner estimate off David Rowley
2020/10/20 Query Performance / Planner estimate off Mats Julian Olsen
2020/10/20 Re: CPU Consuming query. Sequential scan despite indexing. aditya desai
2020/10/19 Re: CPU Consuming query. Sequential scan despite indexing. Michael Lewis
2020/10/16 Re: CPU Consuming query. Sequential scan despite indexing. Laurenz Albe
2020/10/15 Re: CPU Consuming query. Sequential scan despite indexing. Michael Lewis
2020/10/15 CPU Consuming query. Sequential scan despite indexing. aditya desai
2020/10/15 Re: Poor Performance running Django unit tests after upgrading from 10.6 Tom Lane
2020/10/15 Re: Slow Query Parth Shah
2020/10/15 Re: Poor Performance running Django unit tests after upgrading from 10.6 Andrew Dunstan
2020/10/14 Re: Poor Performance running Django unit tests after upgrading from 10.6 Laurenz Albe
2020/10/14 Poor Performance running Django unit tests after upgrading from 10.6 Roger Hunwicks
2020/10/14 Re: Slow Query Michael Lewis
2020/10/14 Re: Slow Query Michael Lewis
2020/10/14 Slow Query Parth Shah
2020/10/12 Performance issue when we use policies for Row Level Security along with functions David G. Johnston
2020/10/12 Re: Performance issue when we use policies for Row Level Security along with functions Gopisetty, Ramesh
2020/10/08 Re: Indexing an XMLTABLE query? Pavel Stehule
2020/10/08 Indexing an XMLTABLE query? Kanninen Anssi EXT
2020/10/05 Re: Too many waits on extension of relation avinash varma
2020/10/05 Re: Too many waits on extension of relation Laurenz Albe
2020/10/05 Re: Too many waits on extension of relation MichaelDBA
2020/10/05 Re: Too many waits on extension of relation Sushant Pawar
2020/10/05 Re: Too many waits on extension of relation Michael Lewis
2020/10/05 Too many waits on extension of relation avinash varma
2020/09/30 Re: SSL connection getting rejected on AWS RDS Hannah Huang
2020/09/30 Re: SSL connection getting rejected on AWS RDS aditya desai
2020/09/30 Re: SSL connection getting rejected on AWS RDS Hannah Huang
2020/09/30 SSL connection getting rejected on AWS RDS aditya desai
2020/09/30 Re: AWS RDS PostgreSQL CPU Spiking to 100% aditya desai
2020/09/29 Re: Is it possible to specify minimum number of rows planner should consider? Timothy Garnett
2020/09/28 Re: Is it possible to specify minimum number of rows planner should consider? Matthew Bellew
2020/09/28 Re: Is it possible to specify minimum number of rows planner should consider? Tom Lane
2020/09/28 Is it possible to specify minimum number of rows planner should consider? Timothy Garnett
2020/09/28 Re: AWS RDS PostgreSQL CPU Spiking to 100% Prince Pathria
2020/09/28 Re: AWS RDS PostgreSQL CPU Spiking to 100% aditya desai
2020/09/25 Re: How to encrypt database password in pgpass or unix file to run batch jobs through shell script Bruce Momjian
2020/09/25 How to encrypt database password in pgpass or unix file to run batch jobs through shell script aditya desai
2020/09/18 Re: Single column vs composite partial index Michael Lewis
2020/09/16 Re: Performance issue when we use policies for Row Level Security along with functions Tom Lane
2020/09/16 Re: Performance issue when we use policies for Row Level Security along with functions luis . roberto
2020/09/16 Performance issue when we use policies for Row Level Security along with functions Gopisetty, Ramesh
2020/09/16 Re: Single column vs composite partial index Nagaraj Raj
2020/09/15 Re: Single column vs composite partial index Justin Pryzby
2020/09/15 Single column vs composite partial index Nagaraj Raj
2020/09/14 Re: autoanalyze creates bad plan, manual analyze fixes it? Robert Treat
2020/09/14 Re: autoanalyze creates bad plan, manual analyze fixes it? Pavel Stehule
2020/09/14 Re: autoanalyze creates bad plan, manual analyze fixes it? Justin Pryzby
2020/09/14 autoanalyze creates bad plan, manual analyze fixes it? Robert Treat
2020/09/14 Re: Performance Issue (Not using Index when joining two tables). Tom Lane
2020/09/14 Re: Performance Issue (Not using Index when joining two tables). Gopisetty, Ramesh
2020/09/13 Re: Performance Issue (Not using Index when joining two tables). Michael Lewis
2020/09/13 Re: Performance Issue (Not using Index when joining two tables). Tom Lane
2020/09/13 Re: Performance Issue (Not using Index when joining two tables). Tomas Vondra
2020/09/13 Performance Issue (Not using Index when joining two tables). Gopisetty, Ramesh
2020/09/13 Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Alvaro Herrera
2020/09/13 Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED David Rowley
2020/09/11 Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Jim Jarvie
2020/09/08 Re: AWS RDS PostgreSQL CPU Spiking to 100% Jeff Janes
2020/09/08 Re: AWS RDS PostgreSQL CPU Spiking to 100% Pavel Stehule
2020/09/08 AWS RDS PostgreSQL CPU Spiking to 100% aditya desai
2020/09/08 Re: Query Performance in bundled requests Justin Pryzby
2020/09/08 Query Performance in bundled requests Dirk Krautschick
2020/09/08 AW: Query performance issue Dirk Krautschick
2020/09/07 Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Raj
2020/09/05 Re: Query performance issue Nagaraj Raj
2020/09/05 Re: Query performance issue Michael Lewis
2020/09/05 Re: Query performance issue David Rowley
2020/09/04 Re: Query performance issue Nagaraj Raj
2020/09/04 Re: Query performance issue Michael Lewis
2020/09/04 Re: Query performance issue Nagaraj Raj
2020/09/04 Re: Query performance issue Michael Lewis
2020/09/04 Re: Query performance issue Michael Lewis
2020/09/04 Re: Query performance issue Tomas Vondra
2020/09/04 Re: Query performance issue Nagaraj Raj
2020/09/04 Re: Query performance issue Thomas Kellerer
2020/09/04 Query performance issue Nagaraj Raj
2020/08/26 Re: Too few rows expected by Planner on partitioned tables Michael Lewis
2020/08/26 Re: Too few rows expected by Planner on partitioned tables Julian Wolf
2020/08/24 Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Jeff Janes
2020/08/24 Re: sizing / capacity planning tipps related to expected request or transactions per second Pavel Stehule
2020/08/24 Re: sizing / capacity planning tipps related to expected request or transactions per second MichaelDBA
2020/08/24 sizing / capacity planning tipps related to expected request or transactions per second Dirk Krautschick
2020/08/21 Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Jim Jarvie