pgsql-performance

Messages by Date

2021/09/24 Re: Performance for initial copy when using pg_logical to upgrade Postgres Westwood, Giles
2021/09/24 Re: Performance for initial copy when using pg_logical to upgrade Postgres Justin Pryzby
2021/09/24 Performance for initial copy when using pg_logical to upgrade Postgres Westwood, Giles
2021/09/23 Re: hashjoins, index loops to retrieve pk/ux constrains in pg12 Michael Lewis
2021/09/21 Re: multi-tenant queries select wrong index Alexey M Boltenkov
2021/09/20 multi-tenant queries select wrong index Kirill
2021/09/19 Re: Query executed during pg_dump leads to excessive memory usage Tom Lane
2021/09/19 Re: Query executed during pg_dump leads to excessive memory usage Gogala, Mladen
2021/09/19 Re: Query executed during pg_dump leads to excessive memory usage Ulf Lohbrügge
2021/09/19 RE: sql execution time in pg_stat_statements Michel SALAIS
2021/09/19 Re: Query executed during pg_dump leads to excessive memory usage Ranier Vilela
2021/09/19 Query executed during pg_dump leads to excessive memory usage Ulf Lohbrügge
2021/09/16 Re: Want function to be called only once in query Steve Pritchard
2021/09/16 Re: Want function to be called only once in query Jim Mlodgenski
2021/09/16 Want function to be called only once in query Steve Pritchard
2021/09/16 Re: Postgres chooses slow query plan from time to time Kristjan Mustkivi
2021/09/15 Re: Postgres chooses slow query plan from time to time Tom Lane
2021/09/15 Re: Postgres chooses slow query plan from time to time Kristjan Mustkivi
2021/09/15 Re: Postgres chooses slow query plan from time to time Tom Lane
2021/09/14 Re: Postgres chooses slow query plan from time to time Kristjan Mustkivi
2021/09/14 Re: EnterpriseDB manish yadav
2021/09/14 Re: Postgres chooses slow query plan from time to time Tom Lane
2021/09/14 Re: Postgres chooses slow query plan from time to time Kristjan Mustkivi
2021/09/14 Re: EnterpriseDB sbob
2021/09/14 Re: Postgres chooses slow query plan from time to time Tom Lane
2021/09/14 Re: Postgres chooses slow query plan from time to time Kristjan Mustkivi
2021/09/14 Re: Postgres chooses slow query plan from time to time Jeff Janes
2021/09/14 Re: Postgres chooses slow query plan from time to time Laurenz Albe
2021/09/14 Re: Postgres chooses slow query plan from time to time Kristjan Mustkivi
2021/09/14 Re: Postgres chooses slow query plan from time to time Kristjan Mustkivi
2021/09/13 EnterpriseDB Mladen Gogala
2021/09/13 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Andrew Dunstan
2021/09/13 Re: Postgres chooses slow query plan from time to time Jeff Janes
2021/09/13 Re: Postgres chooses slow query plan from time to time Jeff Janes
2021/09/13 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 l...@laurent-hasson.com
2021/09/13 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Andrew Dunstan
2021/09/13 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 l...@laurent-hasson.com
2021/09/13 Re: Postgres chooses slow query plan from time to time Justin Pryzby
2021/09/13 Re: Postgres chooses slow query plan from time to time Michael Lewis
2021/09/13 Re: Postgres chooses slow query plan from time to time Tomas Vondra
2021/09/13 Postgres chooses slow query plan from time to time Kristjan Mustkivi
2021/09/10 Re: sql execution time in pg_stat_statements Julien Rouhaud
2021/09/10 Re: sql execution time in pg_stat_statements Tom Lane
2021/09/10 RE: sql execution time in pg_stat_statements Michel SALAIS
2021/09/10 Re: PostgreSql 9.4 Database connection failure Ranier Vilela
2021/09/09 Re: sql execution time in pg_stat_statements Julien Rouhaud
2021/09/09 RE: sql execution time in pg_stat_statements Michel SALAIS
2021/09/09 sql execution time in pg_stat_statements Michel SALAIS
2021/09/09 Re: PostgreSql 9.4 Database connection failure Ranier Vilela
2021/09/09 PostgreSql 9.4 Database connection failure Lionel Napoleon
2021/09/08 RE: Better performance no-throw conversion? l...@laurent-hasson.com
2021/09/08 RE: Better performance no-throw conversion? l...@laurent-hasson.com
2021/09/08 Re: Better performance no-throw conversion? Michael Lewis
2021/09/08 Re: Better performance no-throw conversion? Tom Lane
2021/09/08 Re: Better performance no-throw conversion? Andrew Dunstan
2021/09/08 Better performance no-throw conversion? l...@laurent-hasson.com
2021/09/07 Foreign table as partition - Non optimal aggregation plan Stepan Yankevych
2021/09/07 FDW join vs full join push down Marc Olivé
2021/09/02 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Andrew Dunstan
2021/09/02 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Ranier Vilela
2021/09/02 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Julien Rouhaud
2021/08/31 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Julien Rouhaud
2021/08/31 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Andrew Dunstan
2021/08/31 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Julien Rouhaud
2021/08/31 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 l...@laurent-hasson.com
2021/08/31 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Andrew Dunstan
2021/08/30 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Michel SALAIS
2021/08/30 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 l...@laurent-hasson.com
2021/08/30 Re: pg_restore schema dump to schema with different name Nagaraj Raj
2021/08/30 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 l...@laurent-hasson.com
2021/08/29 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 (workarounds) l...@laurent-hasson.com
2021/08/29 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 (workarounds) Justin Pryzby
2021/08/29 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Pavel Stehule
2021/08/29 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Julien Rouhaud
2021/08/29 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Ranier Vilela
2021/08/29 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 l...@laurent-hasson.com
2021/08/29 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 l...@laurent-hasson.com
2021/08/29 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Ranier Vilela
2021/08/29 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Tom Lane
2021/08/29 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 l...@laurent-hasson.com
2021/08/29 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Ranier Vilela
2021/08/29 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Tom Lane
2021/08/29 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Ranier Vilela
2021/08/28 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 l...@laurent-hasson.com
2021/08/28 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Tom Lane
2021/08/28 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 l...@laurent-hasson.com
2021/08/28 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 l...@laurent-hasson.com
2021/08/27 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Tom Lane
2021/08/26 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 l...@laurent-hasson.com
2021/08/26 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Andrew Dunstan
2021/08/26 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 l...@laurent-hasson.com
2021/08/25 Re: Using regexp from table has unpredictable poor performance Vitalii Tymchyshyn
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 l...@laurent-hasson.com
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 l...@laurent-hasson.com
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 l...@laurent-hasson.com
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 l...@laurent-hasson.com
2021/08/22 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 l...@laurent-hasson.com
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 l...@laurent-hasson.com
2021/08/22 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 l...@laurent-hasson.com
2021/08/22 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 l...@laurent-hasson.com
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 l...@laurent-hasson.com
2021/08/21 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 l...@laurent-hasson.com
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 l...@laurent-hasson.com
2021/08/21 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 l...@laurent-hasson.com
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 l...@laurent-hasson.com
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 l...@laurent-hasson.com
2021/08/21 Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 l...@laurent-hasson.com
2021/08/20 RE: Big performance slowdown from 11.2 to 13.3 l...@laurent-hasson.com
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 l...@laurent-hasson.com
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 l...@laurent-hasson.com
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 l...@laurent-hasson.com
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 l...@laurent-hasson.com
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 l...@laurent-hasson.com
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 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 Tom Lane
2021/07/22 RE: Big performance slowdown from 11.2 to 13.3 l...@laurent-hasson.com