pgsql-performance

Messages by Date

2021/10/25 Re: Lock contention high Andres Freund
2021/10/25 Re: Lock contention high Michael Lewis
2021/10/25 Re: Lock contention high Andres Freund
2021/10/22 Re: Query out of memory Ninad Shah
2021/10/20 Re: Lock contention high Ashkil Dighin
2021/10/20 Re: Postgres views cannot use both union and join/where David G. Johnston
2021/10/20 Re: Postgres views cannot use both union and join/where Tom Lane
2021/10/19 Re: Postgres views cannot use both union and join/where David G. Johnston
2021/10/19 Re: Postgres views cannot use both union and join/where Michael Lewis
2021/10/19 Re: Postgres views cannot use both union and join/where Benedict Holland
2021/10/19 Re: Postgres views cannot use both union and join/where David G. Johnston
2021/10/19 Postgres views cannot use both union and join/where Mithran Kulasekaran
2021/10/19 Re: Query out of memory aditya desai
2021/10/19 Re: Query out of memory Michael Lewis
2021/10/19 Sv: Fwd: Query out of memory Andreas Joseph Krogh
2021/10/19 Re: Query out of memory aditya desai
2021/10/19 Re: Fwd: Query out of memory Justin Pryzby
2021/10/19 Re: Query out of memory Dave Cramer
2021/10/19 Re: Query out of memory Adam Brusselback
2021/10/18 Fwd: Query out of memory aditya desai
2021/10/14 Re: Lock contention high Ashkil Dighin
2021/10/14 Re: Lock contention high Ashkil Dighin
2021/10/14 Re: Lock contention high Ashkil Dighin
2021/10/14 Re: Lock contention high Mikhail Zhilin
2021/10/13 Re: Lock contention high Laurenz Albe
2021/10/13 Re: Lock contention high Peter Geoghegan
2021/10/13 Re: Lock contention high Jeremy Schneider
2021/10/13 Re: Lock contention high Peter Geoghegan
2021/10/13 Re: Lock contention high Paul Friedman
2021/10/13 Re: Lock contention high MichaelDBA
2021/10/13 Re: Lock contention high Justin Pryzby
2021/10/12 Re: Lock contention high Mladen Gogala
2021/10/12 Re: Lock contention high Laurenz Albe
2021/10/12 Re: Lock contention high Mikhail Zhilin
2021/10/12 Lock contention high Ashkil Dighin
2021/10/11 Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Bruce Momjian
2021/10/10 Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Laurenz Albe
2021/10/10 Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Franck Pachot
2021/10/08 Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala
2021/10/08 Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Thomas Kellerer
2021/10/08 Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Julien Rouhaud
2021/10/08 Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Bruce Momjian
2021/10/08 Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Thomas Kellerer
2021/10/08 Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Bruce Momjian
2021/10/08 Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Bruce Momjian
2021/10/08 Re: PG 12 slow selects from pg_settings Julius Tuskenis
2021/10/08 Re: PG 12 slow selects from pg_settings Ranier Vilela
2021/10/08 Re: PG 12 slow selects from pg_settings Julius Tuskenis
2021/10/08 Re: PG 12 slow selects from pg_settings Ranier Vilela
2021/10/08 PG 12 slow selects from pg_settings Julius Tuskenis
2021/10/07 Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Jeremy Schneider
2021/10/07 Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala
2021/10/07 Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Bruce Momjian
2021/10/07 Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Jeremy Schneider
2021/10/07 Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Bruce Momjian
2021/10/07 Re: [EXT] Re: Troubleshooting a long running delete statement Corey Huinker
2021/10/06 Re: [EXT] Re: Troubleshooting a long running delete statement Maciek Sakrejda
2021/10/06 Re: Troubleshooting a long running delete statement Michael Lewis
2021/10/06 Re: [EXT] Re: Troubleshooting a long running delete statement Mladen Gogala
2021/10/06 Re: [EXT] Re: Troubleshooting a long running delete statement Mladen Gogala
2021/10/06 RE: [EXT] Re: Troubleshooting a long running delete statement Dirschel, Steve
2021/10/06 RE: [EXT] Re: Troubleshooting a long running delete statement Dirschel, Steve
2021/10/06 Re: Troubleshooting a long running delete statement Laurenz Albe
2021/10/06 Re: Troubleshooting a long running delete statement Justin Pryzby
2021/10/06 Re: Troubleshooting a long running delete statement Mladen Gogala
2021/10/06 Troubleshooting a long running delete statement Dirschel, Steve
2021/10/05 Installation of PostgreSQL on fedora zVM Manish Lad
2021/10/05 Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala
2021/10/05 Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Tim
2021/10/05 Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala
2021/10/05 Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Peter Geoghegan
2021/10/05 Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala
2021/10/05 Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Ranier Vilela
2021/10/05 Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Laurenz Albe
2021/10/04 Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Peter Geoghegan
2021/10/04 Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala
2021/10/04 Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala
2021/10/04 Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Peter Geoghegan
2021/10/04 Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle [email protected]
2021/10/04 Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala
2021/10/03 Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Laurenz Albe
2021/10/01 Better, consistent instrumentation for postgreSQL using a similar API as Oracle Jeff Holt
2021/10/01 Re: Query going to all paritions aditya desai
2021/10/01 Re: Query going to all paritions hubert depesz lubaczewski
2021/10/01 Re: Query going to all paritions Laurenz Albe
2021/10/01 Query going to all paritions aditya desai
2021/09/29 How to improve cockroach performance with pgbench? Fabien COELHO
2021/09/29 Re: hashjoins, index loops to retrieve pk/ux constrains in pg12 Arturas Mazeika
2021/09/28 Re: Problem with indices from 10 to 13 Justin Pryzby
2021/09/28 Re: Problem with indices from 10 to 13 Tom Lane
2021/09/28 Re: Problem with indices from 10 to 13 Alan Hodgson
2021/09/28 Re: Problem with indices from 10 to 13 Tom Lane
2021/09/28 Re: Problem with indices from 10 to 13 Ranier Vilela
2021/09/28 Re: hashjoins, index loops to retrieve pk/ux constrains in pg12 Tom Lane
2021/09/27 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
2021/09/27 Re: Partial index on enum type is not being used, type issue? Tom Lane
2021/09/27 Partial index on enum type is not being used, type issue? Kim Johan Andersson
2021/09/27 Re: hashjoins, index loops to retrieve pk/ux constrains in pg12 Arturas Mazeika
2021/09/27 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
2021/09/27 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 tushar
2021/09/27 Re: hashjoins, index loops to retrieve pk/ux constrains in pg12 Michael Lewis
2021/09/27 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Andrew Dunstan
2021/09/27 Re: hashjoins, index loops to retrieve pk/ux constrains in pg12 Arturas Mazeika
2021/09/25 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
2021/09/24 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
2021/09/24 Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Andrew Dunstan
2021/09/24 Re: Performance for initial copy when using pg_logical to upgrade Postgres Tim
2021/09/24 Re: Performance for initial copy when using pg_logical to upgrade Postgres Andrew Dunstan
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 [email protected]
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 [email protected]
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? [email protected]
2021/09/08 RE: Better performance no-throw conversion? [email protected]
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? [email protected]
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 [email protected]
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 [email protected]
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 [email protected]
2021/08/29 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 (workarounds) [email protected]
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 [email protected]
2021/08/29 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
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 [email protected]
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 [email protected]
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 [email protected]
2021/08/28 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
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 [email protected]
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 [email protected]
2021/08/25 Re: Using regexp from table has unpredictable poor performance Vitalii Tymchyshyn