Messages by Date
-
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
-
2023/04/08
Re: Is there any tool which will help me run and explain analyze about 150 queries?
kyle Hailey
-
2023/04/08
RE: Query unable to utilize index without typecast to fixed length character
msalais
-
2023/04/07
Re: Is there any tool which will help me run and explain analyze about 150 queries?
Jerry Sievers
-
2023/04/07
Re: Is there any tool which will help me run and explain analyze about 150 queries?
kunwar singh
-
2023/04/07
Re: Is there any tool which will help me run and explain analyze about 150 queries?
kyle Hailey
-
2023/04/07
Re: Is there any tool which will help me run and explain analyze about 150 queries?
Achilleas Mantzios
-
2023/04/07
Is there any tool which will help me run and explain analyze about 150 queries?
kunwar singh
-
2023/04/07
Re: Query unable to utilize index without typecast to fixed length character
ahi
-
2023/04/06
Re: Query unable to utilize index without typecast to fixed length character
Tom Lane
-
2023/04/06
Query unable to utilize index without typecast to fixed length character
ahi
-
2023/04/04
Re: Why are commits consuming most of the database time?
Tim Slechta
-
2023/04/04
Re: Why are commits consuming most of the database time?
Tom Lane
-
2023/04/04
Why are commits consuming most of the database time?
Tim Slechta
-
2023/04/04
Re:Explain plan shows fewer shared blocks when index+table compared to index alone?
Sergei Kornilov
-
2023/04/03
Explain plan shows fewer shared blocks when index+table compared to index alone?
Amin Jaffer
-
2023/03/15
Re: multicolumn partitioning help
David Rowley
-
2023/03/15
Re: multicolumn partitioning help
David Rowley
-
2023/03/15
Re: multicolumn partitioning help
James Robertson
-
2023/03/15
Re: multicolumn partitioning help
Laurenz Albe
-
2023/03/14
Re: multicolumn partitioning help
Laurenz Albe
-
2023/03/14
Re: multicolumn partitioning help
Justin Pryzby
-
2023/03/14
multicolumn partitioning help
James Robertson
-
2023/03/13
Re: Huge Tables
André Rodrigues
-
2023/03/13
Re: Huge Tables
Rick Otten
-
2023/03/11
Re: Planner choosing nested loop in place of Hashjoin
Jeff Janes
-
2023/03/11
Huge Tables
André Rodrigues
-
2023/03/11
Re: INSERT statement going in IPC Wait_event
Samed YILDIRIM
-
2023/03/11
Re: Planner choosing nested loop in place of Hashjoin
Samed YILDIRIM
-
2023/03/07
Planner choosing nested loop in place of Hashjoin
Praneel Devisetty
-
2023/03/01
Re: INSERT statement going in IPC Wait_event
Andrew Dunstan
-
2023/03/01
INSERT statement going in IPC Wait_event
aditya desai
-
2023/02/25
Re: BRIN index worse than sequential scan for large search set
Tomas Vondra
-
2023/02/24
Re: BRIN index worse than sequential scan for large search set
Justin Pryzby
-
2023/02/24
Re: BRIN index worse than sequential scan for large search set
Mickael van der Beek
-
2023/02/24
Re: BRIN index worse than sequential scan for large search set
Justin Pryzby
-
2023/02/24
BRIN index worse than sequential scan for large search set
Mickael van der Beek
-
2023/02/20
Re: Window Functions & Table Partitions
David Rowley
-
2023/02/15
Re: Connection forcibly closed remote server error.
Ranier Vilela
-
2023/02/15
Re: Connection forcibly closed remote server error.
aditya desai
-
2023/02/15
Re: Connection forcibly closed remote server error.
Jeff Janes
-
2023/02/15
Re: Connection forcibly closed remote server error.
Tom Lane
-
2023/02/15
Re: Connection forcibly closed remote server error.
aditya desai
-
2023/02/15
Connection forcibly closed remote server error.
aditya desai
-
2023/02/13
Re: For loop execution times in PostgreSQL 12 vs 15
Pavel Stehule
-
2023/02/13
Re: Performance of UPDATE operation
Jeff Janes
-
2023/02/13
Re: For loop execution times in PostgreSQL 12 vs 15
Andres Freund
-
2023/02/13
Re: Performance of UPDATE operation
Oluwatobi Ogunsola