pgsql-performance  

Messages by Thread

• • Re: Query out of memory Michael Lewis
  • Re: Query out of memory aditya desai
  • Re: Query out of memory Ninad Shah
  • Sv: Fwd: Query out of memory Andreas Joseph Krogh
• Lock contention high Ashkil Dighin
  • Re: Lock contention high Mikhail Zhilin
  • Re: Lock contention high Ashkil Dighin
  • Re: Lock contention high Mikhail Zhilin
  • Re: Lock contention high Laurenz Albe
  • Re: Lock contention high Ashkil Dighin
  • Re: Lock contention high Laurenz Albe
  • Re: Lock contention high Mladen Gogala
  • Re: Lock contention high Justin Pryzby
  • Re: Lock contention high MichaelDBA
  • Re: Lock contention high Paul Friedman
  • Re: Lock contention high Ashkil Dighin
  • Re: Lock contention high Peter Geoghegan
  • Re: Lock contention high Ashkil Dighin
  • Re: Lock contention high Jeremy Schneider
  • Re: Lock contention high Peter Geoghegan
  • Re: Lock contention high Andres Freund
  • Re: Lock contention high Michael Lewis
  • Re: Lock contention high Andres Freund
  • Re: Lock contention high Ashkil Dighin
  • Re: Lock contention high Andres Freund
  • Re: Lock contention high Ashkil Dighin
  • Re: Lock contention high Tom Lane
  • Re: Lock contention high arjun shetty
  • Re: Lock contention high arjun shetty
  • Re: Lock contention high Yura Sokolov
• PG 12 slow selects from pg_settings Julius Tuskenis
  • Re: PG 12 slow selects from pg_settings Ranier Vilela
  • Re: PG 12 slow selects from pg_settings Julius Tuskenis
  • Re: PG 12 slow selects from pg_settings Ranier Vilela
  • Re: PG 12 slow selects from pg_settings Julius Tuskenis
• Troubleshooting a long running delete statement Dirschel, Steve
  • Re: Troubleshooting a long running delete statement Mladen Gogala
  • RE: [EXT] Re: Troubleshooting a long running delete statement Dirschel, Steve
  • Re: [EXT] Re: Troubleshooting a long running delete statement Mladen Gogala
  • Re: Troubleshooting a long running delete statement Justin Pryzby
  • RE: [EXT] Re: Troubleshooting a long running delete statement Dirschel, Steve
  • Re: [EXT] Re: Troubleshooting a long running delete statement Mladen Gogala
  • Re: [EXT] Re: Troubleshooting a long running delete statement Maciek Sakrejda
  • Re: [EXT] Re: Troubleshooting a long running delete statement Corey Huinker
  • Re: Troubleshooting a long running delete statement Laurenz Albe
  • Re: Troubleshooting a long running delete statement Michael Lewis
• Better, consistent instrumentation for postgreSQL using a similar API as Oracle Jeff Holt
  • Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Laurenz Albe
  • Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala
  • Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle [email protected]
  • Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala
  • Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Peter Geoghegan
  • Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala
  • Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Peter Geoghegan
  • Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Ranier Vilela
  • Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Laurenz Albe
  • Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala
  • Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Bruce Momjian
  • Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Peter Geoghegan
  • Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala
  • Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Tim
  • Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala
  • Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Jeremy Schneider
  • Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Bruce Momjian
  • Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Jeremy Schneider
  • Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Bruce Momjian
  • Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala
  • Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Bruce Momjian
  • Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Thomas Kellerer
  • Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Bruce Momjian
  • Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Julien Rouhaud
  • Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Thomas Kellerer
  • Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Mladen Gogala
  • Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Franck Pachot
  • Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Laurenz Albe
  • Re: Better, consistent instrumentation for postgreSQL using a similar API as Oracle Bruce Momjian
• Query going to all paritions aditya desai
  • Re: Query going to all paritions Laurenz Albe
  • Re: Query going to all paritions hubert depesz lubaczewski
  • Re: Query going to all paritions aditya desai
• How to improve cockroach performance with pgbench? Fabien COELHO
• Re: Problem with indices from 10 to 13 Ranier Vilela
  • Re: Problem with indices from 10 to 13 Alan Hodgson
  • Re: Problem with indices from 10 to 13 Tom Lane
  • Re: Problem with indices from 10 to 13 Tom Lane
  • Re: Problem with indices from 10 to 13 Justin Pryzby
• Partial index on enum type is not being used, type issue? Kim Johan Andersson
  • Re: Partial index on enum type is not being used, type issue? Tom Lane
• Performance for initial copy when using pg_logical to upgrade Postgres Westwood, Giles
  • Re: Performance for initial copy when using pg_logical to upgrade Postgres Justin Pryzby
  • Re: Performance for initial copy when using pg_logical to upgrade Postgres Westwood, Giles
  • Re: Performance for initial copy when using pg_logical to upgrade Postgres Tim
  • Re: Performance for initial copy when using pg_logical to upgrade Postgres Westwood, Giles
  • Re: Performance for initial copy when using pg_logical to upgrade Postgres Andrew Dunstan
• Re: hashjoins, index loops to retrieve pk/ux constrains in pg12 Michael Lewis
  • Re: hashjoins, index loops to retrieve pk/ux constrains in pg12 Arturas Mazeika
  • Re: hashjoins, index loops to retrieve pk/ux constrains in pg12 Michael Lewis
  • Re: hashjoins, index loops to retrieve pk/ux constrains in pg12 Arturas Mazeika
  • Re: hashjoins, index loops to retrieve pk/ux constrains in pg12 Tom Lane
  • Re: hashjoins, index loops to retrieve pk/ux constrains in pg12 Arturas Mazeika
• multi-tenant queries select wrong index Kirill
  • Re: multi-tenant queries select wrong index Alexey M Boltenkov
• Query executed during pg_dump leads to excessive memory usage Ulf Lohbrügge
  • Re: Query executed during pg_dump leads to excessive memory usage Ranier Vilela
  • Re: Query executed during pg_dump leads to excessive memory usage Ulf Lohbrügge
  • Re: Query executed during pg_dump leads to excessive memory usage Gogala, Mladen
  • Re: Query executed during pg_dump leads to excessive memory usage Tom Lane
• Want function to be called only once in query Steve Pritchard
  • Re: Want function to be called only once in query Jim Mlodgenski
  • Re: Want function to be called only once in query Steve Pritchard
• EnterpriseDB Mladen Gogala
  • Re: EnterpriseDB sbob
  • Re: EnterpriseDB manish yadav
• Postgres chooses slow query plan from time to time Kristjan Mustkivi
  • Re: Postgres chooses slow query plan from time to time Tomas Vondra
  • Re: Postgres chooses slow query plan from time to time Michael Lewis
  • Re: Postgres chooses slow query plan from time to time Justin Pryzby
  • Re: Postgres chooses slow query plan from time to time Kristjan Mustkivi
  • Re: Postgres chooses slow query plan from time to time Laurenz Albe
  • Re: Postgres chooses slow query plan from time to time Jeff Janes
  • Re: Postgres chooses slow query plan from time to time Kristjan Mustkivi
  • Re: Postgres chooses slow query plan from time to time Tom Lane
  • Re: Postgres chooses slow query plan from time to time Kristjan Mustkivi
  • Re: Postgres chooses slow query plan from time to time Tom Lane
  • Re: Postgres chooses slow query plan from time to time Kristjan Mustkivi
  • Re: Postgres chooses slow query plan from time to time Tom Lane
  • Re: Postgres chooses slow query plan from time to time Kristjan Mustkivi
  • Re: Postgres chooses slow query plan from time to time Tom Lane
  • Re: Postgres chooses slow query plan from time to time Kristjan Mustkivi
  • Re: Postgres chooses slow query plan from time to time Jeff Janes
  • Re: Postgres chooses slow query plan from time to time Kristjan Mustkivi
  • Re: Postgres chooses slow query plan from time to time Jeff Janes
• sql execution time in pg_stat_statements Michel SALAIS
  • RE: sql execution time in pg_stat_statements Michel SALAIS
  • Re: sql execution time in pg_stat_statements Julien Rouhaud
  • RE: sql execution time in pg_stat_statements Michel SALAIS
  • Re: sql execution time in pg_stat_statements Tom Lane
  • RE: sql execution time in pg_stat_statements Michel SALAIS
  • Re: sql execution time in pg_stat_statements Julien Rouhaud
• PostgreSql 9.4 Database connection failure Lionel Napoleon
  • Re: PostgreSql 9.4 Database connection failure Ranier Vilela
  • Re: PostgreSql 9.4 Database connection failure Ranier Vilela
• Better performance no-throw conversion? [email protected]
  • Re: Better performance no-throw conversion? Andrew Dunstan
  • RE: Better performance no-throw conversion? [email protected]
  • Re: Better performance no-throw conversion? Tom Lane
  • Re: Better performance no-throw conversion? Michael Lewis
  • RE: Better performance no-throw conversion? [email protected]
• Foreign table as partition - Non optimal aggregation plan Stepan Yankevych
• FDW join vs full join push down Marc Olivé
• Using regexp from table has unpredictable poor performance Jack Christensen
  • Re: Using regexp from table has unpredictable poor performance Justin Pryzby
  • Re: Using regexp from table has unpredictable poor performance Jack Christensen
  • Re: Using regexp from table has unpredictable poor performance Vitalii Tymchyshyn
• pg_restore schema dump to schema with different name Nagaraj Raj
  • Re: pg_restore schema dump to schema with different name Laurenz Albe
  • Re: pg_restore schema dump to schema with different name Jean-Christophe Boggio
  • Re: pg_restore schema dump to schema with different name Nagaraj Raj
  • Re: pg_restore schema dump to schema with different name Laurenz Albe
  • Re: pg_restore schema dump to schema with different name David G. Johnston
  • Re: pg_restore schema dump to schema with different name Nagaraj Raj
• Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
  • RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
  • Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Tom Lane
  • Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Mladen Gogala
  • Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Tom Lane
  • RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
  • RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
  • Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Tom Lane
  • Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Justin Pryzby
  • Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Maciek Sakrejda
  • Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Justin Pryzby
  • RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
  • Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Justin Pryzby
  • RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
  • RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
  • Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Justin Pryzby
  • Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Tom Lane
  • RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
  • RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
  • Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Tom Lane
  • RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
  • RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
  • Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Tom Lane
  • RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
  • Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Ranier Vilela
  • Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Justin Pryzby
  • RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
  • RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
  • Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Andrew Dunstan
  • RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
  • Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Tom Lane
  • RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
  • RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
  • Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Tom Lane
  • RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]
  • Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Ranier Vilela
  • Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Tom Lane
  • Re: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 Ranier Vilela
  • RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 [email protected]

• Earlier messages
• Later messages