pgsql-performance  

Messages by Date

• 2022/03/24 Performance issue post upgrade on Version 13 - Incorrect Estimation Cost choosing Hash Aggregate-Nested Left Loop Join Prajna Shetty
• 2022/03/24 Re: Using system tables directly takes many hours, using temp tables with no indexes takes a few seconds for geometry_columns view. Lars Aksel Opsahl
• 2022/03/23 Re: High process memory consumption when running sort Justin Pryzby
• 2022/03/23 Re: Using system tables directly takes many hours, using temp tables with no indexes takes a few seconds for geometry_columns view. Lars Aksel Opsahl
• 2022/03/23 High process memory consumption when running sort Shai Shapira
• 2022/03/23 Re: Using system tables directly takes many hours, using temp tables with no indexes takes a few seconds for geometry_columns view. Justin Pryzby
• 2022/03/23 Re: Using system tables directly takes many hours, using temp tables with no indexes takes a few seconds for geometry_columns view. Lars Aksel Opsahl
• 2022/03/23 Using system tables directly takes many hours, using temp tables with no indexes takes a few seconds for geometry_columns view. Lars Aksel Opsahl
• 2022/03/16 RE: Optimal configuration for server Michel SALAIS
• 2022/03/12 Re: Optimal configuration for server Moises Lopez
• 2022/03/09 Re: Explain analyse with track_io_timing Jayadevan M
• 2022/03/09 Re: Explain analyse with track_io_timing Julien Rouhaud
• 2022/03/09 Explain analyse with track_io_timing Jayadevan M
• 2022/03/08 Re: Any way to speed up INSERT INTO aditya desai
• 2022/03/08 Re: Any way to speed up INSERT INTO Bruce Momjian
• 2022/03/08 Re: Any way to speed up INSERT INTO aditya desai
• 2022/03/07 Re: Optimal configuration for server Justin Pryzby
• 2022/03/07 Re: Optimal configuration for server Ranier Vilela
• 2022/03/07 Re: Optimal configuration for server Luiz Felipph
• 2022/03/07 Re: Optimal configuration for server Tomas Vondra
• 2022/03/07 Re: Optimal configuration for server Ranier Vilela
• 2022/03/07 Re: Optimal configuration for server Luiz Felipph
• 2022/03/07 Re: Optimal configuration for server Ranier Vilela
• 2022/03/07 Optimal configuration for server Luiz Felipph
• 2022/03/05 Re: OOM killer while pg_restore Ranier Vilela
• 2022/03/05 Re: OOM killer while pg_restore Marc Rechté
• 2022/03/04 Re: Any way to speed up INSERT INTO aditya desai
• 2022/03/04 Re: XA transactions much slower on 14.2 than on 13.5 Tom Lane
• 2022/03/04 XA transactions much slower on 14.2 than on 13.5 Mladen Gogala
• 2022/03/04 Re: Any way to speed up INSERT INTO Imre Samu
• 2022/03/04 RES: Any way to speed up INSERT INTO Edson Richter
• 2022/03/04 Re: Any way to speed up INSERT INTO Andres Freund
• 2022/03/04 Re: Any way to speed up INSERT INTO Bruce Momjian
• 2022/03/04 Re: Any way to speed up INSERT INTO aditya desai
• 2022/03/04 Re: Any way to speed up INSERT INTO Tom Lane
• 2022/03/04 Re: Any way to speed up INSERT INTO Bruce Momjian
• 2022/03/04 Any way to speed up INSERT INTO aditya desai
• 2022/03/03 Re: OOM killer while pg_restore Tom Lane
• 2022/03/03 Re: OOM killer while pg_restore Marc Rechté
• 2022/03/03 Re: An I/O error occurred while sending to the backend (PG 13.4) Ranier Vilela
• 2022/03/03 RE: An I/O error occurred while sending to the backend (PG 13.4) l...@laurent-hasson.com
• 2022/03/03 Re: An I/O error occurred while sending to the backend (PG 13.4) Ranier Vilela
• 2022/03/03 Re: An I/O error occurred while sending to the backend (PG 13.4) Justin Pryzby
• 2022/03/03 Re: An I/O error occurred while sending to the backend (PG 13.4) Ranier Vilela
• 2022/03/03 Re: OOM killer while pg_restore Tom Lane
• 2022/03/03 RE: An I/O error occurred while sending to the backend (PG 13.4) l...@laurent-hasson.com
• 2022/03/03 Re: OOM killer while pg_restore Justin Pryzby
• 2022/03/03 Re: OOM killer while pg_restore Ranier Vilela
• 2022/03/03 Re: OOM killer while pg_restore Marc Rechté
• 2022/03/03 Re: OOM killer while pg_restore Ranier Vilela
• 2022/03/03 OOM killer while pg_restore Marc Rechté
• 2022/03/02 Re: Simple task with partitioning which I can't realize Mladen Gogala
• 2022/03/02 Re: Simple task with partitioning which I can't realize Geri Wright
• 2022/03/01 RE: Simple task with partitioning which I can't realize Michel SALAIS
• 2022/03/01 Re: Advice needed: query performance deteriorates by 2000% within 1 minute Michael Lewis
• 2022/03/01 Re: Advice needed: query performance deteriorates by 2000% within 1 minute Michael Lewis
• 2022/03/01 Re: An I/O error occurred while sending to the backend (PG 13.4) Ranier Vilela
• 2022/03/01 Re: An I/O error occurred while sending to the backend (PG 13.4) Justin Pryzby
• 2022/03/01 RE: Simple task with partitioning which I can't realize Andrew Zakharov
• 2022/03/01 Re: Simple task with partitioning which I can't realize Marc Millas
• 2022/03/01 RE: Simple task with partitioning which I can't realize Andrew Zakharov
• 2022/03/01 Re: Simple task with partitioning which I can't realize David G. Johnston
• 2022/03/01 RE: Simple task with partitioning which I can't realize Andrew Zakharov
• 2022/03/01 Re: Simple task with partitioning which I can't realize Marc Millas
• 2022/03/01 RE: An I/O error occurred while sending to the backend (PG 13.4) l...@laurent-hasson.com
• 2022/03/01 Re: Simple task with partitioning which I can't realize David G. Johnston
• 2022/03/01 Re: Never Ending query in PostgreSQL Tomas Vondra
• 2022/03/01 Simple task with partitioning which I can't realize Andrew Zakharov
• 2022/03/01 RE: Never Ending query in PostgreSQL Kumar, Mukesh
• 2022/03/01 Re: Never Ending query in PostgreSQL Tomas Vondra
• 2022/03/01 RLS not using index scan but seq scan when condition gets a bit complicated Charles Huang
• 2022/02/28 Re: Advice needed: query performance deteriorates by 2000% within 1 minute Peter Adlersburg
• 2022/02/28 Re: Never Ending query in PostgreSQL Mladen Gogala
• 2022/02/28 Re: Never Ending query in PostgreSQL Mladen Gogala
• 2022/02/28 Re: An I/O error occurred while sending to the backend (PG 13.4) Justin Pryzby
• 2022/02/28 RE: An I/O error occurred while sending to the backend (PG 13.4) l...@laurent-hasson.com
• 2022/02/28 RE: An I/O error occurred while sending to the backend (PG 13.4) l...@laurent-hasson.com
• 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) l...@laurent-hasson.com
• 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) l...@laurent-hasson.com
• 2021/12/04 Re: An I/O error occurred while sending to the backend (PG 13.4) Justin Pryzby

• Earlier messages
• Later messages