pgsql-performance

Messages by Date

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
2023/05/31 Re: How to reduce latency with fast short queries in Postgresql 15.3 on a NUMA server Andres Freund
2023/05/31 Re: How to reduce latency with fast short queries in Postgresql 15.3 on a NUMA server Imre Samu
2023/05/31 Re: How to reduce latency with fast short queries in Postgresql 15.3 on a NUMA server Sergio Rus
2023/05/31 Re: How to reduce latency with fast short queries in Postgresql 15.3 on a NUMA server Kenneth Marshall
2023/05/31 How to reduce latency with fast short queries in Postgresql 15.3 on a NUMA server Sergio Rus
2023/05/31 Re: Unaccounted regression from postgresql 11 in later versions Bob Jolliffe
2023/05/31 Re: Unaccounted regression from postgresql 11 in later versions Michael Christofides
2023/05/31 Unaccounted regression from postgresql 11 in later versions Bob Jolliffe
2023/05/30 Re: Fsync IO issue Merlin Moncure
2023/05/23 Re: PostgreSQL performance on ARM i.MX6 Ranier Vilela
2023/05/23 Re: PostgreSQL performance on ARM i.MX6 Richard Huxton
2023/05/23 Re: PostgreSQL performance on ARM i.MX6 Tom Lane
2023/05/23 Re: PostgreSQL performance on ARM i.MX6 Daniele Varrazzo
2023/05/23 PostgreSQL performance on ARM i.MX6 Druckenmueller, Marc
2023/05/11 Connection drops on postgres 11.16 aditya desai
2023/05/04 Re: Fsync IO issue Thomas Munro
2023/05/04 Re: Fsync IO issue ProfiVPS Support
2023/05/04 Re: Fsync IO issue Andres Freund
2023/05/04 Re: Fsync IO issue ProfiVPS Support
2023/05/04 Fsync IO issue ProfiVPS Support
2023/04/30 Re: Performance issues in query with multiple joins Laurenz Albe
2023/04/28 Re: Performance issues in query with multiple joins Tom Lane
2023/04/28 Performance issues in query with multiple joins David G. Johnston
2023/04/28 Performance issues in query with multiple joins Παρασκευη Πασσαρη
2023/04/24 Re: Postgres Metrics Jesper Pedersen
2023/04/23 Re: How do Monitoring tools capture explain plan of a query kunwar singh
2023/04/22 Re: How do Monitoring tools capture explain plan of a query kyle Hailey
2023/04/22 How do Monitoring tools capture explain plan of a query kunwar singh
2023/04/20 Re: speeding up grafana sensor-data query on raspberry pi 3 Clemens Eisserer
2023/04/20 Re: What is equivalent of v$sesstat and v$sql_plan in postgres? MichaelDBA
2023/04/20 What is equivalent of v$sesstat and v$sql_plan in postgres? kunwar singh
2023/04/18 Re: speeding up grafana sensor-data query on raspberry pi 3 Clemens Eisserer
2023/04/17 Re: High QPS, random index writes and vacuum Peter Geoghegan
2023/04/17 Re: High QPS, random index writes and vacuum Thomas Munro
2023/04/17 Re: High QPS, random index writes and vacuum peter plachta
2023/04/17 Re: High QPS, random index writes and vacuum peter plachta
2023/04/17 Re: High QPS, random index writes and vacuum David Rowley
2023/04/17 Re: High QPS, random index writes and vacuum Tom Lane
2023/04/17 Re: High QPS, random index writes and vacuum Peter Geoghegan
2023/04/17 High QPS, random index writes and vacuum peter plachta
2023/04/17 Re: time sorted UUIDs peter plachta
2023/04/17 Re: speeding up grafana sensor-data query on raspberry pi 3 Luiz Felipph
2023/04/16 Re: speeding up grafana sensor-data query on raspberry pi 3 Andres Freund
2023/04/16 Re: speeding up grafana sensor-data query on raspberry pi 3 David Rowley
2023/04/16 Re: speeding up grafana sensor-data query on raspberry pi 3 Justin Pryzby
2023/04/16 speeding up grafana sensor-data query on raspberry pi 3 Clemens Eisserer
2023/04/15 Re: Postgres Metrics Joe Conway
2023/04/15 Postgres Metrics André Rodrigues
2023/04/15 Re: Replication lag due to lagging restart_lsn milist ujang
2023/04/12 Re: Is there any tool which will help me run and explain analyze about 150 queries? Michael Christofides
2023/04/10 Re: Replication lag due to lagging restart_lsn milist ujang
2023/04/09 Re: Is there any tool which will help me run and explain analyze about 150 queries? kunwar singh