pgsql-performance

Messages by Date

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
2023/09/11 Re: Planning time is time-consuming David Rowley
2023/09/11 Re: Planning time is time-consuming David Rowley
2023/09/11 Re: Fwd: Planning time is time-consuming Laurenz Albe
2023/09/11 Fwd: Planning time is time-consuming Mikhail Balayan
2023/09/11 Fwd: Planning time is time-consuming Mikhail Balayan
2023/09/10 Re: Planning time is time-consuming Andreas Kretschmer
2023/09/10 Re: Planning time is time-consuming Anupam b
2023/09/10 Re: Planning time is time-consuming Laurenz Albe
2023/09/10 Planning time is time-consuming Mikhail Balayan
2023/09/05 Re: Index bloat and REINDEX/VACUUM optimization for partial index jayaprabhakar k
2023/09/05 query pg_stat_ssl hang 100%cpu James Pang (chaolpan)
2023/09/05 query pg_stat_ssl hang 100%cpu James Pang (chaolpan)
2023/09/01 Re: Index bloat and REINDEX/VACUUM optimization for partial index Maxim Boguk
2023/09/01 Re: Queries containing ORDER BY and LIMIT started to work slowly Rondat Flyag
2023/09/01 Re: Queries containing ORDER BY and LIMIT started to work slowly Rondat Flyag
2023/08/31 Re: Index bloat and REINDEX/VACUUM optimization for partial index Jeff Janes
2023/08/31 Re: Index bloat and REINDEX/VACUUM optimization for partial index Jeff Janes
2023/08/31 Re: Index bloat and REINDEX/VACUUM optimization for partial index jayaprabhakar k
2023/08/31 Re: Queries containing ORDER BY and LIMIT started to work slowly Jeff Janes
2023/08/31 Re: Index bloat and REINDEX/VACUUM optimization for partial index Maxim Boguk
2023/08/31 Join order optimization Christian Beikov
2023/08/30 Re: Index bloat and REINDEX/VACUUM optimization for partial index jayaprabhakar k
2023/08/30 Re: Queries containing ORDER BY and LIMIT started to work slowly David Rowley
2023/08/30 Re: Queries containing ORDER BY and LIMIT started to work slowly Rondat Flyag
2023/08/30 Re: Queries containing ORDER BY and LIMIT started to work slowly Rondat Flyag
2023/08/29 Re: Queries containing ORDER BY and LIMIT started to work slowly Rick Otten
2023/08/29 Re: Queries containing ORDER BY and LIMIT started to work slowly Jeff Janes
2023/08/29 Re: Index bloat and REINDEX/VACUUM optimization for partial index Jeff Janes
2023/08/29 Re: Queries containing ORDER BY and LIMIT started to work slowly Rondat Flyag
2023/08/29 Re: Queries containing ORDER BY and LIMIT started to work slowly Jeff Janes
2023/08/29 Queries containing ORDER BY and LIMIT started to work slowly Rondat Flyag
2023/08/29 Re: Index bloat and REINDEX/VACUUM optimization for partial index jayaprabhakar k
2023/08/29 Re: Range partitioning query performance with date_trunc (vs timescaledb) David Rowley
2023/08/29 Range partitioning query performance with date_trunc (vs timescaledb) Philippe Pepiot
2023/08/28 Re: Index bloat and REINDEX/VACUUM optimization for partial index Peter Geoghegan
2023/08/28 Index bloat and REINDEX/VACUUM optimization for partial index jayaprabhakar k
2023/08/28 Re: Slow query, possibly not using index Les
2023/08/28 Re: Slow query, possibly not using index David Rowley
2023/08/28 Re: Slow query, possibly not using index Pavel Stehule
2023/08/28 Re: Slow query, possibly not using index Les
2023/08/28 Re: Slow query, possibly not using index Les
2023/08/27 Re: Slow query, possibly not using index Les
2023/08/27 Re: Slow query, possibly not using index Tom Lane
2023/08/27 Re: Slow query, possibly not using index Wael Khobalatte
2023/08/27 Re: Slow query, possibly not using index Les
2023/08/27 Re: Slow query, possibly not using index Tom Lane
2023/08/27 Slow query, possibly not using index Les
2023/08/23 Question regarding writes when locking rows Martin Querleu
2023/08/16 Re: slow delete Jeff Janes
2023/08/15 Re: slow delete Les
2023/08/15 Re: slow delete Tom Lane
2023/08/15 slow delete Les
2023/08/11 Re: Partitioning update-heavy queue with hash partitions vs partial indexes Dorian Hoxha
2023/08/10 Re: Partitioning update-heavy queue with hash partitions vs partial indexes burcinyazici
2023/08/10 Re: Partitioning update-heavy queue with hash partitions vs partial indexes David Rowley
2023/08/10 Partitioning update-heavy queue with hash partitions vs partial indexes Dorian Hoxha
2023/08/09 Re: Function call very slow from JDBC/java but super fast from DBear David G. Johnston
2023/08/09 Re: Function call very slow from JDBC/java but super fast from DBear An, Hongguo (CORP)
2023/08/09 Re: Function call very slow from JDBC/java but super fast from DBear Dave Cramer
2023/08/08 Function call very slow from JDBC/java but super fast from DBear An, Hongguo (CORP)
2023/08/04 Re: Plan weirdness. A sort produces more rows than the node beneath it Dane Foster
2023/08/04 Re: Plan weirdness. A sort produces more rows than the node beneath it Tom Lane
2023/08/04 Re: Plan weirdness. A sort produces more rows than the node beneath it Dane Foster
2023/08/04 Re: Plan weirdness. A sort produces more rows than the node beneath it Tom Lane
2023/08/04 Re: Plan weirdness. A sort produces more rows than the node beneath it Dane Foster
2023/08/04 Re: Plan weirdness. A sort produces more rows than the node beneath it Jeff Janes
2023/08/04 Plan weirdness. A sort produces more rows than the node beneath it Dane Foster
2023/07/30 Re: Table copy with SERIALIZABLE is incredibly slow Laurenz Albe
2023/07/30 Table copy with SERIALIZABLE is incredibly slow peter plachta
2023/07/30 Results of experiments with UUIDv7, UUIDv8 peter plachta
2023/07/26 Re: TOAST Fields serialisation/deserialization performance Piyush Katariya
2023/07/26 Re: TOAST Fields serialisation/deserialization performance Laurenz Albe
2023/07/26 TOAST Fields serialisation/deserialization performance Piyush Katariya
2023/07/17 Re: Performance implications of 8K pread()s Andres Freund
2023/07/17 Re: Performance implications of 8K pread()s Dimitrios Apostolou
2023/07/16 Re: Performance implications of 8K pread()s Thomas Munro
2023/07/12 Re: Performance implications of 8K pread()s Dimitrios Apostolou
2023/07/11 Re: Performance implications of 8K pread()s Thomas Munro
2023/07/11 Re: Performance implications of 8K pread()s Thomas Munro
2023/07/11 Entire index scanned, but only when in SQL function? Philip Semanchuk
2023/07/11 Performance implications of 8K pread()s Dimitrios Apostolou
2023/07/10 Re: Why is query performance on RLS enabled Postgres worse? Akash Anand
2023/07/09 Why is query performance on RLS enabled Postgres worse? Akash Anand
2023/06/24 Fwd: Helping planner to chose sequential scan when it improves performance Patrick O'Toole
2023/06/20 Re: Merge David and Goliath tables efficiently Tomas Vondra
2023/06/20 Re: Merge David and Goliath tables efficiently nicolas paris
2023/06/20 Re: Index on (fixed size) bytea value Les
2023/06/19 Re: Index on (fixed size) bytea value Laurenz Albe
2023/06/19 Re: Index on (fixed size) bytea value Les
2023/06/19 Re: Merge David and Goliath tables efficiently Tomas Vondra
2023/06/19 Re: Index on (fixed size) bytea value David G. Johnston
2023/06/19 Index on (fixed size) bytea value Les
2023/06/19 Re: Forced to use UNION ALL when having multiple ANY operators and ORDER BY LIMIT Benoit Tigeot
2023/06/19 Re: Merge David and Goliath tables efficiently nicolas paris
2023/06/19 Re: Merge David and Goliath tables efficiently Tomas Vondra
2023/06/19 Re: Merge David and Goliath tables efficiently nicolas paris
2023/06/19 Re: Merge David and Goliath tables efficiently nicolas paris
2023/06/19 Re: Merge David and Goliath tables efficiently Tomas Vondra
2023/06/19 Re: Merge David and Goliath tables efficiently Tomas Vondra
2023/06/19 Re: Merge David and Goliath tables efficiently Alvaro Herrera
2023/06/18 RE: Forced to use UNION ALL when having multiple ANY operators and ORDER BY LIMIT msalais
2023/06/18 Re: Merge David and Goliath tables efficiently nicolas paris
2023/06/17 Re: Merge David and Goliath tables efficiently Tomas Vondra
2023/06/17 Re: Merge David and Goliath tables efficiently nicolas paris
2023/06/17 Re: Merge David and Goliath tables efficiently Tomas Vondra
2023/06/17 Merge David and Goliath tables efficiently Nicolas Paris
2023/06/15 Re: Postgresql equal join on function with columns not use index Pavel Stehule
2023/06/15 RE: Postgresql equal join on function with columns not use index James Pang (chaolpan)
2023/06/13 Re: Postgresql equal join on function with columns not use index Pavel Stehule
2023/06/13 Re: Postgresql equal join on function with columns not use index Pavel Stehule
2023/06/13 Re: Postgresql equal join on function with columns not use index Tom Lane
2023/06/13 Re: extended statistics n-distinct on multiple columns not used when join two tables Pavel Stehule
2023/06/13 extended statistics n-distinct on multiple columns not used when join two tables James Pang (chaolpan)
2023/06/12 Re: Forced to use UNION ALL when having multiple ANY operators and ORDER BY LIMIT Chris Hoover
2023/06/12 RE: Forced to use UNION ALL when having multiple ANY operators and ORDER BY LIMIT benoit
2023/06/12 Re: Forced to use UNION ALL when having multiple ANY operators and ORDER BY LIMIT Chris Hoover
2023/06/12 RE: Forced to use UNION ALL when having multiple ANY operators and ORDER BY LIMIT benoit
2023/06/12 Re: Forced to use UNION ALL when having multiple ANY operators and ORDER BY LIMIT Peter Geoghegan
2023/06/12 Forced to use UNION ALL when having multiple ANY operators and ORDER BY LIMIT benoit
2023/06/12 RE: Postgresql equal join on function with columns not use index James Pang (chaolpan)
2023/06/12 Re: Postgresql equal join on function with columns not use index Tom Lane
2023/06/12 Postgresql equal join on function with columns not use index James Pang (chaolpan)
2023/06/10 Re: wrong rows estimation by hash join Tomas Vondra
2023/06/09 wrong rows estimation by hash join James Pang (chaolpan)
2023/06/05 Re: Weird behavior of INSERT QUERY Satalabaha Postgres
2023/06/04 Re: Weird behavior of INSERT QUERY Ranier Vilela
2023/06/04 Re: Weird behavior of INSERT QUERY Satalabaha Postgres
2023/06/04 Re: Weird behavior of INSERT QUERY Satalabaha Postgres
2023/06/04 Re: Weird behavior of INSERT QUERY Ranier Vilela
2023/06/04 Re: Weird behavior of INSERT QUERY Tom Lane
2023/06/04 Re: Weird behavior of INSERT QUERY Julien Rouhaud
2023/06/04 Re: Weird behavior of INSERT QUERY Satalabaha Postgres
2023/06/04 Re: Weird behavior of INSERT QUERY Julien Rouhaud
2023/06/04 Re: Weird behavior of INSERT QUERY Satalabaha Postgres
2023/06/04 Weird behavior of INSERT QUERY Satalabaha Postgres
2023/06/03 Re: Understand time taken by individual SQL statements in a procedure Satalabaha Postgres
2023/06/03 Re: Understand time taken by individual SQL statements in a procedure Julien Rouhaud
2023/06/03 Understand time taken by individual SQL statements in a procedure Satalabaha Postgres
2023/06/02 Re: thousands of CachedPlan entry per backend Jeff Janes
2023/06/02 RE: thousands of CachedPlan entry per backend James Pang (chaolpan)
2023/06/01 Re: thousands of CachedPlan entry per backend Pavel Stehule
2023/06/01 RE: thousands of CachedPlan entry per backend James Pang (chaolpan)
2023/06/01 Re: How to reduce latency with fast short queries in Postgresql 15.3 on a NUMA server Sergio Rus
2023/06/01 Re: thousands of CachedPlan entry per backend Laurenz Albe
2023/06/01 RE: thousands of CachedPlan entry per backend James Pang (chaolpan)
2023/06/01 Re: thousands of CachedPlan entry per backend Pavel Stehule
2023/05/31 Re: thousands of CachedPlan entry per backend Laurenz Albe
2023/05/31 Re: How to reduce latency with fast short queries in Postgresql 15.3 on a NUMA server Ranier Vilela