pgsql-performance  

Messages by Date

• 2024/11/08 Re: Major performance degradation with joins in 15.8 or 15.7? Andrei Lepikhov
• 2024/11/08 tds_fdw : Severe performance degradation from postgresql 10.23 to 16.4 Achilleas Mantzios
• 2024/11/08 Re: Major performance degradation with joins in 15.8 or 15.7? Ed Sabol
• 2024/11/07 Re: Major performance degradation with joins in 15.8 or 15.7? Ed Sabol
• 2024/11/07 Re: Major performance degradation with joins in 15.8 or 15.7? Andrei Lepikhov
• 2024/11/07 Re: Major performance degradation with joins in 15.8 or 15.7? Andrei Lepikhov
• 2024/11/07 Re: Major performance degradation with joins in 15.8 or 15.7? Ed Sabol
• 2024/11/07 Re: Major performance degradation with joins in 15.8 or 15.7? David Rowley
• 2024/11/07 Major performance degradation with joins in 15.8 or 15.7? Ed Sabol
• 2024/11/05 Re: Bloom filters and the planner / parallel execution Rafia Sabih
• 2024/11/04 Re: Performance of Query 2 in TPC-H Andrei Lepikhov
• 2024/11/04 Re: Postgresql 14/15/16/17 partition pruning on dependent table during join Andrei Lepikhov
• 2024/11/04 Performance of Query 2 in TPC-H Ba Jinsheng
• 2024/11/04 Re: Postgresql 14/15/16/17 partition pruning on dependent table during join Stepan Yankevych
• 2024/11/02 Re: Postgresql 14/15/16/17 partition pruning on dependent table during join Andrei Lepikhov
• 2024/11/02 Re: Postgresql 14/15/16/17 partition pruning on dependent table during join Vijaykumar Jain
• 2024/11/01 Postgresql 14/15/16/17 partition pruning on dependent table during join Stepan Yankevych
• 2024/10/26 Re: Unexpected Performance for the Function simplify_function Ba Jinsheng
• 2024/10/25 Re: Unexpected Performance for the Function simplify_function Tom Lane
• 2024/10/25 Re: lwlock:LockManager wait_events SAMEER KUMAR
• 2024/10/25 Re: Unexpected Performance for the Function simplify_function Shiv Iyer
• 2024/10/25 Re: Unexpected Performance for the Function simplify_function David Rowley
• 2024/10/25 Re: Unexpected Performance for the Function simplify_function Andrei Lepikhov
• 2024/10/25 Re: Unexpected Performance for the Function simplify_function Ba Jinsheng
• 2024/10/25 Re: Unexpected Performance for the Function simplify_function Ba Jinsheng
• 2024/10/25 Re: lwlock:LockManager wait_events Sean Massey
• 2024/10/25 Unexpected Performance for the Function simplify_function Ba Jinsheng
• 2024/10/25 Re: proposal: schema variables James Pang
• 2024/10/25 Re: proposal: schema variables James Pang
• 2024/10/25 Re: lwlock:LockManager wait_events Laurenz Albe
• 2024/10/24 lwlock:LockManager wait_events James Pang
• 2024/10/24 Re: Unexpected Performance for the Function simplify_function David G. Johnston
• 2024/10/24 Re: Unexpected Performance for the Function simplify_function Andrei Lepikhov
• 2024/10/24 Re: Unexpected Performance for the Function simplify_function Tom Lane
• 2024/10/24 Re: Unexpected Performance for the Function simplify_function Tom Lane
• 2024/10/24 Re: Unexpected Performance for the Function simplify_function Greg Sabino Mullane
• 2024/10/24 Adding exclusion constraint in a big table Marcelo Fernandes
• 2024/10/09 Re: Performance degradation in Index searches with special characters Andrey Stikheev
• 2024/10/08 Bloom filters and the planner / parallel execution Daniel Westermann (DWE)
• 2024/10/07 Re: Performance degradation in Index searches with special characters Joe Conway
• 2024/10/06 Re: Performance degradation in Index searches with special characters Thomas Munro
• 2024/10/06 Re: Performance degradation in Index searches with special characters Shiv Iyer
• 2024/10/06 Re: Performance degradation in Index searches with special characters Tom Lane
• 2024/10/06 Re: Performance degradation in Index searches with special characters Joe Conway
• 2024/10/06 Re: Performance degradation in Index searches with special characters Andrey Stikheev
• 2024/10/06 Re: Performance degradation in Index searches with special characters Tom Lane
• 2024/10/06 Performance degradation in Index searches with special characters Andrey Stikheev
• 2024/09/11 Re: Partition pruning with array-contains check and current_setting function Marcelo Zabani
• 2024/09/11 Re: Has gen_random_uuid() gotten much slower in v17? David Mullineux
• 2024/09/11 Re: Has gen_random_uuid() gotten much slower in v17? Peter Eisentraut
• 2024/09/11 Re: many backends hang on MultiXactOffsetSLRU James Pang
• 2024/09/10 Re: many backends hang on MultiXactOffsetSLRU Alvaro Herrera
• 2024/09/10 Re: many backends hang on MultiXactOffsetSLRU Amine Tengilimoglu
• 2024/09/10 Re: many backends hang on MultiXactOffsetSLRU James Pang
• 2024/09/10 Re: many backends hang on MultiXactOffsetSLRU Alvaro Herrera
• 2024/09/10 Re: many backends hang on MultiXactOffsetSLRU Alvaro Herrera
• 2024/09/10 Re: many backends hang on MultiXactOffsetSLRU Amine Tengilimoglu
• 2024/09/10 many backends hang on MultiXactOffsetSLRU James Pang
• 2024/09/08 Re: Estimate of the inner_rows Tom Lane
• 2024/09/08 Re: Estimate of the inner_rows Tom Lane
• 2024/09/08 Estimate of the inner_rows 陈雁飞
• 2024/08/24 Re: checking for a NULL date in a partitioned table kills performance Rui DeSousa
• 2024/08/22 Re: checking for a NULL date in a partitioned table kills performance Tom Lane
• 2024/08/22 Re: checking for a NULL date in a partitioned table kills performance (accidentally sent to the admin list before) Vitalii Tymchyshyn
• 2024/08/22 checking for a NULL date in a partitioned table kills performance (accidentally sent to the admin list before) Sbob
• 2024/08/19 Re: Trying to understand why a query is filtering when there is a composite index Stephen Samuel (Sam)
• 2024/08/19 Re: Trying to understand why a query is filtering when there is a composite index Tom Lane
• 2024/08/19 Re: Trying to understand why a query is filtering when there is a composite index Stephen Samuel (Sam)
• 2024/08/19 Re: Trying to understand why a query is filtering when there is a composite index Peter Geoghegan
• 2024/08/19 Re: Trying to understand why a query is filtering when there is a composite index Shiv Iyer
• 2024/08/18 Re: Trying to understand why a query is filtering when there is a composite index Stephen Samuel (Sam)
• 2024/08/18 Re: Trying to understand why a query is filtering when there is a composite index Tom Lane
• 2024/08/18 Re: Trying to understand why a query is filtering when there is a composite index Peter Geoghegan
• 2024/08/18 Re: Trying to understand why a query is filtering when there is a composite index Tom Lane
• 2024/08/18 Re: Trying to understand why a query is filtering when there is a composite index Stephen Samuel (Sam)
• 2024/08/18 Re: Trying to understand why a query is filtering when there is a composite index Peter Geoghegan
• 2024/08/18 Re: Trying to understand why a query is filtering when there is a composite index Stephen Samuel (Sam)
• 2024/08/18 Re: Trying to understand why a query is filtering when there is a composite index Peter Geoghegan
• 2024/08/18 Trying to understand why a query is filtering when there is a composite index Stephen Samuel (Sam)
• 2024/08/07 Partition pruning with array-contains check and current_setting function Marcelo Zabani
• 2024/08/07 Re: Postgres index usage Greg Sabino Mullane
• 2024/08/07 Re: Postgres index usage Tom Lane
• 2024/08/07 RE: Postgres index usage Dirschel, Steve
• 2024/08/07 Postgres index usage Dirschel, Steve
• 2024/07/31 Re: logical replication out of memory khan Affan
• 2024/07/30 Re: logical replication out of memory James Pang
• 2024/07/30 Re: logical replication out of memory khan Affan
• 2024/07/30 Re: logical replication out of memory James Pang
• 2024/07/30 logical replication out of memory James Pang
• 2024/07/30 Re: Help with row estimate problem Jon Zeppieri
• 2024/07/30 Re: Help with row estimate problem Andrei Lepikhov
• 2024/07/29 Help with row estimate problem Jon Zeppieri
• 2024/07/26 Re: Outer cost higher than the inner cost Tom Lane
• 2024/07/26 Outer cost higher than the inner cost Stanisław Skonieczny
• 2024/07/11 Re: inequality predicate not pushed down in JOIN? Jerry Brenner
• 2024/07/11 Re: inequality predicate not pushed down in JOIN? Paul George
• 2024/07/11 Re: inequality predicate not pushed down in JOIN? Andrei Lepikhov
• 2024/07/11 inequality predicate not pushed down in JOIN? Paul George
• 2024/07/11 Re: How to solve my slow disk i/o throughput during index scan Andrei Lepikhov
• 2024/07/11 Re: How to solve my slow disk i/o throughput during index scan Andrei Lepikhov
• 2024/07/11 Re: How to solve my slow disk i/o throughput during index scan David G. Johnston
• 2024/07/11 RE: How to solve my slow disk i/o throughput during index scan FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT)
• 2024/07/11 RE: How to solve my slow disk i/o throughput during index scan FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT)
• 2024/07/10 Re: Specific objects backup in PostgreSQL nikhil kumar
• 2024/07/10 Re: Specific objects backup in PostgreSQL Anthony Sotolongo
• 2024/07/10 Re: Specific objects backup in PostgreSQL Olivier Gautherot
• 2024/07/10 Re: Specific objects backup in PostgreSQL David G. Johnston
• 2024/07/10 Specific objects backup in PostgreSQL nikhil kumar
• 2024/07/10 Re: Query performance issue Tom Lane
• 2024/07/10 Query performance issue Dheeraj Sonawane
• 2024/07/08 Re: Low performance between datacenters Andrei Lepikhov
• 2024/07/07 Re: Hash Right join and seq scan Justin Pryzby
• 2024/07/07 Re: Hash Right join and seq scan James Pang
• 2024/07/07 Re: Low performance between datacenters Vitalii Tymchyshyn
• 2024/07/07 Re: Low performance between datacenters Fernando Hevia
• 2024/07/07 Low performance between datacenters Tamás PAPP
• 2024/07/05 Re: Hash Right join and seq scan David Rowley
• 2024/07/05 Re: Hash Right join and seq scan James Pang
• 2024/07/04 Re: Hash Right join and seq scan David Rowley
• 2024/07/04 Re: How to solve my slow disk i/o throughput during index scan Andrei Lepikhov
• 2024/07/04 Re: Hash Right join and seq scan James Pang
• 2024/07/04 RE: How to solve my slow disk i/o throughput during index scan FREYBURGER Simon (SNCF VOYAGEURS / DIRECTION GENERALE TGV / DM RMP YIELD MANAGEMENT)
• 2024/07/04 Re: How to solve my slow disk i/o throughput during index scan Andrei Lepikhov
• 2024/07/03 Re: Hash Right join and seq scan Tomas Vondra
• 2024/07/02 Re: Hash Right join and seq scan James Pang
• 2024/07/02 Re: Hash Right join and seq scan James Pang
• 2024/07/02 Hash Right join and seq scan James Pang
• 2024/07/01 Re: a lot of shared buffers hit when planning for a simple query with primary access path Andrei Lepikhov
• 2024/07/01 Re: a lot of shared buffers hit when planning for a simple query with primary access path James Pang
• 2024/07/01 Re: a lot of shared buffers hit when planning for a simple query with primary access path David Rowley
• 2024/07/01 Re: a lot of shared buffers hit when planning for a simple query with primary access path Pavel Stehule
• 2024/07/01 Re: a lot of shared buffers hit when planning for a simple query with primary access path David Rowley
• 2024/07/01 a lot of shared buffers hit when planning for a simple query with primary access path James Pang
• 2024/06/27 Re: Inconsistent query performance based on relation hit frequency Achilleas Mantzios
• 2024/06/27 Re: Inconsistent query performance based on relation hit frequency Laura Hausmann
• 2024/06/27 Re: Inconsistent query performance based on relation hit frequency Achilleas Mantzios - cloud
• 2024/06/27 Re: Row level security Andrew Okhmat
• 2024/06/27 Re: Inconsistent query performance based on relation hit frequency Andrei Lepikhov
• 2024/06/27 Inconsistent query performance based on relation hit frequency Laura Hausmann
• 2024/06/24 Row level security Thomas Simpson
• 2024/06/18 Re: performance of sql and plpgsql functions Julius Tuskenis
• 2024/06/17 Re: performance of sql and plpgsql functions Tom Lane
• 2024/06/17 Re: performance of sql and plpgsql functions Pavel Stehule
• 2024/06/17 Re: performance of sql and plpgsql functions Julius Tuskenis
• 2024/06/17 Re: performance of sql and plpgsql functions Philip Semanchuk
• 2024/06/17 Re: performance of sql and plpgsql functions Julius Tuskenis
• 2024/06/17 Re: performance of sql and plpgsql functions Pavel Stehule
• 2024/06/17 performance of sql and plpgsql functions Julius Tuskenis
• 2024/06/14 Re: BDR that performs Bruce Momjian
• 2024/06/14 Re: BDR that performs P C
• 2024/06/14 Re: BDR that performs Hari Kiran
• 2024/06/14 Re: BDR that performs Bruce Momjian
• 2024/06/14 BDR that performs Smith, Travis
• 2024/06/12 Re: Need help on configuration SMTP nikhil kumar
• 2024/06/12 Re: Need help on configuration SMTP David G. Johnston
• 2024/06/12 Re: Distinct performance dropped by multiple times in v16 Andrei Lepikhov
• 2024/06/12 Re: Need help on configuration SMTP Muhammad Ikram
• 2024/06/12 Need help on configuration SMTP nikhil kumar
• 2024/06/11 RE: Postgresql initialize error Smith, Travis
• 2024/06/11 Re: Postgresql initialize error nikhil kumar
• 2024/06/11 Re: Postgresql initialize error nikhil kumar
• 2024/06/11 Re: Postgresql initialize error Muhammad Salahuddin Manzoor
• 2024/06/11 Re: Postgresql initialize error nikhil kumar
• 2024/06/11 Postgresql initialize error nikhil kumar
• 2024/06/11 Re: Distinct performance dropped by multiple times in v16 Andrei Lepikhov
• 2024/06/10 Re: Distinct performance dropped by multiple times in v16 Greg Sabino Mullane
• 2024/06/03 query column in pg_stat_statements and pg_stat_activity Satalabaha Postgres
• 2024/05/29 Re: Plan selection based on worst case scenario Chema
• 2024/05/29 Re: Plan selection based on worst case scenario David Rowley
• 2024/05/29 Plan selection based on worst case scenario Darwin O'Connor
• 2024/04/21 Re: Extremely slow to establish connection when user has a high number of roles Tom Lane
• 2024/04/21 Re: Extremely slow to establish connection when user has a high number of roles Michal Charemza
• 2024/04/20 Re: Extremely slow to establish connection when user has a high number of roles Tom Lane
• 2024/04/20 Re: Extremely slow to establish connection when user has a high number of roles Michal Charemza
• 2024/04/20 Re: Extremely slow to establish connection when user has a high number of roles Frits Hoogland
• 2024/04/20 Re: Extremely slow to establish connection when user has a high number of roles Michal Charemza
• 2024/04/20 Re: Extremely slow to establish connection when user has a high number of roles Michal Charemza
• 2024/04/20 Re: Extremely slow to establish connection when user has a high number of roles Vijaykumar Jain
• 2024/04/20 Re: Extremely slow to establish connection when user has a high number of roles Tom Lane
• 2024/04/20 Re: Extremely slow to establish connection when user has a high number of roles Tomas Vondra
• 2024/04/20 Extremely slow to establish connection when user has a high number of roles Michal Charemza
• 2024/04/12 Re: Performance implications of 8K pread()s Dimitrios Apostolou
• 2024/04/11 Re: Performance implications of 8K pread()s Thomas Munro
• 2024/04/09 Re: LWlock:LockManager waits Luiz Fernando G. Verona
• 2024/04/09 Re: LWlock:LockManager waits Frits Hoogland
• 2024/04/09 Re: LWlock:LockManager waits Frits Hoogland
• 2024/04/09 Re: LWlock:LockManager waits James Pang
• 2024/04/08 Re: LWlock:LockManager waits Laurenz Albe
• 2024/04/08 LWlock:LockManager waits James Pang
• 2024/03/19 Re: maintenance_work_mem impact? Laurenz Albe
• 2024/03/19 maintenance_work_mem impact? Adithya Kumaranchath
• 2024/03/14 Re: FW: huge SubtransSLRU and SubtransBuffer wait_event James Pang
• 2024/03/06 Re: Separate 100 M spatial data in 100 tables VS one big table kimaidou
• 2024/03/06 Re: Optimizing count(), but Explain estimates wildly off Chema
• 2024/03/05 Re: Separate 100 M spatial data in 100 tables VS one big table Tomas Vondra
• 2024/03/05 Re: Optimizing count(), but Explain estimates wildly off Greg Sabino Mullane
• 2024/03/05 Re: Optimizing count(), but Explain estimates wildly off Chema
• 2024/03/05 Re: Separate 100 M spatial data in 100 tables VS one big table Marc Millas
• 2024/03/04 Separate 100 M spatial data in 100 tables VS one big table kimaidou
• 2024/03/04 Re: Is partition pruning impacted by data type sud

• Earlier messages
• Later messages