pgsql-performance  

Messages by Date

• 2022/02/28 RE: An I/O error occurred while sending to the backend (PG 13.4) [email protected]
• 2022/02/27 Re: slow query to improve performace Jeff Janes
• 2022/02/27 Re: Never Ending query in PostgreSQL Jeff Janes
• 2022/02/27 Re: Never Ending query in PostgreSQL Julien Rouhaud
• 2022/02/27 Never Ending query in PostgreSQL Kumar, Mukesh
• 2022/02/25 Re: slow query to improve performace Justin Pryzby
• 2022/02/25 slow query to improve performace Ayub Khan
• 2022/02/25 RE: Slow Running Queries in Azure PostgreSQL Kumar, Mukesh
• 2022/02/25 Re: An I/O error occurred while sending to the backend (PG 13.4) Justin Pryzby
• 2022/02/24 Re: Slow plan choice with prepared query MichaelDBA
• 2022/02/24 Re: Slow plan choice with prepared query MichaelDBA
• 2022/02/24 Re: Advice needed: query performance deteriorates by 2000% within 1 minute Tom Lane
• 2022/02/24 Re: Advice needed: query performance deteriorates by 2000% within 1 minute Michael Lewis
• 2022/02/24 Advice needed: query performance deteriorates by 2000% within 1 minute Peter Adlersburg
• 2022/02/24 Re: An I/O error occurred while sending to the backend (PG 13.4) Ranier Vilela
• 2022/02/24 Re: An I/O error occurred while sending to the backend (PG 13.4) Justin Pryzby
• 2022/02/24 Re: An I/O error occurred while sending to the backend (PG 13.4) Ranier Vilela
• 2022/02/23 Slow plan choice with prepared query Mark Saward
• 2022/02/23 Re: An I/O error occurred while sending to the backend (PG 13.4) Justin Pryzby
• 2022/02/23 Re: An I/O error occurred while sending to the backend (PG 13.4) Justin Pryzby
• 2022/02/23 RE: An I/O error occurred while sending to the backend (PG 13.4) [email protected]
• 2022/02/22 Re: Slow Running Queries in Azure PostgreSQL Justin Pryzby
• 2022/02/18 Re: Poor performance PostgreSQL 13/ PostGIS 3.x Merlin Moncure
• 2022/02/09 Re: Query chooses Bad Index Path Tomas Vondra
• 2022/02/08 Query chooses Bad Index Path Valli Annamalai
• 2022/02/08 Re: Query choosing Bad Index Path (ASC/DESC ordering). Mind Body Nature
• 2022/02/07 Query choosing Bad Index Path (ASC/DESC ordering). Valli Annamalai
• 2022/02/07 Re: slow "select count(*) from information_schema.tables;" in some cases Imre Samu
• 2022/02/07 Re: slow "select count(*) from information_schema.tables;" in some cases Lars Aksel Opsahl
• 2022/02/07 Re: slow "select count(*) from information_schema.tables;" in some cases Tom Lane
• 2022/02/07 Re: slow "select count(*) from information_schema.tables;" in some cases Lars Aksel Opsahl
• 2022/02/07 Re: slow "select count(*) from information_schema.tables;" in some cases Vijaykumar Jain
• 2022/02/07 Re: slow "select count(*) from information_schema.tables;" in some cases Lars Aksel Opsahl
• 2022/02/07 Re: slow "select count(*) from information_schema.tables;" in some cases Justin Pryzby
• 2022/02/07 slow "select count(*) from information_schema.tables;" in some cases Lars Aksel Opsahl
• 2022/02/05 Re: Terribly slow query with very good plan? Vijaykumar Jain
• 2022/02/04 Re: Terribly slow query with very good plan? Les
• 2022/02/04 Re: Terribly slow query with very good plan? Thomas Kellerer
• 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? Nick Cleaton
• 2022/02/04 Re: Terribly slow query with very good plan? Ninad Shah
• 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? 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? 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? Les
• 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

• Earlier messages
• Later messages