pgsql-performance

Messages by Date

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
2024/01/02 Questions about "Output" in EXPLAIN ANALYZE VERBOSE Jerry Brenner
2024/01/02 Re: Parallel hints in PostgreSQL with consistent perfromance mohini mane
2024/01/02 Re: Parallel hints in PostgreSQL with consistent perfromance David G. Johnston
2024/01/02 Re: Parallel hints in PostgreSQL with consistent perfromance mohini mane
2024/01/01 Re: Slow GroupAggregate and Sort Darwin Correa
2023/12/28 Re: Parallel hints in PostgreSQL with consistent perfromance Jeff Janes
2023/12/28 Re: Slow GroupAggregate and Sort Jeff Janes
2023/12/28 Slow GroupAggregate and Sort Darwin Correa
2023/12/28 Re: Parallel hints in PostgreSQL with consistent perfromance David G. Johnston
2023/12/28 Re: Parallel hints in PostgreSQL with consistent perfromance Matheus de Oliveira
2023/12/28 Re: Parallel hints in PostgreSQL with consistent perfromance mohini mane
2023/12/27 Re: [EXTERNAL] Need help with performance tuning pg12 on linux Matheus de Oliveira
2023/12/27 Re: [EXTERNAL] Need help with performance tuning pg12 on linux Matheus de Oliveira
2023/12/27 Re: [EXTERNAL] Need help with performance tuning pg12 on linux Wilson, Maria Louise (LARC-E301)[RSES]
2023/12/27 Re: [EXTERNAL] Need help with performance tuning pg12 on linux Ranier Vilela
2023/12/27 Re: [EXTERNAL] Need help with performance tuning pg12 on linux Wilson, Maria Louise (LARC-E301)[RSES]
2023/12/27 Re: [EXTERNAL] Need help with performance tuning pg12 on linux Matheus de Oliveira
2023/12/27 Re: Need help with performance tuning pg12 on linux Frits Hoogland
2023/12/27 Need help with performance tuning pg12 on linux Wilson, Maria Louise (LARC-E301)[RSES]
2023/12/27 Re: Parallel hints in PostgreSQL with consistent perfromance Jeff Janes
2023/12/27 Re: Parallel hints in PostgreSQL with consistent perfromance Tomas Vondra
2023/12/27 Parallel hints in PostgreSQL with consistent perfromance mohini mane
2023/12/20 Re: Which side of a Merge Join gets executed first? Do both sides always get executed? Frédéric Yhuel
2023/12/20 Re: Which side of a Merge Join gets executed first? Do both sides always get executed? Jerry Brenner
2023/12/20 Re: Which side of a Merge Join gets executed first? Do both sides always get executed? Frédéric Yhuel
2023/12/20 Re: Which side of a Merge Join gets executed first? Do both sides always get executed? Frédéric Yhuel
2023/12/20 Which side of a Merge Join gets executed first? Do both sides always get executed? Jerry Brenner
2023/12/15 Re: Planning time is time-consuming Michał Kłeczek
2023/12/15 Re: Planning time is time-consuming Merlin Moncure
2023/12/09 Re: 2 json explain plans for the same query/plan - why does one have constants while the other has parameter markers? Jerry Brenner
2023/12/08 Re: 2 json explain plans for the same query/plan - why does one have constants while the other has parameter markers? Jerry Brenner
2023/12/08 Re: Question about semantics of $ variables in json explain plans in 13 Tom Lane
2023/12/08 Re: 2 json explain plans for the same query/plan - why does one have constants while the other has parameter markers? Tom Lane
2023/12/08 2 json explain plans for the same query/plan - why does one have constants while the other has parameter markers? Jerry Brenner
2023/12/08 Question about semantics of $ variables in json explain plans in 13 Jerry Brenner
2023/12/05 Re: Include a timestamp in future versions of pg_stat_statements when when a query entered the cache? Julien Rouhaud
2023/12/05 Include a timestamp in future versions of pg_stat_statements when when a query entered the cache? Jerry Brenner
2023/12/05 Re: Does Postgres have consistent identifiers (plan hash value) for explain plans? Jerry Brenner
2023/12/04 Re: Does Postgres have consistent identifiers (plan hash value) for explain plans? Tom Lane
2023/12/04 Re: Does Postgres have consistent identifiers (plan hash value) for explain plans? Michael Paquier
2023/12/04 Re: Does Postgres have consistent identifiers (plan hash value) for explain plans? Julien Rouhaud
2023/12/04 Re: Does Postgres have consistent identifiers (plan hash value) for explain plans? Tom Lane
2023/12/04 Does Postgres have consistent identifiers (plan hash value) for explain plans? Jerry Brenner
2023/12/03 Re: Strange "actual time" in simple CTE Jeff Janes
2023/12/02 Strange "actual time" in simple CTE Jean-Christophe Boggio
2023/11/22 Re: Performance degradation with CTEs, switching from PG 11 to PG 15 Tom Lane
2023/11/22 Re: Performance degradation with CTEs, switching from PG 11 to PG 15 Jean-Christophe Boggio
2023/11/22 Re: Performance degradation with CTEs, switching from PG 11 to PG 15 Andreas Kretschmer
2023/11/22 Re: Performance degradation with CTEs, switching from PG 11 to PG 15 Jean-Christophe Boggio
2023/11/22 Re: Performance degradation with CTEs, switching from PG 11 to PG 15 John Naylor
2023/11/22 Performance degradation with CTEs, switching from PG 11 to PG 15 Jean-Christophe Boggio
2023/11/18 Re: simple query running long time within a long transaction. Frits Hoogland
2023/11/18 RE: simple query running long time within a long transaction. James Pang (chaolpan)
2023/11/17 Re: simple query running long time within a long transaction. Andreas Kretschmer
2023/11/17 simple query running long time within a long transaction. James Pang (chaolpan)
2023/11/09 Re: Awkward Join between generate_series and long table Lincoln Swaine-Moore
2023/11/09 RE: [EXTERNAL] Performance down with JDBC 42 Abraham, Danny
2023/11/09 Re: Awkward Join between generate_series and long table Philip Semanchuk
2023/11/08 Re: Awkward Join between generate_series and long table Lincoln Swaine-Moore
2023/11/08 Re: Awkward Join between generate_series and long table David G. Johnston
2023/11/08 Awkward Join between generate_series and long table Lincoln Swaine-Moore
2023/11/08 Re: Performance problems with Postgres JDBC 42.4.2 Dave Cramer
2023/11/06 Performance problems with Postgres JDBC 42.4.2 Jose Osinde
2023/11/06 Re: [EXTERNAL] Performance down with JDBC 42 Frits Hoogland
2023/11/05 Re: [EXTERNAL] Re: Performance down with JDBC 42 David Rowley
2023/11/05 RE: [EXTERNAL] Re: Performance down with JDBC 42 Abraham, Danny
2023/11/05 Re: [EXTERNAL] Re: Performance down with JDBC 42 Jeff Janes
2023/11/05 Re: [EXTERNAL] Re: Performance down with JDBC 42 Frits Hoogland
2023/11/05 Re: [EXTERNAL] Re: Performance down with JDBC 42 Andreas Kretschmer
2023/11/05 RE: [EXTERNAL] Re: Performance down with JDBC 42 Abraham, Danny
2023/11/04 Re: Performance down with JDBC 42 Laurenz Albe
2023/11/04 Performance down with JDBC 42 Abraham, Danny
2023/11/01 RE: Postgres Locking Smith, Travis
2023/10/31 Re: Postgres Locking Tom Lane
2023/10/31 Postgres Locking Dirschel, Steve
2023/10/31 Re: Postgres 15 SELECT query doesn't use index under RLS Alexander Okulovich
2023/10/26 Re: Postgres 15 SELECT query doesn't use index under RLS Tom Lane
2023/10/26 Re: Postgres 15 SELECT query doesn't use index under RLS Alexander Okulovich
2023/10/23 Re: GIN JSONB path index is not always used Jeff Janes
2023/10/23 Re: GIN JSONB path index is not always used Tomasz Szymański
2023/10/19 Re: Postgres 15 SELECT query doesn't use index under RLS Alexander Okulovich
2023/10/19 Re: Postgres 15 SELECT query doesn't use index under RLS Tomek
2023/10/18 Re: Postgres 15 SELECT query doesn't use index under RLS Tom Lane
2023/10/18 Re: Postgres 15 SELECT query doesn't use index under RLS Alexander Okulovich
2023/10/18 Re: Postgres 15 SELECT query doesn't use index under RLS Alexander Okulovich
2023/10/17 Re: GIN JSONB path index is not always used Jeff Janes
2023/10/17 Re: GIN JSONB path index is not always used Laurenz Albe
2023/10/17 GIN JSONB path index is not always used Tomasz Szymański
2023/10/16 Re: Underestimated number of output rows with an aggregate function Philippe BEAUDOIN
2023/10/15 Re: Underestimated number of output rows with an aggregate function Tom Lane
2023/10/15 Underestimated number of output rows with an aggregate function Philippe BEAUDOIN
2023/10/13 Re: Postgres 15 SELECT query doesn't use index under RLS Tom Lane
2023/10/13 Postgres 15 SELECT query doesn't use index under RLS Alexander Okulovich
2023/10/01 Re: Unexpected termination looping over table. Matt Gibbins
2023/10/01 Re: Unexpected termination looping over table. Tom Lane
2023/10/01 Unexpected termination looping over table. Matt Gibbins
2023/09/24 Re: Dirty reads on index scan, Jeff Janes
2023/09/22 Re: Dirty reads on index scan, Koen De Groote
2023/09/22 Re: Dirty reads on index scan, Frits Hoogland
2023/09/22 Re: Dirty reads on index scan, Laurenz Albe
2023/09/22 Re: Dirty reads on index scan, Koen De Groote
2023/09/21 Re: Dirty reads on index scan, Laurenz Albe
2023/09/21 Dirty reads on index scan, Koen De Groote
2023/09/15 Re: pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit Achilleas Mantzios
2023/09/15 Re: pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit Thomas Munro
2023/09/15 Re: pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit Achilleas Mantzios
2023/09/15 Re: pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit Tom Lane
2023/09/15 Re: pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit Achilleas Mantzios
2023/09/15 Re: pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit Tom Lane
2023/09/15 pgsql 10.23 , different systems, same table , same plan, different Buffers: shared hit Achilleas Mantzios - cloud
2023/09/15 Re: Multixact wraparound monitoring Alvaro Herrera
2023/09/14 Re: Multixact wraparound monitoring bruno da silva
2023/09/14 Re: Multixact wraparound monitoring Alvaro Herrera
2023/09/13 Re: Multixact wraparound monitoring Wyatt Alt
2023/09/13 Multixact wraparound monitoring bruno da silva
2023/09/11 Re: Planning time is time-consuming David Rowley
2023/09/11 Re: Planning time is time-consuming Imre Samu
2023/09/11 Re: Planning time is time-consuming Tom Lane
2023/09/11 Re: Planning time is time-consuming Frits Hoogland
2023/09/11 Re: Range partitioning query performance with date_trunc (vs timescaledb) Philippe Pepiot