pgsql-performance  

Messages by Date

• 2021/07/22 Re: Big performance slowdown from 11.2 to 13.3 Tom Lane
• 2021/07/22 RE: Big performance slowdown from 11.2 to 13.3 l...@laurent-hasson.com
• 2021/07/22 Re: Big performance slowdown from 11.2 to 13.3 David Rowley
• 2021/07/22 RE: Big performance slowdown from 11.2 to 13.3 l...@laurent-hasson.com
• 2021/07/22 Re: Big performance slowdown from 11.2 to 13.3 Peter Geoghegan
• 2021/07/22 Re: Big performance slowdown from 11.2 to 13.3 David Rowley
• 2021/07/22 Re: Big performance slowdown from 11.2 to 13.3 Tom Lane
• 2021/07/22 Re: Big performance slowdown from 11.2 to 13.3 Tom Lane
• 2021/07/22 RE: Big performance slowdown from 11.2 to 13.3 l...@laurent-hasson.com
• 2021/07/22 Re: Partitioned table statistics vs autoanalyze Kamil Frydel
• 2021/07/22 RE: Big performance slowdown from 11.2 to 13.3 l...@laurent-hasson.com
• 2021/07/22 Re: Partitioned table statistics vs autoanalyze Justin Pryzby
• 2021/07/22 Partitioned table statistics vs autoanalyze Kamil Frydel
• 2021/07/21 Re: Big performance slowdown from 11.2 to 13.3 David Rowley
• 2021/07/21 RE: Big performance slowdown from 11.2 to 13.3 l...@laurent-hasson.com
• 2021/07/21 RE: Big performance slowdown from 11.2 to 13.3 l...@laurent-hasson.com
• 2021/07/21 RE: Big performance slowdown from 11.2 to 13.3 l...@laurent-hasson.com
• 2021/07/21 Re: Big performance slowdown from 11.2 to 13.3 Tom Lane
• 2021/07/21 RE: Big performance slowdown from 11.2 to 13.3 l...@laurent-hasson.com
• 2021/07/21 Re: Big performance slowdown from 11.2 to 13.3 Tom Lane
• 2021/07/21 Re: Big performance slowdown from 11.2 to 13.3 Peter Geoghegan
• 2021/07/21 RE: Big performance slowdown from 11.2 to 13.3 l...@laurent-hasson.com
• 2021/07/21 RE: Big performance slowdown from 11.2 to 13.3 l...@laurent-hasson.com
• 2021/07/21 Re: Big performance slowdown from 11.2 to 13.3 Michael Lewis
• 2021/07/21 Re: Big performance slowdown from 11.2 to 13.3 Justin Pryzby
• 2021/07/21 Big performance slowdown from 11.2 to 13.3 l...@laurent-hasson.com
• 2021/07/21 Re: Query Performance Tom Lane
• 2021/07/21 Query Performance Dirschel, Steve
• 2021/07/20 Re: Performance benchmark of PG Manish Lad
• 2021/07/19 Re: Performance benchmark of PG Ninad Shah
• 2021/07/19 Re: Performance benchmark of PG Manish Lad
• 2021/07/19 Re: Performance benchmark of PG Thomas Kellerer
• 2021/07/19 Re: Performance benchmark of PG Hüseyin Demir
• 2021/07/19 Re: Performance benchmark of PG Manish Lad
• 2021/07/19 Re: Performance benchmark of PG Laurenz Albe
• 2021/07/19 Performance benchmark of PG Manish Lad
• 2021/07/18 Re: Linear slow-down while inserting into a table with an ON INSERT trigger ? Laurenz Albe
• 2021/07/18 Re: Linear slow-down while inserting into a table with an ON INSERT trigger ? Tobias Gierke
• 2021/07/18 Re: Linear slow-down while inserting into a table with an ON INSERT trigger ? Tobias Gierke
• 2021/07/17 Re: Linear slow-down while inserting into a table with an ON INSERT trigger ? Tom Lane
• 2021/07/17 Re: Linear slow-down while inserting into a table with an ON INSERT trigger ? David Rowley
• 2021/07/16 Re: Linear slow-down while inserting into a table with an ON INSERT trigger ? Justin Pryzby
• 2021/07/13 Re: temporary file log lines Tomas Vondra
• 2021/07/13 Re: temporary file log lines Guillaume Lelarge
• 2021/07/12 Re: temporary file log lines MichaelDBA
• 2021/07/12 Re: temporary file log lines Laurenz Albe
• 2021/07/12 RE: Partition column should be part of PK Michel SALAIS
• 2021/07/11 Re: Partition column should be part of PK Thomas Kellerer
• 2021/07/11 Re: Partition column should be part of PK David Rowley
• 2021/07/11 Re: Partition column should be part of PK Christophe Pettus
• 2021/07/11 Re: Partition column should be part of PK Justin Pryzby
• 2021/07/11 Re: Partition column should be part of PK Nagaraj Raj
• 2021/07/08 Re: Partition column should be part of PK Christophe Pettus
• 2021/07/08 Re: Partition column should be part of PK Nagaraj Raj
• 2021/07/08 Re: Strange execution plan Manuel Weitzman
• 2021/07/08 RE: Partition column should be part of PK Mike Sofen
• 2021/07/08 Re: Partition column should be part of PK Alvaro Herrera
• 2021/07/08 Re: Partition column should be part of PK Justin Pryzby
• 2021/07/08 temporary file log lines MichaelDBA
• 2021/07/08 Re: Strange execution plan Manuel Weitzman
• 2021/07/08 Re: Strange execution plan Manuel Weitzman
• 2021/07/08 ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification Nagaraj Raj
• 2021/07/08 Re: ETL - sql orchestrator is stuck when there is not sleep() between queries Allan Barrielle
• 2021/07/08 Re: ETL - sql orchestrator is stuck when there is not sleep() between queries Allan Barrielle
• 2021/07/08 Re: ETL - sql orchestrator is stuck when there is not sleep() between queries Allan Barrielle
• 2021/07/08 Re: ETL - sql orchestrator is stuck when there is not sleep() between queries Justin Pryzby
• 2021/07/08 Re: ETL - sql orchestrator is stuck when there is not sleep() between queries Imre Samu
• 2021/07/08 Re: ETL - sql orchestrator is stuck when there is not sleep() between queries Justin Pryzby
• 2021/07/08 Strange execution plan Joel Frid
• 2021/07/08 Strange execution plan Joel Frid
• 2021/07/08 ETL - sql orchestrator is stuck when there is not sleep() between queries Allan Barrielle
• 2021/07/07 Re: hint in determining effective_io_concurrency Luca Ferrari
• 2021/07/07 Re: hint in determining effective_io_concurrency Merlin Moncure
• 2021/07/02 Re: slow performance with cursor Tomas Vondra
• 2021/07/02 Re: Planning performance problem (67626.278ms) David Rowley
• 2021/07/01 Re: Planning performance problem (67626.278ms) Manuel Weitzman
• 2021/07/01 Re: slow performance with cursor Ayub Khan
• 2021/07/01 Re: slow performance with cursor Justin Pryzby
• 2021/07/01 Re: slow performance with cursor Ayub Khan
• 2021/06/30 Re: Planning performance problem (67626.278ms) Manuel Weitzman
• 2021/06/29 Re: Planning performance problem (67626.278ms) Tom Lane
• 2021/06/29 Re: Planning performance problem (67626.278ms) Manuel Weitzman
• 2021/06/29 Re: Planning performance problem (67626.278ms) Tom Lane
• 2021/06/29 Re: Planning performance problem (67626.278ms) Manuel Weitzman
• 2021/06/25 Re: slow performance with cursor Tom Lane
• 2021/06/25 Re: slow performance with cursor Ayub Khan
• 2021/06/25 Re: slow performance with cursor Justin Pryzby
• 2021/06/25 slow performance with cursor Ayub Khan
• 2021/06/24 Re: Partition column should be part of PK Justin Pryzby
• 2021/06/24 Partition column should be part of PK Nagaraj Raj
• 2021/06/20 Re: Planning performance problem (67626.278ms) Tom Lane
• 2021/06/20 Re: Estimating wal_keep_size Dean Gibson (DB Administrator)
• 2021/06/20 Re: Planning performance problem (67626.278ms) Ranier Vilela
• 2021/06/20 Re: Planning performance problem (67626.278ms) Tom Lane
• 2021/06/20 Re: Planning performance problem (67626.278ms) Manuel Weitzman
• 2021/06/18 Re: Estimating wal_keep_size Vijaykumar Jain
• 2021/06/18 Re: Estimating wal_keep_size Julien Rouhaud
• 2021/06/18 Re: Estimating wal_keep_size Dean Gibson (DB Administrator)
• 2021/06/16 Re: PostgreSQL V13 Replication Issue Michael Paquier
• 2021/06/16 Re: Estimating wal_keep_size Julien Rouhaud
• 2021/06/16 Estimating wal_keep_size Dean Gibson (DB Administrator)
• 2021/06/16 Re: PostgreSQL V13 Replication Issue Dean Gibson (DB Administrator)
• 2021/06/16 PostgreSQL V13 Replication Issue Haseeb Khan
• 2021/06/15 Re: waiting for client write Vijaykumar Jain
• 2021/06/15 Re: Master - Slave Replication Window Server Atul Kumar
• 2021/06/15 Re: waiting for client write Ayub Khan
• 2021/06/15 Re: Master - Slave Replication Window Server Haseeb Khan
• 2021/06/15 Re: Master - Slave Replication Window Server Rory Campbell-Lange
• 2021/06/15 Re: overcommit_ratio setting Yi Sun
• 2021/06/15 Re: overcommit_ratio setting Laurenz Albe
• 2021/06/14 Re: Master - Slave Replication Window Server Haseeb Khan
• 2021/06/14 Re: Master - Slave Replication Window Server Haseeb Khan
• 2021/06/14 Re: overcommit_ratio setting Yi Sun
• 2021/06/14 Re: Master - Slave Replication Window Server Rory Campbell-Lange
• 2021/06/14 Master - Slave Replication Window Server Haseeb Khan
• 2021/06/14 Re: Planning performance problem (67626.278ms) Manuel Weitzman
• 2021/06/14 Re: overcommit_ratio setting Laurenz Albe
• 2021/06/14 Re: overcommit_ratio setting Julien Rouhaud
• 2021/06/14 Re: pg_dumpall --exclude-database case folding, was Re: AWS forcing PG upgrade from v9.6 a disaster Tom Lane
• 2021/06/14 pg_dumpall --exclude-database case folding, was Re: AWS forcing PG upgrade from v9.6 a disaster Andrew Dunstan
• 2021/06/14 overcommit_ratio setting Yi Sun
• 2021/06/13 Re: waiting for client write Ayub Khan
• 2021/06/13 Re: waiting for client write Ayub Khan
• 2021/06/13 Re: waiting for client write Vijaykumar Jain
• 2021/06/13 Re: waiting for client write Ayub Khan
• 2021/06/12 Re: waiting for client write Ayub Khan
• 2021/06/12 Re: waiting for client write Vijaykumar Jain
• 2021/06/12 Re: waiting for client write Ranier Vilela
• 2021/06/12 Re: waiting for client write Ayub Khan
• 2021/06/11 Re: waiting for client write Ayub Khan
• 2021/06/11 Re: waiting for client write Jeff Janes
• 2021/06/11 Re: waiting for client write Ayub Khan
• 2021/06/11 Re: waiting for client write Ranier Vilela
• 2021/06/11 Re: waiting for client write Ayub Khan
• 2021/06/11 Re: waiting for client write Ranier Vilela
• 2021/06/11 Re: waiting for client write Ayub Khan
• 2021/06/11 Re: waiting for client write Ranier Vilela
• 2021/06/11 Re: waiting for client write Ayub Khan
• 2021/06/11 Re: waiting for client write Ranier Vilela
• 2021/06/11 Re: waiting for client write Pavan Pusuluri
• 2021/06/11 Re: waiting for client write Ayub Khan
• 2021/06/10 Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 2021/06/10 Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 2021/06/10 Re: AWS forcing PG upgrade from v9.6 a disaster Andrew Dunstan
• 2021/06/10 Re: AWS forcing PG upgrade from v9.6 a disaster Tom Lane
• 2021/06/10 Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 2021/06/10 Re: waiting for client write Vijaykumar Jain
• 2021/06/10 Re: AWS forcing PG upgrade from v9.6 a disaster Ranier Vilela
• 2021/06/10 Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 2021/06/10 Re: waiting for client write Jeff Janes
• 2021/06/10 Re: AWS forcing PG upgrade from v9.6 a disaster Joshua Drake
• 2021/06/10 Re: Page File Size Reached Critical Threshold PostgreSQL V13 Justin Pryzby
• 2021/06/10 Re: AWS forcing PG upgrade from v9.6 a disaster Andrew Dunstan
• 2021/06/10 Re: Page File Size Reached Critical Threshold PostgreSQL V13 Justin Pryzby
• 2021/06/10 Re: waiting for client write Ayub Khan
• 2021/06/09 Re: Page File Size Reached Critical Threshold PostgreSQL V13 Haseeb Khan
• 2021/06/09 Re: Page File Size Reached Critical Threshold PostgreSQL V13 Justin Pryzby
• 2021/06/09 Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 2021/06/09 Page File Size Reached Critical Threshold PostgreSQL V13 Haseeb Khan
• 2021/06/09 Re: slow query Ayub Khan
• 2021/06/09 Re: slow query Jeff Janes
• 2021/06/09 Re: waiting for client write Ayub Khan
• 2021/06/09 Re: waiting for client write Magnus Hagander
• 2021/06/08 Re: slow query Ayub Khan
• 2021/06/08 Re: slow query Tom Lane
• 2021/06/08 Re: slow query Ayub Khan
• 2021/06/08 Re: slow query Christophe Pettus
• 2021/06/08 slow query Ayub Khan
• 2021/06/07 Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 2021/06/07 Re: AWS forcing PG upgrade from v9.6 a disaster Andrew Dunstan
• 2021/06/07 Re: dexter on AWS RDS auto tune queries Ayub Khan
• 2021/06/07 Re: dexter on AWS RDS auto tune queries Julien Rouhaud
• 2021/06/07 Re: dexter on AWS RDS auto tune queries Ayub Khan
• 2021/06/06 Re: dexter on AWS RDS auto tune queries Christophe Pettus
• 2021/06/06 Re: dexter on AWS RDS auto tune queries Julien Rouhaud
• 2021/06/06 dexter on AWS RDS auto tune queries Ayub Khan
• 2021/06/06 Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 2021/06/05 Re: query planner not using index, instead using squential scan Vijaykumar Jain
• 2021/06/05 Re: query planner not using index, instead using squential scan Ayub Khan
• 2021/06/05 Re: query planner not using index, instead using squential scan Vijaykumar Jain
• 2021/06/05 Re: query planner not using index, instead using squential scan Tom Lane
• 2021/06/05 query planner not using index, instead using squential scan Ayub Khan
• 2021/06/04 RE: PgSQL 12 on WinSrv ~3x faster than on Linux Taras Savchuk
• 2021/06/04 Re: PgSQL 12 on WinSrv ~3x faster than on Linux Tom Lane
• 2021/06/04 Re: PgSQL 12 on WinSrv ~3x faster than on Linux Vijaykumar Jain
• 2021/06/04 Re: PgSQL 12 on WinSrv ~3x faster than on Linux David Rowley
• 2021/06/04 PgSQL 12 on WinSrv ~3x faster than on Linux Taras Savchuk
• 2021/06/04 Re: slow query with inline function on AWS RDS with RDS 24x large Ayub Khan
• 2021/06/04 Re: slow query with inline function on AWS RDS with RDS 24x large Pavel Stehule
• 2021/06/04 Re: slow query with inline function on AWS RDS with RDS 24x large Ayub Khan
• 2021/06/04 Re: slow query with inline function on AWS RDS with RDS 24x large Pavel Stehule
• 2021/06/04 slow query with inline function on AWS RDS with RDS 24x large Ayub Khan
• 2021/06/01 Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 2021/05/31 Re: AWS forcing PG upgrade from v9.6 a disaster Justin Pryzby
• 2021/05/30 Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 2021/05/30 Re: AWS forcing PG upgrade from v9.6 a disaster Tom Lane
• 2021/05/30 Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 2021/05/30 Re: AWS forcing PG upgrade from v9.6 a disaster Christophe Pettus
• 2021/05/30 Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 2021/05/29 Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)

• Earlier messages
• Later messages