pgsql-performance  

Messages by Date

• 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
• 2024/03/04 Re: Optimizing count(), but Explain estimates wildly off Greg Sabino Mullane
• 2024/03/04 Re: Optimizing count(), but Explain estimates wildly off Chema
• 2024/03/01 Re: Optimizing count(), but Explain estimates wildly off Laurenz Albe
• 2024/02/29 Re: FW: huge SubtransSLRU and SubtransBuffer wait_event Alvaro Herrera
• 2024/02/29 Re: FW: huge SubtransSLRU and SubtransBuffer wait_event James Pang
• 2024/02/29 Re: Optimizing count(), but Explain estimates wildly off Chema
• 2024/02/29 Re: Table Partitioning and Indexes Performance Questions Anupam b
• 2024/02/29 Re: Table Partitioning and Indexes Performance Questions Laurenz Albe
• 2024/02/29 Table Partitioning and Indexes Performance Questions David Kelly
• 2024/02/29 Re: generic plan generate poor performance Pavel Stehule
• 2024/02/29 generic plan generate poor performance James Pang
• 2024/02/28 Re: Fwd: extend statistics help reduce index scan a lot of shared buffer hits. Tomas Vondra
• 2024/02/27 Fwd: extend statistics help reduce index scan a lot of shared buffer hits. James Pang
• 2024/02/27 extend statistics help reduce index scan a lot of shared buffer hits. James Pang
• 2024/02/27 Re: Optimizing count(), but Explain estimates wildly off Alvaro Herrera
• 2024/02/26 Re: Optimizing count(), but Explain estimates wildly off Laurenz Albe
• 2024/02/26 Re: Optimizing count(), but Explain estimates wildly off Vitalii Tymchyshyn
• 2024/02/26 Optimizing count(), but Explain estimates wildly off Chema
• 2024/02/25 Re: FW: huge SubtransSLRU and SubtransBuffer wait_event James Pang
• 2024/02/23 Re: sql statement not using all primary key values and poor performance Laurenz Albe
• 2024/02/23 Re: sql statement not using all primary key values and poor performance James Pang
• 2024/02/23 Re: sql statement not using all primary key values and poor performance Laurenz Albe
• 2024/02/22 Re: sql statement not using all primary key values and poor performance James Pang
• 2024/02/22 sql statement not using all primary key values and poor performance James Pang
• 2024/02/20 Re: "not related" code blocks for removal of dead rows when using vacuum and this kills the performance Lars Aksel Opsahl
• 2024/02/19 Re: "not related" code blocks for removal of dead rows when using vacuum and this kills the performance Laurenz Albe
• 2024/02/19 Re: "not related" code blocks for removal of dead rows when using vacuum and this kills the performance Lars Aksel Opsahl
• 2024/02/19 Re: "not related" code blocks for removal of dead rows when using vacuum and this kills the performance Lars Aksel Opsahl
• 2024/02/19 Re: "not related" code blocks for removal of dead rows when using vacuum and this kills the performance Laurenz Albe
• 2024/02/19 "not related" code blocks for removal of dead rows when using vacuum and this kills the performance Lars Aksel Opsahl
• 2024/02/15 Re: PostgreSQL doesn't use index-only scan if there is an expression in index Laurenz Albe
• 2024/02/15 PostgreSQL doesn't use index-only scan if there is an expression in index Pavel Kulakov
• 2024/02/09 Re: Simple JOIN on heavy table not using expected index kimaidou
• 2024/02/09 Re: Simple JOIN on heavy table not using expected index Tom Lane
• 2024/02/09 Re: Simple JOIN on heavy table not using expected index kimaidou
• 2024/02/09 Re: Simple JOIN on heavy table not using expected index Burçin Yazıcı
• 2024/02/09 Simple JOIN on heavy table not using expected index kimaidou
• 2024/02/05 RE: huge SubtransSLRU and SubtransBuffer wait_event James Pang (chaolpan)
• 2024/02/02 Re: huge SubtransSLRU and SubtransBuffer wait_event Laurenz Albe
• 2024/02/02 Re: huge SubtransSLRU and SubtransBuffer wait_event Nikolay Samokhvalov
• 2024/02/02 Re: huge SubtransSLRU and SubtransBuffer wait_event Lars Aksel Opsahl
• 2024/02/02 Re: huge SubtransSLRU and SubtransBuffer wait_event Alvaro Herrera
• 2024/02/01 Re: Memory growth using many named prepared statements, in spite of using DISCARD ALL afterwards. Daniel Blanch Bataller
• 2024/02/01 RE: huge SubtransSLRU and SubtransBuffer wait_event James Pang (chaolpan)
• 2024/02/01 RE: huge SubtransSLRU and SubtransBuffer wait_event James Pang (chaolpan)
• 2024/02/01 Re: Memory growth using many named prepared statements, in spite of using DISCARD ALL afterwards. Heikki Linnakangas
• 2024/02/01 Memory growth using many named prepared statements, in spite of using DISCARD ALL afterwards. Daniel Blanch Bataller
• 2024/02/01 Re: huge SubtransSLRU and SubtransBuffer wait_event Laurenz Albe
• 2024/02/01 huge SubtransSLRU and SubtransBuffer wait_event James Pang (chaolpan)
• 2024/02/01 Re: Weird performance differences between cloud vendors Laurenz Albe
• 2024/02/01 Weird performance differences between cloud vendors Dirk Krautschick
• 2024/01/31 Re: Slow query in table where many rows were deleted. VACUUM FULL fixes it Divya Sharma
• 2024/01/31 Re: Performance Samed YILDIRIM
• 2024/01/31 Performance Mehmet COKCEVIK
• 2024/01/30 Re: Slow query in table where many rows were deleted. VACUUM FULL fixes it David Rowley
• 2024/01/30 Re: Slow query in table where many rows were deleted. VACUUM FULL fixes it Philip Semanchuk
• 2024/01/30 Re: Slow query in table where many rows were deleted. VACUUM FULL fixes it Laurenz Albe
• 2024/01/30 Slow query in table where many rows were deleted. VACUUM FULL fixes it Pavlos Kallis
• 2024/01/25 Re: I don't understand that EXPLAIN PLAN timings David Rowley
• 2024/01/25 Re: I don't understand that EXPLAIN PLAN timings Jean-Christophe Boggio
• 2024/01/25 Re: I don't understand that EXPLAIN PLAN timings Jean-Christophe Boggio
• 2024/01/25 Re: I don't understand that EXPLAIN PLAN timings Tom Lane
• 2024/01/25 Re: I don't understand that EXPLAIN PLAN timings David Rowley
• 2024/01/25 Re: I don't understand that EXPLAIN PLAN timings Jean-Christophe Boggio
• 2024/01/23 Re: I don't understand that EXPLAIN PLAN timings David Rowley
• 2024/01/22 Re: I don't understand that EXPLAIN PLAN timings Jean-Christophe Boggio
• 2024/01/18 I don't understand that EXPLAIN PLAN timings Jean-Christophe Boggio
• 2024/01/17 Re: Why is a sort required for this query? (IS NULL predicate on leading key column) Tom Lane
• 2024/01/17 Re: Why is a sort required for this query? (IS NULL predicate on leading key column) Jerry Brenner
• 2024/01/17 Why is a sort required for this query? (IS NULL predicate on leading key column) Jerry Brenner
• 2024/01/11 Re: Selection not "pushed down into" CTE Clemens Eisserer
• 2024/01/07 Re: Slow GroupAggregate and Sort Darwin Correa
• 2024/01/07 Re: Selection not "pushed down into" CTE Tom Lane
• 2024/01/06 Selection not "pushed down into" CTE Clemens Eisserer
• 2024/01/03 Re: Parallel hints in PostgreSQL with consistent perfromance mohini mane
• 2024/01/03 Re: Slow GroupAggregate and Sort Jeff Janes
• 2024/01/03 Re: Parallel hints in PostgreSQL with consistent perfromance Jeff Janes
• 2024/01/02 Re: Questions about "Output" in EXPLAIN ANALYZE VERBOSE Jerry Brenner
• 2024/01/02 Re: Questions about "Output" in EXPLAIN ANALYZE VERBOSE Tom Lane
• 2024/01/02 Re: Questions about "Output" in EXPLAIN ANALYZE VERBOSE Jeff Janes

• Earlier messages
• Later messages