pgsql-performance  

Messages by Thread

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

• Earlier messages
• Later messages