pgsql-performance

Messages by Date

2021/03/01 Re: Potential performance issues Thomas Kellerer
2021/03/01 Re: Potential performance issues Bob Jolliffe
2021/03/01 Re: Potential performance issues MichaelDBA
2021/03/01 Re: Potential performance issues MichaelDBA
2021/03/01 Re: Potential performance issues Andrew Dunstan
2021/03/01 Potential performance issues Jung, Jinho
2021/02/26 Re: Postgres performance comparing GCP and AWS Justin Pitts
2021/02/26 Re: Postgres performance comparing GCP and AWS Igor Gois
2021/02/26 Re: Postgres performance comparing GCP and AWS Igor Gois
2021/02/25 Re: Disabling options lowers the estimated cost of a query Tom Lane
2021/02/25 Re: Postgres performance comparing GCP and AWS Philip Semanchuk
2021/02/25 Re: Postgres performance comparing GCP and AWS Philip Semanchuk
2021/02/25 Re: Postgres performance comparing GCP and AWS Philip Semanchuk
2021/02/24 Re: Postgres performance comparing GCP and AWS Igor Gois
2021/02/24 Re: Postgres performance comparing GCP and AWS Imre Samu
2021/02/24 Re: Postgres performance comparing GCP and AWS Julien Rouhaud
2021/02/24 Re: Postgres performance comparing GCP and AWS Milos Babic
2021/02/24 Re: Postgres performance comparing GCP and AWS Gunther Schadow
2021/02/23 Postgres performance comparing GCP and AWS Maurici Meneghetti
2021/02/23 Re: FreeBSD UFS & fsync Luca Ferrari
2021/02/22 Re: FreeBSD UFS & fsync Luca Ferrari
2021/02/22 Re: FreeBSD UFS & fsync Thomas Munro
2021/02/22 FreeBSD UFS & fsync Luca Ferrari
2021/02/19 Re: Autovacuum not functioning for large tables but it is working for few other small tables. Laurenz Albe
2021/02/19 RE: Autovacuum not functioning for large tables but it is working for few other small tables. M Tarkeshwar Rao
2021/02/17 Re: Slow query and wrong row estimates for CTE Yoan SULTAN
2021/02/17 Re: Slow query and wrong row estimates for CTE Dane Foster
2021/02/17 Re: Slow query and wrong row estimates for CTE Yoan SULTAN
2021/02/17 Re: Slow query and wrong row estimates for CTE Dane Foster
2021/02/16 Re: Slow query and wrong row estimates for CTE Dane Foster
2021/02/16 Re: Query performance issue Michael Lewis
2021/02/16 Re: Slow query and wrong row estimates for CTE Dane Foster
2021/02/16 Re: Slow query and wrong row estimates for CTE Dane Foster
2021/02/16 Re: Slow query and wrong row estimates for CTE Michael Lewis
2021/02/15 Re: Slow query and wrong row estimates for CTE Justin Pryzby
2021/02/15 Slow query and wrong row estimates for CTE Dane Foster
2021/02/14 Re: Query performance issue Tomas Vondra
2021/01/21 Re: Query performance issue Justin Pryzby
2021/01/21 Query performance issue Nagaraj Raj
2021/01/21 Understanding logical replication lag Patrick Molgaard
2021/01/15 Re: High COMMIT times Don Seiler
2021/01/14 RE: Need information on how MM frees up disk space (vaccum) after scheduled DB cleanup by BGwCronScript/BGwLogCleaner M Tarkeshwar Rao
2021/01/11 Re: How to deal with analyze gathering irrelevant stats Michael Lewis
2021/01/11 Re: How to deal with analyze gathering irrelevant stats Rémi Chatenay
2021/01/11 Re: How to deal with analyze gathering irrelevant stats Michael Lewis
2021/01/11 Re: How to deal with analyze gathering irrelevant stats Adam Brusselback
2021/01/11 Re: How to deal with analyze gathering irrelevant stats Justin Pryzby
2021/01/11 How to deal with analyze gathering irrelevant stats Rémi Chatenay
2021/01/11 Re: High COMMIT times Don Seiler
2021/01/11 Re: High COMMIT times Craig Jackson
2021/01/10 Re: High COMMIT times Don Seiler
2021/01/09 Re: High COMMIT times Jeff Janes
2021/01/08 Re: High COMMIT times Craig Jackson
2021/01/08 Re: High COMMIT times Don Seiler
2021/01/08 Re: High COMMIT times José Arthur Benetasso Villanova
2021/01/08 Re: Autovacuum not functioning for large tables but it is working for few other small tables. Michael Lewis
2021/01/08 RE: Autovacuum not functioning for large tables but it is working for few other small tables. M Tarkeshwar Rao
2021/01/08 Re: High COMMIT times Laurenz Albe
2021/01/07 Re: High COMMIT times Don Seiler
2021/01/07 Re: High COMMIT times Craig Jackson
2021/01/06 Re: High COMMIT times Laurenz Albe
2021/01/06 Re: High COMMIT times Don Seiler
2021/01/06 Re: High COMMIT times Kenneth Marshall
2021/01/06 Re: High COMMIT times Joshua Drake
2021/01/06 Re: High COMMIT times Don Seiler
2021/01/06 Re: High COMMIT times Joshua Drake
2021/01/06 High COMMIT times Don Seiler
2020/12/29 Re: Slow recursive CTE query questions, with row estimate and n_distinct issues Christopher Baines
2020/12/29 Re: Slow recursive CTE query questions, with row estimate and n_distinct issues Christopher Baines
2020/12/28 Re: Slow recursive CTE query questions, with row estimate and n_distinct issues Greg Spiegelberg
2020/12/28 Re: Slow recursive CTE query questions, with row estimate and n_distinct issues Michael Lewis
2020/12/28 Slow recursive CTE query questions, with row estimate and n_distinct issues Christopher Baines
2020/12/23 Re: Conundrum with scaling out of bottleneck with hot standby, PgPool-II, etc. Bruce Momjian
2020/12/23 Re: Conundrum with scaling out of bottleneck with hot standby, PgPool-II, etc. Marco Colli
2020/12/23 Conundrum with scaling out of bottleneck with hot standby, PgPool-II, etc. Gunther Schadow
2020/12/18 Re: Reversing NULLS in ORDER causes index not to be used? Ken Tanzer
2020/12/18 Re: Reversing NULLS in ORDER causes index not to be used? Tom Lane
2020/12/18 Reversing NULLS in ORDER causes index not to be used? Ken Tanzer
2020/12/18 Re: Oracle to postgresql Ian Lawrence Barwick
2020/12/18 Oracle to postgresql bangalore umesh
2020/12/16 Re: Autovacuum not functioning for large tables but it is working for few other small tables. Tomas Vondra
2020/12/16 RE: Autovacuum not functioning for large tables but it is working for few other small tables. M Tarkeshwar Rao
2020/12/14 Performance issues with composite types (partitioned table) Sebastijan Wieser
2020/12/11 Re: "Required checkpoints occurs too frequently" Christophe Pettus
2020/12/11 Re: "Required checkpoints occurs too frequently" Atul Kumar
2020/12/11 Re: "Required checkpoints occurs too frequently" Amine Tengilimoglu
2020/12/11 Re: "Required checkpoints occurs too frequently" Atul Kumar
2020/12/11 Re: "Required checkpoints occurs too frequently" Laurenz Albe
2020/12/11 "Required checkpoints occurs too frequently" Atul Kumar
2020/12/05 Re: Index for range queries on JSON (user defined fields) Marco Colli
2020/12/04 Re: Index for range queries on JSON (user defined fields) Nick Cleaton
2020/12/04 Re: PostgeSQL JSONB Column with various type of data Michael Lewis
2020/12/04 PostgeSQL JSONB Column with various type of data Riswana Rahman
2020/12/04 Index for range queries on JSON (user defined fields) Marco Colli
2020/12/04 Re: Pg_locks and pg_stat_activity aditya desai
2020/12/04 Re: Pg_locks and pg_stat_activity Justin Pryzby
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