pgsql-performance

Messages by Date

2021/08/25 Re: Using regexp from table has unpredictable poor performance Jack Christensen
2021/08/25 Re: Using regexp from table has unpredictable poor performance Justin Pryzby
2021/08/25 Using regexp from table has unpredictable poor performance Jack Christensen
2021/08/24 Re: pg_restore schema dump to schema with different name David G. Johnston
2021/08/24 Re: pg_restore schema dump to schema with different name Laurenz Albe
2021/08/23 Re: Postgres using the wrong index index Matt Dupree
2021/08/23 Re: Postgres using the wrong index index Justin Pryzby
2021/08/23 Re: pg_restore schema dump to schema with different name Nagaraj Raj
2021/08/23 Re: pg_restore schema dump to schema with different name Jean-Christophe Boggio
2021/08/23 Re: pg_restore schema dump to schema with different name Laurenz Albe
2021/08/23 pg_restore schema dump to schema with different name Nagaraj Raj
2021/08/22 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
2021/08/22 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Justin Pryzby
2021/08/22 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Ranier Vilela
2021/08/22 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Ranier Vilela
2021/08/22 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Andrew Dunstan
2021/08/22 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
2021/08/22 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Andrew Dunstan
2021/08/22 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
2021/08/22 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Tom Lane
2021/08/22 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
2021/08/22 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
2021/08/22 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Tom Lane
2021/08/22 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
2021/08/22 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
2021/08/22 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
2021/08/22 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Tom Lane
2021/08/22 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Justin Pryzby
2021/08/21 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
2021/08/21 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
2021/08/21 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Justin Pryzby
2021/08/21 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
2021/08/21 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
2021/08/21 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Justin Pryzby
2021/08/21 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Maciek Sakrejda
2021/08/21 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Justin Pryzby
2021/08/21 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Tom Lane
2021/08/21 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Tom Lane
2021/08/21 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
2021/08/21 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Mladen Gogala
2021/08/21 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Tom Lane
2021/08/21 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
2021/08/21 Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
2021/08/20 RE: Big performance slowdown from 11.2 to 13.3 [email protected]
2021/08/17 Re: Postgres using the wrong index index Justin Pryzby
2021/08/12 Re: Postgres using the wrong index index Justin Pryzby
2021/08/12 Re: Postgres using the wrong index index Matt Dupree
2021/08/11 Re: Postgres using the wrong index index Justin Pryzby
2021/08/11 Re: Postgres using the wrong index index Mladen Gogala
2021/08/11 Re: PostgreSQL equivalent of UTL_HTTP Pavel Stehule
2021/08/11 PostgreSQL equivalent of UTL_HTTP aditya desai
2021/08/11 Re: difference between pg_triggers and information_schema.triggers aditya desai
2021/08/11 Re: difference between pg_triggers and information_schema.triggers David G. Johnston
2021/08/11 difference between pg_triggers and information_schema.triggers aditya desai
2021/08/11 Re: Postgres using the wrong index index Justin Pryzby
2021/08/11 Postgres using the wrong index index Matt Dupree
2021/08/09 Re: Slow query because lexeme index not used Alex
2021/08/07 Re: Slow query because lexeme index not used Justin Pryzby
2021/08/07 Slow query because lexeme index not used Alex
2021/08/05 Re: Logical Replication speed-up initial data Jeff Janes
2021/08/05 Re: Logical Replication speed-up initial data Vijaykumar Jain
2021/08/05 Re: Logical Replication speed-up initial data Nikhil Shetty
2021/08/05 Re: Logical Replication speed-up initial data Nikhil Shetty
2021/08/05 Re: Logical Replication speed-up initial data Avinash Kumar
2021/08/05 Re: Logical Replication speed-up initial data Vijaykumar Jain
2021/08/05 Re: Logical Replication speed-up initial data Rick Otten
2021/08/04 Re: Logical Replication speed-up initial data Nikhil Shetty
2021/08/04 Re: Logical Replication speed-up initial data Nikhil Shetty
2021/08/04 Re: Logical Replication speed-up initial data Christophe Pettus
2021/08/04 Re: Logical Replication speed-up initial data Stefano Amoroso
2021/08/04 Re: Logical Replication speed-up initial data Hüseyin Demir
2021/08/04 Logical Replication speed-up initial data Nikhil Shetty
2021/07/30 Re: Performance issue with thousands of calls to procedures and functions? Daniel Westermann (DWE)
2021/07/30 Re: Performance issue with thousands of calls to procedures and functions? Pavel Stehule
2021/07/30 Re: Performance issue with thousands of calls to procedures and functions? Daniel Westermann (DWE)
2021/07/30 Re: Performance issue with thousands of calls to procedures and functions? Pavel Stehule
2021/07/30 Re: Performance issue with thousands of calls to procedures and functions? Pavel Stehule
2021/07/30 Re: Performance issue with thousands of calls to procedures and functions? Pavel Stehule
2021/07/30 Re: Performance issue with thousands of calls to procedures and functions? Imre Samu
2021/07/30 Performance issue with thousands of calls to procedures and functions? Daniel Westermann (DWE)
2021/07/29 Re: Query performance ! Justin Pryzby
2021/07/29 Re: Performance of lateral join Simen Andreas Andreassen Lønsethagen
2021/07/29 Query performance ! kenny a
2021/07/28 RE: Big performance slowdown from 11.2 to 13.3 [email protected]
2021/07/27 Re: Big performance slowdown from 11.2 to 13.3 Tom Lane
2021/07/27 Re: Big performance slowdown from 11.2 to 13.3 Tom Lane
2021/07/27 Re: Big performance slowdown from 11.2 to 13.3 David G. Johnston
2021/07/27 RE: Big performance slowdown from 11.2 to 13.3 [email protected]
2021/07/27 Re: Performance of lateral join Justin Pryzby
2021/07/27 Re: Query performance ! Bruce Momjian
2021/07/27 Query performance ! kenny a
2021/07/26 Re: Performance of lateral join Justin Pryzby
2021/07/26 Performance of lateral join Simen Andreas Andreassen Lønsethagen
2021/07/25 RE: Big performance slowdown from 11.2 to 13.3 [email protected]
2021/07/25 Re: Big performance slowdown from 11.2 to 13.3 Tom Lane
2021/07/23 Re: Performance Issue on a table Justin Pryzby
2021/07/23 Performance Issue on a table Manoj Kumar
2021/07/23 RE: Big performance slowdown from 11.2 to 13.3 [email protected]
2021/07/23 Re: Big performance slowdown from 11.2 to 13.3 Vijaykumar Jain
2021/07/22 RE: Big performance slowdown from 11.2 to 13.3 [email protected]
2021/07/22 Re: Big performance slowdown from 11.2 to 13.3 Vijaykumar Jain
2021/07/22 Re: Big performance slowdown from 11.2 to 13.3 Alvaro Herrera
2021/07/22 Re: Big performance slowdown from 11.2 to 13.3 Ranier Vilela
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 [email protected]
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 Tom Lane
2021/07/22 RE: Big performance slowdown from 11.2 to 13.3 [email protected]
2021/07/22 Re: Big performance slowdown from 11.2 to 13.3 Justin Pryzby
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 [email protected]
2021/07/22 RE: Big performance slowdown from 11.2 to 13.3 [email protected]
2021/07/22 RE: Big performance slowdown from 11.2 to 13.3 [email protected]
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 Peter Geoghegan
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 Peter Geoghegan
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 Justin Pryzby
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 Justin Pryzby
2021/07/22 RE: Big performance slowdown from 11.2 to 13.3 [email protected]
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 [email protected]
2021/07/22 Re: Big performance slowdown from 11.2 to 13.3 Justin Pryzby
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 [email protected]
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 [email protected]
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 [email protected]
2021/07/22 Re: Partitioned table statistics vs autoanalyze Kamil Frydel
2021/07/22 RE: Big performance slowdown from 11.2 to 13.3 [email protected]
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 [email protected]
2021/07/21 RE: Big performance slowdown from 11.2 to 13.3 [email protected]
2021/07/21 RE: Big performance slowdown from 11.2 to 13.3 [email protected]
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 [email protected]
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 [email protected]
2021/07/21 RE: Big performance slowdown from 11.2 to 13.3 [email protected]
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 [email protected]
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