pgsql-performance  

Messages by Date

• 2022/11/18 Re: why choosing an hash index instead of the btree version even if the cost is lower? Luca Ferrari
• 2022/11/18 Re: why choosing an hash index instead of the btree version even if the cost is lower? Luca Ferrari
• 2022/11/18 Re: why choosing an hash index instead of the btree version even if the cost is lower? Tom Lane
• 2022/11/18 Re: why choosing an hash index instead of the btree version even if the cost is lower? Tomas Vondra
• 2022/11/18 why choosing an hash index instead of the btree version even if the cost is lower? Luca Ferrari
• 2022/11/17 Re: When can joins be avoided? Tom Lane
• 2022/11/17 When can joins be avoided? Stefan Fehrenbach
• 2022/11/14 Re: =ANY(ARRAY) vs =ANY(ARRAY(expr)) performance Guillaume Cottenceau
• 2022/11/14 Re: =ANY(ARRAY) vs =ANY(ARRAY(expr)) performance Rick Otten
• 2022/11/13 Re: =ANY(ARRAY) vs =ANY(ARRAY(expr)) performance Ramdip Gill
• 2022/11/13 =ANY(ARRAY) vs =ANY(ARRAY(expr)) performance Ramdip Gill
• 2022/10/21 Re: ogr2ogr slow sql when checking system tables for column info and so on. Lars Aksel Opsahl
• 2022/10/21 Re: ogr2ogr slow sql when checking system tables for column info and so on. Julien Rouhaud
• 2022/10/21 Re: ogr2ogr slow sql when checking system tables for column info and so on. Lars Aksel Opsahl
• 2022/10/21 Re: ogr2ogr slow sql when checking system tables for column info and so on. Julien Rouhaud
• 2022/10/21 ogr2ogr slow sql when checking system tables for column info and so on. Lars Aksel Opsahl
• 2022/10/20 Explain returns different number of rows Vince McMahon
• 2022/10/16 Re: Identify root-cause for intermittent spikes hubert depesz lubaczewski
• 2022/10/15 Re: Identify root-cause for intermittent spikes Julien Rouhaud
• 2022/10/14 Re: Identify root-cause for intermittent spikes Sengottaiyan T
• 2022/10/13 Re: Identify root-cause for intermittent spikes hubert depesz lubaczewski
• 2022/10/12 Re: Identify root-cause for intermittent spikes Sengottaiyan T
• 2022/10/12 Re: Identify root-cause for intermittent spikes Sengottaiyan T
• 2022/10/11 Re: Identify root-cause for intermittent spikes SAMEER KUMAR
• 2022/10/11 Re: Identify root-cause for intermittent spikes Rick Otten
• 2022/10/11 Re: Identify root-cause for intermittent spikes MichaelDBA
• 2022/10/11 Identify root-cause for intermittent spikes Sengottaiyan T
• 2022/09/16 Re: Milions of views - performance, stability Laurenz Albe
• 2022/09/16 Milions of views - performance, stability Hubert Rutkowski
• 2022/09/14 Re: Query is sometimes fast and sometimes slow: what could be the reason? Justin Pryzby
• 2022/09/14 Query is sometimes fast and sometimes slow: what could be the reason? tiaswin
• 2022/09/13 Faster more low-level methods of having hot standby / secondary read-only servers? Gunther Schadow
• 2022/09/06 RE: Postgresql JDBC process consumes more memory with partition tables update delete James Pang (chaolpan)
• 2022/09/06 RE: Postgresql JDBC process consumes more memory than psql client James Pang (chaolpan)
• 2022/09/06 Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries bruno da silva
• 2022/09/06 Re: Postgresql JDBC process consumes more memory than psql client Justin Pryzby
• 2022/09/05 RE: Postgresql JDBC process consumes more memory than psql client James Pang (chaolpan)
• 2022/09/05 Re: Postgresql JDBC process consumes more memory than psql client Justin Pryzby
• 2022/09/05 RE: Postgresql JDBC process consumes more memory than psql client James Pang (chaolpan)
• 2022/09/05 Re: Postgresql JDBC process consumes more memory than psql client Justin Pryzby
• 2022/09/05 Postgresql JDBC process consumes more memory than psql client James Pang (chaolpan)
• 2022/08/25 Re: Select on partitioned table is very slow Jose Osinde
• 2022/08/25 Re: Select on partitioned table is very slow Ranier Vilela
• 2022/08/25 Re: Select on partitioned table is very slow Jose Osinde
• 2022/08/25 Re: Select on partitioned table is very slow Laurenz Albe
• 2022/08/25 Re: Select on partitioned table is very slow hubert depesz lubaczewski
• 2022/08/25 Select on partitioned table is very slow Jose Osinde
• 2022/08/23 Re: pgbench: could not connect to server: Resource temporarily unavailable Thomas Munro
• 2022/08/23 Re: pgbench: could not connect to server: Resource temporarily unavailable Tom Lane
• 2022/08/23 Re: pgbench: could not connect to server: Resource temporarily unavailable Thomas Munro
• 2022/08/22 Re: pgbench: could not connect to server: Resource temporarily unavailable Thomas Munro
• 2022/08/22 Re: pgbench: could not connect to server: Resource temporarily unavailable Tom Lane
• 2022/08/22 Re: pgbench: could not connect to server: Resource temporarily unavailable Junwang Zhao
• 2022/08/22 Re: pgbench: could not connect to server: Resource temporarily unavailable Tom Lane
• 2022/08/22 Re: pgbench: could not connect to server: Resource temporarily unavailable Junwang Zhao
• 2022/08/22 Re: pgbench: could not connect to server: Resource temporarily unavailable Thomas Munro
• 2022/08/22 Re: pgbench: could not connect to server: Resource temporarily unavailable Kevin McKibbin
• 2022/08/22 Re: pgbench: could not connect to server: Resource temporarily unavailable Tom Lane
• 2022/08/21 Re: pgbench: could not connect to server: Resource temporarily unavailable Tom Lane
• 2022/08/21 Re: pgbench: could not connect to server: Resource temporarily unavailable Thomas Munro
• 2022/08/21 Re: pgbench: could not connect to server: Resource temporarily unavailable Tom Lane
• 2022/08/21 Re: pgbench: could not connect to server: Resource temporarily unavailable Thomas Munro
• 2022/08/21 Re: pgbench: could not connect to server: Resource temporarily unavailable Tom Lane
• 2022/08/21 Re: pgbench: could not connect to server: Resource temporarily unavailable Thomas Munro
• 2022/08/21 Re: pgbench: could not connect to server: Resource temporarily unavailable Tom Lane
• 2022/08/21 Re: pgbench: could not connect to server: Resource temporarily unavailable Andres Freund
• 2022/08/21 Re: pgbench: could not connect to server: Resource temporarily unavailable Thomas Munro
• 2022/08/21 Re: pgbench: could not connect to server: Resource temporarily unavailable Tom Lane
• 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 Tom Lane
• 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 徐志宇徐

• Earlier messages
• Later messages