pgsql-performance

Messages by Date

2021/12/20 Re: Query is slower with a large proportion of NULLs in several columns David G. Johnston
2021/12/20 Re: Query is slower with a large proportion of NULLs in several columns David G. Johnston
2021/12/20 Re: Query is slower with a large proportion of NULLs in several columns Tom Lane
2021/12/20 Re: Query is slower with a large proportion of NULLs in several columns Justin Pryzby
2021/12/20 Re: Query is slower with a large proportion of NULLs in several columns Lars Bergeson
2021/12/20 Re: Query is slower with a large proportion of NULLs in several columns Tom Lane
2021/12/20 Re: Query is slower with a large proportion of NULLs in several columns David G. Johnston
2021/12/20 Query is slower with a large proportion of NULLs in several columns Lars Bergeson
2021/12/16 PostgreSQLv14 performance client-server-HammerDB arjun shetty
2021/12/10 Re: PostgreSQLv14 TPC-H performance GCC vs Clang Imre Samu
2021/12/09 Re: pg_trgm word_similarity query does not use index for input strings longer than 8 characters pgsql-performance
2021/12/07 Re: pg_trgm word_similarity query does not use index for input strings longer than 8 characters Tom Lane
2021/12/06 Re: pg_trgm word_similarity query does not use index for input strings longer than 8 characters Laurenz Albe
2021/12/06 pg_trgm word_similarity query does not use index for input strings longer than 8 characters pgsql-performance
2021/12/04 Re: An I/O error occurred while sending to the backend (PG 13.4) Justin Pryzby
2021/12/04 RE: An I/O error occurred while sending to the backend (PG 13.4) l...@laurent-hasson.com
2021/12/04 Re: An I/O error occurred while sending to the backend (PG 13.4) Justin Pryzby
2021/12/04 An I/O error occurred while sending to the backend (PG 13.4) l...@laurent-hasson.com
2021/12/02 Re: LwLockRelease performance Andres Freund
2021/12/02 Re: LwLockRelease performance Tom Lane
2021/12/02 LwLockRelease performance Ashkil Dighin
2021/11/29 Re: Need help identifying a periodic performance issue. Robert Creager
2021/11/29 Re: Lock contention high arjun shetty
2021/11/25 Re: pg_dump backup verification Justin Pryzby
2021/11/25 AW: [External] pg_dump backup verification Dirk Krautschick
2021/11/25 pg_dump backup verification Daulat
2021/11/24 Re: Need help identifying a periodic performance issue. Justin Pryzby
2021/11/24 Re: Need help identifying a periodic performance issue. Robert Creager
2021/11/24 Re: Need help identifying a periodic performance issue. Robert Creager
2021/11/24 Re: Out of memory error aditya desai
2021/11/24 Re: Postgres process count GCC vs Clang is Different on autovaccum=on Tomas Vondra
2021/11/24 Re: Out of memory error Thomas Kellerer
2021/11/24 Re: Out of memory error Thomas Kellerer
2021/11/24 Postgres process count GCC vs Clang is Different on autovaccum=on hpc researcher_mspk
2021/11/23 Re: Out of memory error aditya desai
2021/11/23 Re: Out of memory error aditya desai
2021/11/23 Re: Out of memory error Michael Lewis
2021/11/23 Re: Out of memory error aditya desai
2021/11/23 Re: Out of memory error Thomas Kellerer
2021/11/23 Re: Out of memory error aditya desai
2021/11/23 Re: Out of memory error Tom Lane
2021/11/23 Out of memory error aditya desai
2021/11/23 Re: performance of analytical query Justin Pryzby
2021/11/19 Re: Need help identifying a periodic performance issue. Robert Creager
2021/11/18 Re: Need help identifying a periodic performance issue. Robert Creager
2021/11/18 Re: Need help identifying a periodic performance issue. Robert Creager
2021/11/18 Re: Need help identifying a periodic performance issue. Tom Lane
2021/11/18 Re: Need help identifying a periodic performance issue. Thomas Munro
2021/11/18 Re: Need help identifying a periodic performance issue. Robert Creager
2021/11/17 Re: Need help identifying a periodic performance issue. Justin Pryzby
2021/11/17 Re: Need help identifying a periodic performance issue. Thomas Munro
2021/11/17 Re: Need help identifying a periodic performance issue. Robert Creager
2021/11/17 Re: Need help identifying a periodic performance issue. Justin Pryzby
2021/11/17 Re: Need help identifying a periodic performance issue. Thomas Munro
2021/11/17 Re: Need help identifying a periodic performance issue. Robert Creager
2021/11/17 Re: Need help identifying a periodic performance issue. Tom Lane
2021/11/17 Re: Need help identifying a periodic performance issue. Justin Pryzby
2021/11/17 Re: Need help identifying a periodic performance issue. Robert Creager
2021/11/16 Re: Lock contention high arjun shetty
2021/11/16 Re: Need help identifying a periodic performance issue. Thomas Munro
2021/11/16 Re: Need help identifying a periodic performance issue. Thomas Munro
2021/11/16 Re: Need help identifying a periodic performance issue. Robert Creager
2021/11/16 Re: Need help identifying a periodic performance issue. Robert Creager
2021/11/16 PostgreSQLv14 TPC-H performance GCC vs Clang arjun shetty
2021/11/15 Re: Need help identifying a periodic performance issue. Thomas Munro
2021/11/15 Re: Need help identifying a periodic performance issue. Justin Pryzby
2021/11/15 Re: Lock contention high Tom Lane
2021/11/15 Re: postgresql13-llvm jit-13.5-1PGDG.rhel8.x86_64 Rick Otten
2021/11/15 Re: postgresql13-llvm jit-13.5-1PGDG.rhel8.x86_64 Mladen Gogala
2021/11/15 Re: Lock contention high Ashkil Dighin
2021/11/14 Re: postgresql13-llvm jit-13.5-1PGDG.rhel8.x86_64 Pavel Stehule
2021/11/14 postgresql13-llvm jit-13.5-1PGDG.rhel8.x86_64 Mladen Gogala
2021/11/12 Re: performance of analytical query Jiří Fejfar
2021/11/12 Re: performance of analytical query Justin Pryzby
2021/11/12 Re: performance of analytical query Michael Lewis
2021/11/11 Re: performance of analytical query Justin Pryzby
2021/11/11 performance of analytical query Jiří Fejfar
2021/11/09 Re: EXISTS by itself vs SELECT EXISTS much slower in query. Jimmy A
2021/11/08 Re: EXISTS by itself vs SELECT EXISTS much slower in query. Tom Lane
2021/11/08 Re: EXISTS by itself vs SELECT EXISTS much slower in query. Vasya Boytsov
2021/11/08 EXISTS by itself vs SELECT EXISTS much slower in query. Jimmy A
2021/11/05 Re: PostgreSQLv14 TPC-H performance GCC vs Clang Tomas Vondra
2021/11/05 Re: PostgreSQLv14 TPC-H performance GCC vs Clang arjun shetty
2021/11/04 JIT llvm11 package ANASTACIO Tiago
2021/11/02 Re: PostgreSQLv14 TPC-H performance GCC vs Clang Imre Samu
2021/11/02 PostgreSQLv14 TPC-H performance GCC vs Clang arjun shetty
2021/10/28 Re: Lock contention high Ashkil Dighin
2021/10/28 Re: Views don't seem to use indexes? Tim Slechta
2021/10/27 Re: Views don't seem to use indexes? Tom Lane
2021/10/27 Re: Views don't seem to use indexes? David G. Johnston
2021/10/27 Views don't seem to use indexes? Tim Slechta
2021/10/27 Re: Lock contention high Andres Freund
2021/10/27 Re: Performance for initial copy when using pg_logical to upgrade Postgres Westwood, Giles
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 michael...@sqlexec.com
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 l...@laurent-hasson.com
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 l...@laurent-hasson.com
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 l...@laurent-hasson.com
2021/09/24 RE: Big Performance drop of Exceptions in UDFs between V11.2 and 13.4 l...@laurent-hasson.com
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