pgsql-performance

Messages by Date

2022/07/26 Re: alter table xxx set unlogged take long time Jim Mlodgenski
2022/07/26 alter table xxx set unlogged take long time James Pang (chaolpan)
2022/07/23 Re: data consolidation: logical replication design considerations Rory Campbell-Lange
2022/07/21 Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries bruno da silva
2022/07/21 Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries bruno da silva
2022/07/21 Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries Justin Pryzby
2022/07/21 Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries Andrew Dunstan
2022/07/21 Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries bruno da silva
2022/07/21 Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries bruno da silva
2022/07/21 Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries Justin Pryzby
2022/07/21 PostgresSQL 9.5.21 very slow to connect and perform basic queries bruno da silva
2022/07/18 Re: data consolidation: logical replication design considerations Rory Campbell-Lange
2022/07/17 Re: data consolidation: logical replication design considerations Rick Otten
2022/07/16 data consolidation: logical replication design considerations Rory Campbell-Lange
2022/07/12 Re: Occasional performance issue after changing table partitions Justin Pryzby
2022/07/12 Re: Occasional performance issue after changing table partitions Nathan Ward
2022/07/11 Re: Oracle_FDW table performance issue aditya desai
2022/07/11 Re: Oracle_FDW table performance issue Laurenz Albe
2022/07/11 Re: Oracle_FDW table performance issue aditya desai
2022/07/11 Re: Oracle_FDW table performance issue Justin Pryzby
2022/07/11 Oracle_FDW table performance issue aditya desai
2022/07/11 functionality difference-performance postgreSQLv14-GCC-llvm-clang arjun shetty
2022/07/10 Re: Occasional performance issue after changing table partitions Nathan Ward
2022/07/10 Re: Occasional performance issue after changing table partitions Justin Pryzby
2022/07/10 Re: Occasional performance issue after changing table partitions Nathan Ward
2022/07/10 Re: Occasional performance issue after changing table partitions Justin Pryzby
2022/07/09 Occasional performance issue after changing table partitions Nathan Ward
2022/07/01 RE: partition pruning only works for select but update James Pang (chaolpan)
2022/07/01 Re: partition pruning only works for select but update Tom Lane
2022/07/01 Re: partition pruning only works for select but update Justin Pryzby
2022/07/01 RE: partition pruning only works for select but update James Pang (chaolpan)
2022/06/29 Re: Fluctuating performance of updates on small table with trigger Justin Pryzby
2022/06/29 Fluctuating performance of updates on small table with trigger Mikkel Lauritsen
2022/06/28 RE: partition pruning only works for select but update James Pang (chaolpan)
2022/06/28 Re: partition pruning only works for select but update Tom Lane
2022/06/28 partition pruning only works for select but update James Pang (chaolpan)
2022/06/19 Re: reindex option for tuning load large data I. V.
2022/06/19 RE: reindex option for tuning load large data James Pang (chaolpan)
2022/06/18 Re: reindex option for tuning load large data Jeff Janes
2022/06/17 RE: reindex option for tuning load large data James Pang (chaolpan)
2022/06/17 Re: reindex option for tuning load large data Vitalii Tymchyshyn
2022/06/16 reindex option for tuning load large data James Pang (chaolpan)
2022/06/12 Re: Missed query planner optimization: `n in (select q)` -> `n in (q)` David G. Johnston
2022/06/12 Missed query planner optimization: `n in (select q)` -> `n in (q)` Josh
2022/06/08 Re: Strange behavior of limit clause in complex query Justin Pryzby
2022/06/08 Re: Adding non-selective key to jsonb query @> reduces performance? Tom Lane
2022/06/08 Re: Strange behavior of limit clause in complex query Paulo Silva
2022/06/08 Re: Strange behavior of limit clause in complex query Ranier Vilela
2022/06/08 Adding non-selective key to jsonb query @> reduces performance? Marcin Krupowicz
2022/06/08 Strange behavior of limit clause in complex query Paulo Silva
2022/06/06 Re: Query is taking too long i intermittent Mayank Kandari
2022/06/06 Re: Query is taking too long i intermittent Tom Lane
2022/06/06 Re: Query is taking too long i intermittent Justin Pryzby
2022/06/06 Query is taking too long i intermittent Mayank Kandari
2022/06/01 Re: rows selectivity overestimate for @> operator for arrays Jeff Janes
2022/06/01 Re: REINDEXdb performance degrading gradually PG13.4 Jeff Janes
2022/06/01 Re: REINDEXdb performance degrading gradually PG13.4 Praneel Devisetty
2022/05/31 Re: REINDEXdb performance degrading gradually PG13.4 Michael Paquier
2022/05/31 Logical reads Goti
2022/05/31 REINDEXdb performance degrading gradually PG13.4 David G. Johnston
2022/05/31 REINDEXdb performance degrading gradually PG13.4 Praneel Devisetty
2022/05/30 RE: postgres backend process hang on " D " state James Pang (chaolpan)
2022/05/29 RE: postgres backend process hang on " D " state James Pang (chaolpan)
2022/05/29 RE: postgres backend process hang on " D " state James Pang (chaolpan)
2022/05/29 Re: postgres backend process hang on " D " state Tom Lane
2022/05/29 Re: postgres backend process hang on " D " state Justin Pryzby
2022/05/29 RE: postgres backend process hang on " D " state James Pang (chaolpan)
2022/05/29 Re: postgres backend process hang on " D " state Justin Pryzby
2022/05/29 Re: postgres backend process hang on " D " state Ranier Vilela
2022/05/29 postgres backend process hang on " D " state James Pang (chaolpan)
2022/05/27 Re: rows selectivity overestimate for @> operator for arrays Tom Lane
2022/05/27 Re: How to monitor Postgres real memory usage Justin Pryzby
2022/05/27 rows selectivity overestimate for @> operator for arrays Alexey Ermakov
2022/05/26 Re: How to monitor Postgres real memory usage Justin Pryzby
2022/05/26 Re: How to monitor Postgres real memory usage 徐志宇徐
2022/05/26 Re: How to monitor Postgres real memory usage Justin Pryzby
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) l...@laurent-hasson.com
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