pgsql-performance

Messages by Date

2022/02/04 Re: Terribly slow query with very good plan? Les
2022/02/04 Re: Terribly slow query with very good plan? Les
2022/02/04 Re: Terribly slow query with very good plan? Nick Cleaton
2022/02/04 Re: Terribly slow query with very good plan? Les
2022/02/04 Re: Terribly slow query with very good plan? Pavel Stehule
2022/02/04 Re: Terribly slow query with very good plan? Laurenz Albe
2022/02/04 Terribly slow query with very good plan? Les
2022/01/25 Query runs slower as prepared statement - identical execution plans Thomas Kellerer
2022/01/24 Re: Slow query fixed by replacing equality with a nested query Michael Lewis
2022/01/24 Re: Slow query fixed by replacing equality with a nested query Michael Lewis
2022/01/24 Re: Slow query fixed by replacing equality with a nested query Valentin Janeiko
2022/01/21 RE: Slow query fixed by replacing equality with a nested query val.janeiko
2022/01/20 Re: Slow query fixed by replacing equality with a nested query Michael Lewis
2022/01/20 Re: PostgreSQL and Linux CPU's David G. Johnston
2022/01/20 PostgreSQL and Linux CPU's Sbob
2022/01/20 Poor performance PostgreSQL 13/ PostGIS 3.x Lugosi, Jim
2022/01/20 Slow query fixed by replacing equality with a nested query Valentin Janeiko
2022/01/20 RE: PostgreSQL 12.8 Same Query Same Execution Plan Different Time Michel SALAIS
2022/01/19 Re: PostgreSQL 12.8 Same Query Same Execution Plan Different Time David G. Johnston
2022/01/19 PostgreSQL 12.8 Same Query Same Execution Plan Different Time Ludwig Isaac Lim
2022/01/18 Re: Unique constraint blues David G. Johnston
2022/01/18 Unique constraint blues Mladen Gogala
2022/01/18 Re: PostgreSQLv14 TPC-H performance GCC vs Clang arjun shetty
2022/01/12 PGBench connection issue with -C option only T T
2022/01/12 Re: About Query Performaces Problem Julien Rouhaud
2022/01/12 Re: About Query Performaces Problem Pavel Stehule
2022/01/12 Re: About Query Performaces Problem Hüseyin Ellezer
2022/01/11 Re: About Query Performaces Problem Pavel Stehule
2022/01/11 About Query Performaces Problem Hüseyin Ellezer
2022/01/06 Re: Same query 10000x More Time Vijaykumar Jain
2022/01/06 RE: Same query 10000x More Time Avi Weinberg
2022/01/06 Re: Same query 10000x More Time Vijaykumar Jain
2022/01/06 RE: Same query 10000x More Time Avi Weinberg
2022/01/06 Re: Same query 10000x More Time Kyotaro Horiguchi
2022/01/06 Re: Same query 10000x More Time Vijaykumar Jain
2022/01/05 Same query 10000x More Time Avi Weinberg
2022/01/05 Re: VACUUM: Nonremovable rows due to wal sender process Steve Nixon
2022/01/04 Re:VACUUM: Nonremovable rows due to wal sender process Sergei Kornilov
2022/01/04 VACUUM: Nonremovable rows due to wal sender process Steve Nixon
2022/01/03 Re: WAL files keep piling up Zbigniew Kostrzewa
2021/12/28 Re: 9.6 write time Marc Millas
2021/12/28 Re: 9.6 write time Tom Lane
2021/12/28 Re: 9.6 write time Marc Millas
2021/12/28 Re: 9.6 write time Tom Lane
2021/12/28 9.6 write time Marc Millas
2021/12/23 Re: WAL files keep piling up Laurenz Albe
2021/12/22 Re: WAL files keep piling up Zbigniew Kostrzewa
2021/12/22 Re: WAL files keep piling up Tom Lane
2021/12/22 Re: WAL files keep piling up Zbigniew Kostrzewa
2021/12/22 Re: WAL files keep piling up Ninad Shah
2021/12/22 WAL files keep piling up Zbigniew Kostrzewa
2021/12/21 Re: Query is slower with a large proportion of NULLs in several columns David G. Johnston
2021/12/21 Re: Query is slower with a large proportion of NULLs in several columns Tom Lane
2021/12/21 Re: Query is slower with a large proportion of NULLs in several columns Lars Bergeson
2021/12/21 Re: Query is slower with a large proportion of NULLs in several columns Justin Pryzby
2021/12/20 Re: Lock contention high Yura Sokolov
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 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) [email protected]
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) [email protected]
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