pgsql-performance

Messages by Date

2022/05/26 Re: How to monitor Postgres real memory usage 徐志宇徐
2022/05/26 Re: How to monitor Postgres real memory usage 徐志宇徐
2022/05/24 Re: How to monitor Postgres real memory usage Justin Pryzby
2022/05/24 How to monitor Postgres real memory usage 徐志宇徐
2022/05/23 Re: Array of integer indexed nested-loop semi join Mickael van der Beek
2022/05/23 Re: Array of integer indexed nested-loop semi join Jeff Janes
2022/05/23 Re: Array of integer indexed nested-loop semi join Mickael van der Beek
2022/05/22 Re: Array of integer indexed nested-loop semi join Jeff Janes
2022/05/20 Re: Selecting RAM and CPU based on max_connections Ganesh Korde
2022/05/20 Re: Selecting RAM and CPU based on max_connections aditya desai
2022/05/20 Re: Array of integer indexed nested-loop semi join Mickael van der Beek
2022/05/20 Re: Need help on Query Tunning and Not using the Index Scan Laurenz Albe
2022/05/20 Re: Selecting RAM and CPU based on max_connections Laurenz Albe
2022/05/20 Re: Selecting RAM and CPU based on max_connections Andreas Kretschmer
2022/05/20 Selecting RAM and CPU based on max_connections aditya desai
2022/05/20 Need help on Query Tunning and Not using the Index Scan Kumar, Mukesh
2022/05/12 Re: DB connection issue suggestions Justin Pryzby
2022/05/11 Re: DB connection issue suggestions Sudhir Guna
2022/05/11 Re: DB connection issue suggestions Justin Pryzby
2022/05/11 Re: DB connection issue suggestions Ranier Vilela
2022/05/11 Re: DB connection issue suggestions Sudhir Guna
2022/05/11 Re: DB connection issue suggestions Sudhir Guna
2022/05/11 Re: DB connection issue suggestions Sudhir Guna
2022/05/11 Re: DB connection issue suggestions Sudhir Guna
2022/05/10 Re: DB connection issue suggestions Anbazhagan M
2022/05/10 Re: DB connection issue suggestions Laurenz Albe
2022/05/10 Re: DB connection issue suggestions Ranier Vilela
2022/05/10 Re: DB connection issue suggestions Justin Pryzby
2022/05/10 Re: DB connection issue suggestions MichaelDBA Vitale
2022/05/10 DB connection issue suggestions Sudhir Guna
2022/05/04 Re: Why is there a Sort after an Index Only Scan? Tom Lane
2022/05/04 RE: Why is there a Sort after an Index Only Scan? André Hänsel
2022/05/04 Re: Why is there a Sort after an Index Only Scan? David Rowley
2022/05/04 Re: Why is there a Sort after an Index Only Scan? Jeff Janes
2022/05/04 Why is there a Sort after an Index Only Scan? André Hänsel
2022/05/04 Re: Window partial fetch optimization Jeff Janes
2022/05/03 Re: Window partial fetch optimization David Rowley
2022/05/03 Window partial fetch optimization Levi Aul
2022/05/03 Re: Useless memoize path generated for unique join on primary keys David Rowley
2022/05/03 Re: Useless memoize path generated for unique join on primary keys Benjamin Coutu
2022/05/03 Re: Useless memoize path generated for unique join on primary keys David Rowley
2022/05/03 Useless memoize path generated for unique join on primary keys Benjamin Coutu
2022/04/29 FATAL: canceling authentication due to timeout aditya desai
2022/04/28 Re: LISTEN NOTIFY sometimes huge delay Tom Lane
2022/04/28 LISTEN NOTIFY sometimes huge delay Peter Eser HEUFT [Germany]
2022/04/28 Re: Performance differential when 0 values present vs when 1 values present. Planner return 52k rows when 0 expected. Emil Iggland
2022/04/27 Re: Unworkable plan above certain row count Tom Lane
2022/04/27 Unworkable plan above certain row count André Hänsel
2022/04/27 Re: Array of integer indexed nested-loop semi join Mickael van der Beek
2022/04/27 Re: Array of integer indexed nested-loop semi join Jeff Janes
2022/04/27 Fwd: Array of integer indexed nested-loop semi join Mickael van der Beek
2022/04/27 Re: Performance differential when 0 values present vs when 1 values present. Planner return 52k rows when 0 expected. David Rowley
2022/04/27 Re: Performance differential when 0 values present vs when 1 values present. Planner return 52k rows when 0 expected. Emil Iggland
2022/04/25 Re: Performance differential when 0 values present vs when 1 values present. Planner return 52k rows when 0 expected. Tom Lane
2022/04/25 Performance differential when 0 values present vs when 1 values present. Planner return 52k rows when 0 expected. Emil Iggland
2022/04/21 Re: Query Planner not taking advantage of HASH PARTITION Justin Pryzby
2022/04/21 Re: Query Planner not taking advantage of HASH PARTITION Benjamin Tingle
2022/04/20 Re: Postgresql TPS Bottleneck Benedict Holland
2022/04/20 Re: Postgresql TPS Bottleneck wakandavision
2022/04/20 Re: significant jump in sql statement timing for on server vs a remote connection Ranier Vilela
2022/04/20 Re: Postgresql TPS Bottleneck Jeff Janes
2022/04/20 Re: significant jump in sql statement timing for on server vs a remote connection Sbob
2022/04/20 Re: Postgresql TPS Bottleneck wakandavision
2022/04/19 Re: significant jump in sql statement timing for on server vs a remote connection Jeff Janes
2022/04/19 Re: significant jump in sql statement timing for on server vs a remote connection Justin Pryzby
2022/04/19 significant jump in sql statement timing for on server vs a remote connection Sbob
2022/04/19 How to find all SQLs executed by a transaction id? Patil, Ravi
2022/04/18 Re: How to find the final transformed query in postgresql Goti
2022/04/18 Re: How to find the final transformed query in postgresql Tom Lane
2022/04/18 How to find the final transformed query in postgresql Goti
2022/04/17 Re: Query Planner not taking advantage of HASH PARTITION Alvaro Herrera
2022/04/17 Re: Query Planner not taking advantage of HASH PARTITION Tom Lane
2022/04/17 Re: Query Planner not taking advantage of HASH PARTITION Benjamin Tingle
2022/04/17 Re: Query Tunning related to function David G. Johnston
2022/04/17 Re: Query Planner not taking advantage of HASH PARTITION Tom Lane
2022/04/17 RE: Query Tunning related to function Kumar, Mukesh
2022/04/17 RE: Query Tunning related to function Kumar, Mukesh
2022/04/17 Query Planner not taking advantage of HASH PARTITION Benjamin Tingle
2022/04/16 Re: Query Tunning related to function Justin Pryzby
2022/04/14 Re: Query Tunning related to function Bhupendra Babu
2022/04/14 Re: Performance for SQL queries on Azure PostgreSQL PaaS instance overland
2022/04/14 RE: Query Tunning related to function Kumar, Mukesh
2022/04/14 RE: Query Tunning related to function Michel SALAIS
2022/04/14 RE: Query Tunning related to function Kumar, Mukesh
2022/04/14 Re: SQL performance issue after migration from Oracle to Aurora postgres Andrew Dunstan
2022/04/14 Re: Query Tunning related to function Ranier Vilela
2022/04/14 Query Tunning related to function Kumar, Mukesh
2022/04/14 SQL performance issue after migration from Oracle to Aurora postgres Goti
2022/04/13 Re: An I/O error occurred while sending to the backend (PG 13.4) Justin Pryzby
2022/04/13 RE: An I/O error occurred while sending to the backend (PG 13.4) [email protected]
2022/04/13 Re: Performance for SQL queries on Azure PostgreSQL PaaS instance andrew cooke
2022/04/13 RE: Performance for SQL queries on Azure PostgreSQL PaaS instance Kumar, Mukesh
2022/04/13 Re: Performance for SQL queries on Azure PostgreSQL PaaS instance Laurenz Albe
2022/04/12 Re: Performance for SQL queries on Azure PostgreSQL PaaS instance Tomas Vondra
2022/04/12 Re: Performance for SQL queries on Azure PostgreSQL PaaS instance Frits Jalvingh
2022/04/12 Performance for SQL queries on Azure PostgreSQL PaaS instance Kumar, Mukesh
2022/04/06 Re: Slow Planning Times Saurabh Sehgal
2022/04/06 Re: Slow Planning Times Tom Lane
2022/04/06 Re: Slow Planning Times Saurabh Sehgal
2022/04/06 Re: Slow Planning Times David G. Johnston
2022/04/06 Re: Slow Planning Times Saurabh Sehgal
2022/04/06 Slow Planning Times Saurabh Sehgal
2022/04/04 Re: HIGH IO and Less CPU utilization Rambabu g
2022/03/31 Re: Postgresql TPS Bottleneck Mladen Gogala
2022/03/31 Re: Postgresql TPS Bottleneck Tomas Vondra
2022/03/31 Re: Postgresql TPS Bottleneck MichaelDBA
2022/03/31 Re: HIGH IO and Less CPU utilization Mladen Gogala
2022/03/31 Re: Postgresql TPS Bottleneck Guillaume Cottenceau
2022/03/31 Postgresql TPS Bottleneck wakandavision
2022/03/30 Re: HIGH IO and Less CPU utilization Justin Pryzby
2022/03/30 RE: High process memory consumption when running sort Shai Shapira
2022/03/29 Re: HIGH IO and Less CPU utilization Rambabu g
2022/03/29 Re: HIGH IO and Less CPU utilization Justin Pryzby
2022/03/29 Re: HIGH IO and Less CPU utilization Rambabu g
2022/03/29 Re: HIGH IO and Less CPU utilization Justin Pryzby
2022/03/29 HIGH IO and Less CPU utilization Rambabu g
2022/03/26 RE: View taking time to show records Kumar, Mukesh
2022/03/26 Re: Performance issue post upgrade on Version 13 - Incorrect Estimation Cost choosing Hash Aggregate-Nested Left Loop Join Tomas Vondra
2022/03/25 Re: View taking time to show records Laurenz Albe
2022/03/25 Re: View taking time to show records Laurenz Albe
2022/03/25 Re: View taking time to show records hubert depesz lubaczewski
2022/03/25 Re: View taking time to show records aditya desai
2022/03/25 View taking time to show records Kumar, Mukesh
2022/03/24 Re: Performance issue post upgrade on Version 13 - Incorrect Estimation Cost choosing Hash Aggregate-Nested Left Loop Join Justin Pryzby
2022/03/24 Performance issue post upgrade on Version 13 - Incorrect Estimation Cost choosing Hash Aggregate-Nested Left Loop Join Prajna Shetty
2022/03/24 Re: Using system tables directly takes many hours, using temp tables with no indexes takes a few seconds for geometry_columns view. Lars Aksel Opsahl
2022/03/23 Re: High process memory consumption when running sort Justin Pryzby
2022/03/23 Re: Using system tables directly takes many hours, using temp tables with no indexes takes a few seconds for geometry_columns view. Lars Aksel Opsahl
2022/03/23 High process memory consumption when running sort Shai Shapira
2022/03/23 Re: Using system tables directly takes many hours, using temp tables with no indexes takes a few seconds for geometry_columns view. Justin Pryzby
2022/03/23 Re: Using system tables directly takes many hours, using temp tables with no indexes takes a few seconds for geometry_columns view. Lars Aksel Opsahl
2022/03/23 Using system tables directly takes many hours, using temp tables with no indexes takes a few seconds for geometry_columns view. Lars Aksel Opsahl
2022/03/16 RE: Optimal configuration for server Michel SALAIS
2022/03/12 Re: Optimal configuration for server Moises Lopez
2022/03/09 Re: Explain analyse with track_io_timing Jayadevan M
2022/03/09 Re: Explain analyse with track_io_timing Julien Rouhaud
2022/03/09 Explain analyse with track_io_timing Jayadevan M
2022/03/08 Re: Any way to speed up INSERT INTO aditya desai
2022/03/08 Re: Any way to speed up INSERT INTO Bruce Momjian
2022/03/08 Re: Any way to speed up INSERT INTO aditya desai
2022/03/07 Re: Optimal configuration for server Justin Pryzby
2022/03/07 Re: Optimal configuration for server Ranier Vilela
2022/03/07 Re: Optimal configuration for server Luiz Felipph
2022/03/07 Re: Optimal configuration for server Tomas Vondra
2022/03/07 Re: Optimal configuration for server Ranier Vilela
2022/03/07 Re: Optimal configuration for server Luiz Felipph
2022/03/07 Re: Optimal configuration for server Ranier Vilela
2022/03/07 Optimal configuration for server Luiz Felipph
2022/03/05 Re: OOM killer while pg_restore Ranier Vilela
2022/03/05 Re: OOM killer while pg_restore Marc Rechté
2022/03/04 Re: Any way to speed up INSERT INTO aditya desai
2022/03/04 Re: XA transactions much slower on 14.2 than on 13.5 Tom Lane
2022/03/04 XA transactions much slower on 14.2 than on 13.5 Mladen Gogala
2022/03/04 Re: Any way to speed up INSERT INTO Imre Samu
2022/03/04 RES: Any way to speed up INSERT INTO Edson Richter
2022/03/04 Re: Any way to speed up INSERT INTO Andres Freund
2022/03/04 Re: Any way to speed up INSERT INTO Bruce Momjian
2022/03/04 Re: Any way to speed up INSERT INTO aditya desai
2022/03/04 Re: Any way to speed up INSERT INTO Tom Lane
2022/03/04 Re: Any way to speed up INSERT INTO Bruce Momjian
2022/03/04 Any way to speed up INSERT INTO aditya desai
2022/03/03 Re: OOM killer while pg_restore Tom Lane
2022/03/03 Re: OOM killer while pg_restore Marc Rechté
2022/03/03 Re: An I/O error occurred while sending to the backend (PG 13.4) Ranier Vilela
2022/03/03 RE: An I/O error occurred while sending to the backend (PG 13.4) [email protected]
2022/03/03 Re: An I/O error occurred while sending to the backend (PG 13.4) Ranier Vilela
2022/03/03 Re: An I/O error occurred while sending to the backend (PG 13.4) Justin Pryzby
2022/03/03 Re: An I/O error occurred while sending to the backend (PG 13.4) Ranier Vilela
2022/03/03 Re: OOM killer while pg_restore Tom Lane
2022/03/03 RE: An I/O error occurred while sending to the backend (PG 13.4) [email protected]
2022/03/03 Re: OOM killer while pg_restore Justin Pryzby
2022/03/03 Re: OOM killer while pg_restore Ranier Vilela
2022/03/03 Re: OOM killer while pg_restore Marc Rechté
2022/03/03 Re: OOM killer while pg_restore Ranier Vilela
2022/03/03 OOM killer while pg_restore Marc Rechté
2022/03/02 Re: Simple task with partitioning which I can't realize Mladen Gogala
2022/03/02 Re: Simple task with partitioning which I can't realize Geri Wright
2022/03/01 RE: Simple task with partitioning which I can't realize Michel SALAIS
2022/03/01 Re: Advice needed: query performance deteriorates by 2000% within 1 minute Michael Lewis
2022/03/01 Re: Advice needed: query performance deteriorates by 2000% within 1 minute Michael Lewis
2022/03/01 Re: An I/O error occurred while sending to the backend (PG 13.4) Ranier Vilela
2022/03/01 Re: An I/O error occurred while sending to the backend (PG 13.4) Justin Pryzby
2022/03/01 RE: Simple task with partitioning which I can't realize Andrew Zakharov
2022/03/01 Re: Simple task with partitioning which I can't realize Marc Millas
2022/03/01 RE: Simple task with partitioning which I can't realize Andrew Zakharov
2022/03/01 Re: Simple task with partitioning which I can't realize David G. Johnston
2022/03/01 RE: Simple task with partitioning which I can't realize Andrew Zakharov
2022/03/01 Re: Simple task with partitioning which I can't realize Marc Millas
2022/03/01 RE: An I/O error occurred while sending to the backend (PG 13.4) [email protected]
2022/03/01 Re: Simple task with partitioning which I can't realize David G. Johnston
2022/03/01 Re: Never Ending query in PostgreSQL Tomas Vondra
2022/03/01 Simple task with partitioning which I can't realize Andrew Zakharov
2022/03/01 RE: Never Ending query in PostgreSQL Kumar, Mukesh
2022/03/01 Re: Never Ending query in PostgreSQL Tomas Vondra
2022/03/01 RLS not using index scan but seq scan when condition gets a bit complicated Charles Huang
2022/02/28 Re: Advice needed: query performance deteriorates by 2000% within 1 minute Peter Adlersburg
2022/02/28 Re: Never Ending query in PostgreSQL Mladen Gogala
2022/02/28 Re: Never Ending query in PostgreSQL Mladen Gogala
2022/02/28 Re: An I/O error occurred while sending to the backend (PG 13.4) Justin Pryzby
2022/02/28 RE: An I/O error occurred while sending to the backend (PG 13.4) [email protected]