pgsql-performance

Messages by Date

2020/08/20 Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Thomas Munro
2020/08/20 Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED David Rowley
2020/08/20 Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Michael Lewis
2020/08/20 Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Jim Jarvie
2020/08/20 Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Michael Lewis
2020/08/20 Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Jim Jarvie
2020/08/20 Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Michael Lewis
2020/08/20 Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Jim Jarvie
2020/08/19 Re: Replication lag due to lagging restart_lsn Kiran Singh
2020/08/19 Re: Replication lag due to lagging restart_lsn Kyotaro Horiguchi
2020/08/18 Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Laurenz Albe
2020/08/18 Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Michael Lewis
2020/08/18 Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Michael Lewis
2020/08/18 Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Henrique Montenegro
2020/08/18 Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Jim Jarvie
2020/08/18 Re: CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Michael Lewis
2020/08/18 CPU hogged by concurrent SELECT..FOR UPDATE SKIP LOCKED Jim Jarvie
2020/08/18 Replication lag due to lagging restart_lsn Satyam Shekhar
2020/08/14 Re: Query takes way longer with LIMIT, and EXPLAIN takes way longer than actual query Justin Pryzby
2020/08/14 Re: Query takes way longer with LIMIT, and EXPLAIN takes way longer than actual query Jeff Janes
2020/08/14 Re: Query takes way longer with LIMIT, and EXPLAIN takes way longer than actual query Ken Tanzer
2020/08/14 Re: Query takes way longer with LIMIT, and EXPLAIN takes way longer than actual query Justin Pryzby
2020/08/14 Query takes way longer with LIMIT, and EXPLAIN takes way longer than actual query Ken Tanzer
2020/08/11 Re: Hstore index for full text search Tom Lane
2020/08/11 Re: Is there a known bug with SKIP LOCKED and "tuple to be locked was already moved to another partition due to concurrent update"? Jim Jarvie
2020/08/11 Re: Hstore index for full text search Michael Lewis
2020/08/11 Re: Hstore index for full text search Tom Lane
2020/08/11 Re: Hstore index for full text search Michael Lewis
2020/08/11 Hstore index for full text search Burhan Akbulut
2020/07/29 Problems with Multixacts LWLocks Czarek
2020/07/29 Re: Too few rows expected by Planner on partitioned tables Julian Wolf
2020/07/22 Re: Too few rows expected by Planner on partitioned tables Julian Wolf
2020/07/22 Re: Too few rows expected by Planner on partitioned tables Justin Pryzby
2020/07/22 Re: Too few rows expected by Planner on partitioned tables Justin Pryzby
2020/07/21 Re: Too few rows expected by Planner on partitioned tables Justin Pryzby
2020/07/21 Too few rows expected by Planner on partitioned tables Julian Wolf
2020/07/17 Re: Same query taking less time in low configuration machine Vishwa Kalyankar
2020/07/16 Re: Same query taking less time in low configuration machine Justin Pryzby
2020/07/16 Re: Same query taking less time in low configuration machine Vishwa Kalyankar
2020/07/16 Re: Same query taking less time in low configuration machine Justin Pryzby
2020/07/15 Re: Sudden insert performance degradation Justin Pryzby
2020/07/15 Re: Sudden insert performance degradation Henrique Montenegro
2020/07/15 Re: Sudden insert performance degradation Henrique Montenegro
2020/07/15 Re: Sudden insert performance degradation Sebastian Dressler
2020/07/14 Re: Sudden insert performance degradation Henrique Montenegro
2020/07/13 Re: Sudden insert performance degradation Henrique Montenegro
2020/07/13 Re: Sudden insert performance degradation Jeff Janes
2020/07/13 Re: Sudden insert performance degradation Henrique Montenegro
2020/07/13 Re: Sudden insert performance degradation Michael Lewis
2020/07/13 Re: Sudden insert performance degradation Sebastian Dressler
2020/07/13 Re: Sudden insert performance degradation Henrique Montenegro
2020/07/13 Re: Sudden insert performance degradation Henrique Montenegro
2020/07/13 Re: Sudden insert performance degradation Sebastian Dressler
2020/07/13 Sudden insert performance degradation Henrique Montenegro
2020/07/11 Re: Request to help on Query improvement suggestion. Marlene Villanueva
2020/07/01 Re: Recommended value for pg_test_fsync Bruce Momjian
2020/07/01 Re: Recommended value for pg_test_fsync Nikhil Shetty
2020/07/01 Re: Recommended value for pg_test_fsync Nikhil Shetty
2020/07/01 Re: Recommended value for pg_test_fsync Haroldo Kerry
2020/07/01 Re: Recommended value for pg_test_fsync Nikhil Shetty
2020/07/01 Re: Recommended value for pg_test_fsync Nikhil Shetty
2020/07/01 Re: Recommended value for pg_test_fsync Nikhil Shetty
2020/06/30 Is there a known bug with SKIP LOCKED and "tuple to be locked was already moved to another partition due to concurrent update"? Gunther Schadow
2020/06/30 Re: Recommended value for pg_test_fsync Jeff Janes
2020/06/30 Re: Recommended value for pg_test_fsync Jeff Janes
2020/06/30 Re: Recommended value for pg_test_fsync Bruce Momjian
2020/06/29 Re: Recommended value for pg_test_fsync Nikhil Shetty
2020/06/29 Re: Recommended value for pg_test_fsync Bruce Momjian
2020/06/29 Recommended value for pg_test_fsync Nikhil Shetty
2020/06/22 Re: PostgreSQL 12.3 slow index scan chosen Tom Lane
2020/06/22 Re: PostgreSQL 12.3 slow index scan chosen Kenneth Marshall
2020/06/22 Re: PostgreSQL 12.3 slow index scan chosen Alvaro Herrera
2020/06/20 Re: PostgreSQL 12.3 slow index scan chosen Kenneth Marshall
2020/06/20 Re: PostgreSQL 12.3 slow index scan chosen Tom Lane
2020/06/19 Re: PostgreSQL 12.3 slow index scan chosen Tom Lane
2020/06/19 Re: PostgreSQL 12.3 slow index scan chosen Kenneth Marshall
2020/06/19 Re: PostgreSQL 12.3 slow index scan chosen Tom Lane
2020/06/19 Re: PostgreSQL 12.3 slow index scan chosen Kenneth Marshall
2020/06/19 Re: PostgreSQL 12.3 slow index scan chosen Tom Lane
2020/06/19 Re: PostgreSQL 12.3 slow index scan chosen Kenneth Marshall
2020/06/19 Re: PostgreSQL 12.3 slow index scan chosen Tom Lane
2020/06/19 Re: PostgreSQL 12.3 slow index scan chosen Kenneth Marshall
2020/06/19 Re: Unclamped row estimates whith OR-ed subplans Benjamin Coutu
2020/06/19 Re: PostgreSQL 12.3 slow index scan chosen Tom Lane
2020/06/19 PostgreSQL 12.3 slow index scan chosen Kenneth Marshall
2020/06/19 Re: Unclamped row estimates whith OR-ed subplans Michael Lewis
2020/06/19 Re: Unclamped row estimates whith OR-ed subplans Tom Lane
2020/06/19 Re: Unclamped row estimates whith OR-ed subplans Benjamin Coutu
2020/06/19 Re: Unclamped row estimates whith OR-ed subplans David G. Johnston
2020/06/19 Re: Unclamped row estimates whith OR-ed subplans Tom Lane
2020/06/19 Re: Unclamped row estimates whith OR-ed subplans Laurenz Albe
2020/06/19 Unclamped row estimates whith OR-ed subplans Benjamin Coutu
2020/06/17 Re: simple query running for ever Laurenz Albe
2020/06/16 Re: simple query running for ever Justin Pryzby
2020/06/16 Re: simple query running for ever Andreas Joseph Krogh
2020/06/16 Re: simple query running for ever Justin Pryzby
2020/06/16 Re: simple query running for ever Nagaraj Raj
2020/06/16 Re: simple query running for ever Nagaraj Raj
2020/06/16 Re: simple query running for ever Nagaraj Raj
2020/06/16 Re: simple query running for ever Justin Pryzby
2020/06/16 Re: simple query running for ever Michael Lewis
2020/06/16 simple query running for ever Nagaraj Raj
2020/06/16 Re: view reading information_schema is slow in PostgreSQL 12 regrog
2020/06/15 Re: view reading information_schema is slow in PostgreSQL 12 Michael Lewis
2020/06/14 Re: Performance issue Justin Pryzby
2020/06/14 Re: Performance issue David Rowley
2020/06/14 Performance issue Nagaraj Raj
2020/06/13 Re: view reading information_schema is slow in PostgreSQL 12 Tom Lane
2020/06/13 Re: view reading information_schema is slow in PostgreSQL 12 David Rowley
2020/06/13 Re: view reading information_schema is slow in PostgreSQL 12 David Rowley
2020/06/12 Re: view reading information_schema is slow in PostgreSQL 12 Pavel Stehule
2020/06/12 Re: view reading information_schema is slow in PostgreSQL 12 Pavel Stehule
2020/06/12 Re: view reading information_schema is slow in PostgreSQL 12 Pavel Stehule
2020/06/12 Re: view reading information_schema is slow in PostgreSQL 12 Justin Pryzby
2020/06/12 Re: view reading information_schema is slow in PostgreSQL 12 Tom Lane
2020/06/12 Re: view reading information_schema is slow in PostgreSQL 12 David Rowley
2020/06/12 Re: view reading information_schema is slow in PostgreSQL 12 David Rowley
2020/06/12 Re: view reading information_schema is slow in PostgreSQL 12 Tom Lane
2020/06/12 Re: view reading information_schema is slow in PostgreSQL 12 Imre Samu
2020/06/12 view reading information_schema is slow in PostgreSQL 12 regrog
2020/06/10 Re: Windows slowness? Mikkel Lauritsen
2020/06/10 Re: Windows slowness? David Rowley
2020/06/10 Re: Windows slowness? mountain the blue
2020/06/10 Windows slowness? Mikkel Lauritsen
2020/06/09 Re: Postgresql server gets stuck at low load Justin Pryzby
2020/06/09 Re: Postgresql server gets stuck at low load Krzysztof Olszewski
2020/06/09 Re: Postgresql server gets stuck at low load Avinash Kumar
2020/06/09 Re: Postgresql server gets stuck at low load Krzysztof Olszewski
2020/06/09 Re: Postgresql server gets stuck at low load Krzysztof Olszewski
2020/06/08 Re: When to use PARTITION BY HASH? michael...@sqlexec.com
2020/06/07 Re: When to use PARTITION BY HASH? David Rowley
2020/06/07 Re: When to use PARTITION BY HASH? MichaelDBA
2020/06/05 Re: Date vs Timestamp without timezone Partition Key Cedric Leong
2020/06/05 Re: Date vs Timestamp without timezone Partition Key David Rowley
2020/06/05 Re: Date vs Timestamp without timezone Partition Key Cedric Leong
2020/06/05 Re: Date vs Timestamp without timezone Partition Key David Rowley
2020/06/05 Re: Date vs Timestamp without timezone Partition Key Cedric Leong
2020/06/05 Re: When to use PARTITION BY HASH? Imre Samu
2020/06/05 Re: Postgresql server gets stuck at low load Pavel Stehule
2020/06/05 Re: Postgresql server gets stuck at low load luis . roberto
2020/06/05 Postgresql server gets stuck at low load Krzysztof Olszewski
2020/06/04 Re: increased max_parallel_workers_per_gather results in fewer workers? Philip Semanchuk
2020/06/04 Re: increased max_parallel_workers_per_gather results in fewer workers? Sebastian Dressler
2020/06/04 Re: increased max_parallel_workers_per_gather results in fewer workers? Philip Semanchuk
2020/06/04 Re: increased max_parallel_workers_per_gather results in fewer workers? Sebastian Dressler
2020/06/04 Re: increased max_parallel_workers_per_gather results in fewer workers? Philip Semanchuk
2020/06/04 Re: increased max_parallel_workers_per_gather results in fewer workers? Magnus Hagander
2020/06/04 Re: increased max_parallel_workers_per_gather results in fewer workers? Tomas Vondra
2020/06/03 Re: increased max_parallel_workers_per_gather results in fewer workers? Luis Carril
2020/06/03 Re: increased max_parallel_workers_per_gather results in fewer workers? Sebastian Dressler
2020/06/03 Re: increased max_parallel_workers_per_gather results in fewer workers? Justin Pryzby
2020/06/03 Re: increased max_parallel_workers_per_gather results in fewer workers? Philip Semanchuk
2020/06/03 Re: increased max_parallel_workers_per_gather results in fewer workers? Justin Pryzby
2020/06/03 increased max_parallel_workers_per_gather results in fewer workers? Philip Semanchuk
2020/06/03 Re: When to use PARTITION BY HASH? Justin Pryzby
2020/06/03 Re: When to use PARTITION BY HASH? Oleksandr Shulgin
2020/06/02 Re: When to use PARTITION BY HASH? Michel Pelletier
2020/06/02 Re: When to use PARTITION BY HASH? David G. Johnston
2020/06/02 Re: When to use PARTITION BY HASH? MichaelDBA
2020/06/02 Re: When to use PARTITION BY HASH? Justin Pryzby
2020/06/02 When to use PARTITION BY HASH? Oleksandr Shulgin
2020/06/01 Re: Configuration Filip Rembiałkowski
2020/06/01 Configuration sugnathi hai
2020/05/30 Re: Performance tunning Jeff Janes
2020/05/30 Re: Performance tunning Justin Pryzby
2020/05/30 Re: Performance tunning Pavel Stehule
2020/05/30 Performance tunning sugnathi hai
2020/05/28 Re: PostgreSQL performance problem moving from 9.6.17 to 12.3 Tom Lane
2020/05/28 PostgreSQL performance problem moving from 9.6.17 to 12.3 Kenneth Marshall
2020/05/24 Re: Request to help on Query improvement suggestion. Laurenz Albe
2020/05/24 Re: Date vs Timestamp without timezone Partition Key Tom Lane
2020/05/24 Date vs Timestamp without timezone Partition Key Cedric Leong
2020/05/22 Strategy for materialisation and centralisation of data Rory Campbell-Lange
2020/05/22 Re: Request to help on GIS Query improvement suggestion. Michael Lewis
2020/05/22 Request to help on Query improvement suggestion. devchef2020 d
2020/05/22 Request to help on GIS Query improvement suggestion. postggen2020 s
2020/05/22 Re: Suggestion to improve query performance for GIS query. postgann2020 s
2020/05/22 Re: Suggestion to improve query performance for GIS query. Mohammed Afsar
2020/05/22 Re: Suggestion to improve query performance for GIS query. David G. Johnston
2020/05/22 Suggestion to improve query performance for GIS query. postgann2020 s
2020/05/21 Suggestion to improve query performance of data validation in proc. postgann2020 s
2020/05/21 Re: Suggestion on index creation for TEXT data field postgann2020 s
2020/05/21 Re: Suggestion on index creation for TEXT data field David G. Johnston
2020/05/21 Re: Suggestion on table analyze postgann2020 s
2020/05/21 Re: Suggestion on index creation for TEXT data field Adrian Klaver
2020/05/21 Re: Suggestion on index creation for TEXT data field postgann2020 s
2020/05/21 Re: Suggestion on table analyze Adrian Klaver
2020/05/21 Re: Suggestion on index creation for TEXT data field David G. Johnston
2020/05/21 Suggestion on index creation for TEXT data field postgann2020 s
2020/05/21 Suggestion on table analyze postgann2020 s
2020/05/20 Suggestion to improve query performance. postgann2020 s
2020/05/20 Re: OOM Killer kills PostgreSQL Stephen Frost
2020/05/20 Re: OOM Killer kills PostgreSQL Justin Pryzby
2020/05/20 Re: OOM Killer kills PostgreSQL Fabio Pardi
2020/05/20 Re: OOM Killer kills PostgreSQL Piotr Włodarczyk
2020/05/20 Re: OOM Killer kills PostgreSQL Laurenz Albe
2020/05/20 OOM Killer kills PostgreSQL Piotr Włodarczyk
2020/05/18 Re: Execution time from >1s -> 80m+ when extra columns added in SELECT for sub-query Tom Lane
2020/05/18 Re: Execution time from >1s -> 80m+ when extra columns added in SELECT for sub-query A Guy Named Ryan
2020/05/18 Re: Execution time from >1s -> 80m+ when extra columns added in SELECT for sub-query Pavel Stehule

Later messages