pgsql-performance  

Messages by Date

• 2022/08/21 Re: pgbench: could not connect to server: Resource temporarily unavailable Andrew Dunstan
• 2022/08/21 Re: pgbench: could not connect to server: Resource temporarily unavailable Kevin McKibbin
• 2022/08/20 Re: pgbench: could not connect to server: Resource temporarily unavailable Tom Lane
• 2022/08/20 pgbench: could not connect to server: Resource temporarily unavailable Kevin McKibbin
• 2022/08/12 Re: to_jsonb performance on array aggregated correlated subqueries Rick Otten
• 2022/08/12 Re: to_jsonb performance on array aggregated correlated subqueries Nico Heller
• 2022/08/12 Re: to_jsonb performance on array aggregated correlated subqueries Nico Heller
• 2022/08/12 Re: to_jsonb performance on array aggregated correlated subqueries Andres Freund
• 2022/08/12 Re: to_jsonb performance on array aggregated correlated subqueries Justin Pryzby
• 2022/08/12 Re: to_jsonb performance on array aggregated correlated subqueries Nico Heller
• 2022/08/12 Re: to_jsonb performance on array aggregated correlated subqueries Nico Heller
• 2022/08/12 Re: to_jsonb performance on array aggregated correlated subqueries Justin Pryzby
• 2022/08/12 to_jsonb performance on array aggregated correlated subqueries Nico Heller
• 2022/08/08 Re: Postgresql 14 partitioning advice Justin Pryzby
• 2022/08/08 Re: Postgresql 14 partitioning advice Slava Mudry
• 2022/08/05 Re: pg_wal filling up while running huge updates Justin Pryzby
• 2022/08/05 Re: pg_wal filling up while running huge updates Don Seiler
• 2022/08/05 pg_wal filling up while running huge updates aditya desai
• 2022/08/03 Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries Tom Lane
• 2022/08/03 Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries bruno da silva
• 2022/08/03 Re: Postgresql 13 partitioning advice Ameya Bidwalkar
• 2022/08/02 Re: PgSQL 14 - Logical Rep - Single table multiple publications? Rory Campbell-Lange
• 2022/08/02 Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries Tom Lane
• 2022/08/02 Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries Tom Lane
• 2022/08/02 Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries bruno da silva
• 2022/08/02 Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries bruno da silva
• 2022/08/02 Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries Tom Lane
• 2022/08/02 Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries bruno da silva
• 2022/08/02 Re: PgSQL 14 - Logical Rep - Single table multiple publications? Rory Campbell-Lange
• 2022/08/02 Re: Postgresql 14 partitioning advice Rick Otten
• 2022/08/02 Re: Postgresql 13 partitioning advice David Rowley
• 2022/08/02 Postgresql 13 partitioning advice Ameya Bidwalkar
• 2022/08/01 Re: Postgresql 14 partitioning advice Rick Otten
• 2022/07/30 Re: Postgresql 14 partitioning advice Nathan Ward
• 2022/07/29 Re: Postgresql 14 partitioning advice Rick Otten
• 2022/07/28 Re: alter table xxx set unlogged take long time Joe Conway
• 2022/07/28 RE: alter table xxx set unlogged take long time James Pang (chaolpan)
• 2022/07/27 Re: alter table xxx set unlogged take long time Kyotaro Horiguchi
• 2022/07/27 Re: Postgresql 14 partitioning advice Jeff Janes
• 2022/07/27 Re: alter table xxx set unlogged take long time Joe Conway
• 2022/07/27 Re: alter table xxx set unlogged take long time Tom Lane
• 2022/07/27 Re: alter table xxx set unlogged take long time Joe Conway
• 2022/07/27 Re: Postgresql 14 partitioning advice Justin Pryzby
• 2022/07/27 Postgresql 14 partitioning advice Rick Otten
• 2022/07/26 Re: alter table xxx set unlogged take long time David G. Johnston
• 2022/07/26 RE: alter table xxx set unlogged take long time James Pang (chaolpan)
• 2022/07/26 Re: alter table xxx set unlogged take long time Jim Mlodgenski
• 2022/07/26 RE: alter table xxx set unlogged take long time James Pang (chaolpan)
• 2022/07/26 Re: alter table xxx set unlogged take long time Tom Lane
• 2022/07/26 RE: alter table xxx set unlogged take long time James Pang (chaolpan)
• 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

• Earlier messages
• Later messages