pgsql-performance  

Messages by Thread

• why choosing an hash index instead of the btree version even if the cost is lower? Luca Ferrari
  • Re: why choosing an hash index instead of the btree version even if the cost is lower? Tomas Vondra
  • Re: why choosing an hash index instead of the btree version even if the cost is lower? Tom Lane
  • Re: why choosing an hash index instead of the btree version even if the cost is lower? Luca Ferrari
  • Re: why choosing an hash index instead of the btree version even if the cost is lower? Luca Ferrari
• When can joins be avoided? Stefan Fehrenbach
  • Re: When can joins be avoided? Tom Lane
• =ANY(ARRAY) vs =ANY(ARRAY(expr)) performance Ramdip Gill
  • Re: =ANY(ARRAY) vs =ANY(ARRAY(expr)) performance Ramdip Gill
  • Re: =ANY(ARRAY) vs =ANY(ARRAY(expr)) performance Rick Otten
  • Re: =ANY(ARRAY) vs =ANY(ARRAY(expr)) performance Guillaume Cottenceau
• ogr2ogr slow sql when checking system tables for column info and so on. Lars Aksel Opsahl
  • Re: ogr2ogr slow sql when checking system tables for column info and so on. Julien Rouhaud
  • Re: ogr2ogr slow sql when checking system tables for column info and so on. Lars Aksel Opsahl
  • Re: ogr2ogr slow sql when checking system tables for column info and so on. Julien Rouhaud
  • Re: ogr2ogr slow sql when checking system tables for column info and so on. Lars Aksel Opsahl
• Explain returns different number of rows Vince McMahon
• Identify root-cause for intermittent spikes Sengottaiyan T
  • Re: Identify root-cause for intermittent spikes MichaelDBA
  • Re: Identify root-cause for intermittent spikes Sengottaiyan T
  • Re: Identify root-cause for intermittent spikes hubert depesz lubaczewski
  • Re: Identify root-cause for intermittent spikes Sengottaiyan T
  • Re: Identify root-cause for intermittent spikes Julien Rouhaud
  • Re: Identify root-cause for intermittent spikes hubert depesz lubaczewski
  • Re: Identify root-cause for intermittent spikes Rick Otten
  • Re: Identify root-cause for intermittent spikes Sengottaiyan T
  • Re: Identify root-cause for intermittent spikes SAMEER KUMAR
• Milions of views - performance, stability Hubert Rutkowski
  • Re: Milions of views - performance, stability Laurenz Albe
• Query is sometimes fast and sometimes slow: what could be the reason? tiaswin
  • Re: Query is sometimes fast and sometimes slow: what could be the reason? Justin Pryzby
• Faster more low-level methods of having hot standby / secondary read-only servers? Gunther Schadow
• Postgresql JDBC process consumes more memory than psql client James Pang (chaolpan)
  • Re: Postgresql JDBC process consumes more memory than psql client Justin Pryzby
  • RE: Postgresql JDBC process consumes more memory than psql client James Pang (chaolpan)
  • Re: Postgresql JDBC process consumes more memory than psql client Justin Pryzby
  • RE: Postgresql JDBC process consumes more memory than psql client James Pang (chaolpan)
  • Re: Postgresql JDBC process consumes more memory than psql client Justin Pryzby
  • RE: Postgresql JDBC process consumes more memory than psql client James Pang (chaolpan)
  • RE: Postgresql JDBC process consumes more memory with partition tables update delete James Pang (chaolpan)
• Select on partitioned table is very slow Jose Osinde
  • Re: Select on partitioned table is very slow hubert depesz lubaczewski
  • Re: Select on partitioned table is very slow Laurenz Albe
  • Re: Select on partitioned table is very slow Jose Osinde
  • Re: Select on partitioned table is very slow Ranier Vilela
  • Re: Select on partitioned table is very slow Jose Osinde
• pgbench: could not connect to server: Resource temporarily unavailable Kevin McKibbin
  • Re: pgbench: could not connect to server: Resource temporarily unavailable Tom Lane
  • Re: pgbench: could not connect to server: Resource temporarily unavailable Kevin McKibbin
  • Re: pgbench: could not connect to server: Resource temporarily unavailable Andrew Dunstan
  • Re: pgbench: could not connect to server: Resource temporarily unavailable Tom Lane
  • Re: pgbench: could not connect to server: Resource temporarily unavailable Andrew Dunstan
  • Re: pgbench: could not connect to server: Resource temporarily unavailable Tom Lane
  • Re: pgbench: could not connect to server: Resource temporarily unavailable Thomas Munro
  • Re: pgbench: could not connect to server: Resource temporarily unavailable Tom Lane
  • Re: pgbench: could not connect to server: Resource temporarily unavailable Thomas Munro
  • Re: pgbench: could not connect to server: Resource temporarily unavailable Tom Lane
  • Re: pgbench: could not connect to server: Resource temporarily unavailable Thomas Munro
  • Re: pgbench: could not connect to server: Resource temporarily unavailable Tom Lane
  • Re: pgbench: could not connect to server: Resource temporarily unavailable Thomas Munro
  • Re: pgbench: could not connect to server: Resource temporarily unavailable Tom Lane
  • Re: pgbench: could not connect to server: Resource temporarily unavailable Tom Lane
  • Re: pgbench: could not connect to server: Resource temporarily unavailable Thomas Munro
  • Re: pgbench: could not connect to server: Resource temporarily unavailable Tom Lane
  • Re: pgbench: could not connect to server: Resource temporarily unavailable Thomas Munro
  • Re: pgbench: could not connect to server: Resource temporarily unavailable Thomas Munro
  • Re: pgbench: could not connect to server: Resource temporarily unavailable Tom Lane
  • Re: pgbench: could not connect to server: Resource temporarily unavailable Thomas Munro
  • Re: pgbench: could not connect to server: Resource temporarily unavailable Junwang Zhao
  • Re: pgbench: could not connect to server: Resource temporarily unavailable Tom Lane
  • Re: pgbench: could not connect to server: Resource temporarily unavailable Junwang Zhao
  • Re: pgbench: could not connect to server: Resource temporarily unavailable Kevin McKibbin
  • Re: pgbench: could not connect to server: Resource temporarily unavailable Andres Freund
• to_jsonb performance on array aggregated correlated subqueries Nico Heller
  • Re: to_jsonb performance on array aggregated correlated subqueries Justin Pryzby
  • Re: to_jsonb performance on array aggregated correlated subqueries Nico Heller
  • Re: to_jsonb performance on array aggregated correlated subqueries Justin Pryzby
  • Re: to_jsonb performance on array aggregated correlated subqueries Nico Heller
  • Re: to_jsonb performance on array aggregated correlated subqueries Nico Heller
  • Re: to_jsonb performance on array aggregated correlated subqueries Andres Freund
  • Re: to_jsonb performance on array aggregated correlated subqueries Nico Heller
  • Re: to_jsonb performance on array aggregated correlated subqueries Rick Otten
• pg_wal filling up while running huge updates aditya desai
  • Re: pg_wal filling up while running huge updates Don Seiler
  • Re: pg_wal filling up while running huge updates Justin Pryzby
• Re: PgSQL 14 - Logical Rep - Single table multiple publications? Rory Campbell-Lange
  • Re: PgSQL 14 - Logical Rep - Single table multiple publications? Rory Campbell-Lange
• Postgresql 13 partitioning advice Ameya Bidwalkar
  • Re: Postgresql 13 partitioning advice David Rowley
  • Re: Postgresql 13 partitioning advice Ameya Bidwalkar
• Postgresql 14 partitioning advice Rick Otten
  • Re: Postgresql 14 partitioning advice Justin Pryzby
  • Re: Postgresql 14 partitioning advice Jeff Janes
  • Re: Postgresql 14 partitioning advice Rick Otten
  • Re: Postgresql 14 partitioning advice Nathan Ward
  • Re: Postgresql 14 partitioning advice Rick Otten
  • Re: Postgresql 14 partitioning advice Rick Otten
  • Re: Postgresql 14 partitioning advice Slava Mudry
  • Re: Postgresql 14 partitioning advice Justin Pryzby
• alter table xxx set unlogged take long time James Pang (chaolpan)
  • Re: alter table xxx set unlogged take long time Jim Mlodgenski
  • RE: alter table xxx set unlogged take long time James Pang (chaolpan)
  • Re: alter table xxx set unlogged take long time Tom Lane
  • RE: alter table xxx set unlogged take long time James Pang (chaolpan)
  • Re: alter table xxx set unlogged take long time Jim Mlodgenski
  • RE: alter table xxx set unlogged take long time James Pang (chaolpan)
  • Re: alter table xxx set unlogged take long time Joe Conway
  • Re: alter table xxx set unlogged take long time Tom Lane
  • Re: alter table xxx set unlogged take long time Joe Conway
  • RE: alter table xxx set unlogged take long time James Pang (chaolpan)
  • Re: alter table xxx set unlogged take long time Joe Conway
  • Re: alter table xxx set unlogged take long time David G. Johnston
  • Re: alter table xxx set unlogged take long time Kyotaro Horiguchi
• PostgresSQL 9.5.21 very slow to connect and perform basic queries bruno da silva
  • Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries Justin Pryzby
  • Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries bruno da silva
  • Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries bruno da silva
  • Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries Justin Pryzby
  • Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries bruno da silva
  • Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries bruno da silva
  • Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries Andrew Dunstan
  • Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries bruno da silva
  • Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries Tom Lane
  • Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries bruno da silva
  • Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries Tom Lane
  • Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries bruno da silva
  • Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries Tom Lane
  • Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries bruno da silva
  • Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries Tom Lane
  • Re: PostgresSQL 9.5.21 very slow to connect and perform basic queries bruno da silva
• data consolidation: logical replication design considerations Rory Campbell-Lange
  • Re: data consolidation: logical replication design considerations Rick Otten
  • Re: data consolidation: logical replication design considerations Rory Campbell-Lange
  • Re: data consolidation: logical replication design considerations Rory Campbell-Lange
• Oracle_FDW table performance issue aditya desai
  • Re: Oracle_FDW table performance issue Justin Pryzby
  • Re: Oracle_FDW table performance issue aditya desai
  • Re: Oracle_FDW table performance issue Laurenz Albe
  • Re: Oracle_FDW table performance issue aditya desai
• functionality difference-performance postgreSQLv14-GCC-llvm-clang arjun shetty
• Occasional performance issue after changing table partitions Nathan Ward
  • Re: Occasional performance issue after changing table partitions Justin Pryzby
  • Re: Occasional performance issue after changing table partitions Nathan Ward
  • Re: Occasional performance issue after changing table partitions Justin Pryzby
  • Re: Occasional performance issue after changing table partitions Nathan Ward
  • Re: Occasional performance issue after changing table partitions Nathan Ward
  • Re: Occasional performance issue after changing table partitions Justin Pryzby
• Fluctuating performance of updates on small table with trigger Mikkel Lauritsen
  • Re: Fluctuating performance of updates on small table with trigger Justin Pryzby
• partition pruning only works for select but update James Pang (chaolpan)
  • Re: partition pruning only works for select but update Tom Lane
  • RE: partition pruning only works for select but update James Pang (chaolpan)
  • RE: partition pruning only works for select but update James Pang (chaolpan)
  • Re: partition pruning only works for select but update Justin Pryzby
  • Re: partition pruning only works for select but update Tom Lane
  • RE: partition pruning only works for select but update James Pang (chaolpan)
• reindex option for tuning load large data James Pang (chaolpan)
  • Re: reindex option for tuning load large data Vitalii Tymchyshyn
  • RE: reindex option for tuning load large data James Pang (chaolpan)
  • Re: reindex option for tuning load large data Jeff Janes
  • RE: reindex option for tuning load large data James Pang (chaolpan)
  • Re: reindex option for tuning load large data I. V.
• Missed query planner optimization: `n in (select q)` -> `n in (q)` Josh
  • Re: Missed query planner optimization: `n in (select q)` -> `n in (q)` David G. Johnston
• Adding non-selective key to jsonb query @> reduces performance? Marcin Krupowicz
  • Re: Adding non-selective key to jsonb query @> reduces performance? Tom Lane
• Strange behavior of limit clause in complex query Paulo Silva
  • Re: Strange behavior of limit clause in complex query Ranier Vilela
  • Re: Strange behavior of limit clause in complex query Paulo Silva
  • Re: Strange behavior of limit clause in complex query Justin Pryzby
• Query is taking too long i intermittent Mayank Kandari
  • Re: Query is taking too long i intermittent Justin Pryzby
  • Re: Query is taking too long i intermittent Tom Lane
  • Re: Query is taking too long i intermittent Mayank Kandari
• Logical reads Goti
• REINDEXdb performance degrading gradually PG13.4 Praneel Devisetty
  • REINDEXdb performance degrading gradually PG13.4 David G. Johnston
  • Re: REINDEXdb performance degrading gradually PG13.4 Michael Paquier
  • Re: REINDEXdb performance degrading gradually PG13.4 Praneel Devisetty
  • Re: REINDEXdb performance degrading gradually PG13.4 Jeff Janes
• postgres backend process hang on " D " state James Pang (chaolpan)
  • Re: postgres backend process hang on " D " state Ranier Vilela
  • Re: postgres backend process hang on " D " state Justin Pryzby
  • RE: postgres backend process hang on " D " state James Pang (chaolpan)
  • Re: postgres backend process hang on " D " state Justin Pryzby
  • RE: postgres backend process hang on " D " state James Pang (chaolpan)
  • Re: postgres backend process hang on " D " state Tom Lane
  • RE: postgres backend process hang on " D " state James Pang (chaolpan)
  • RE: postgres backend process hang on " D " state James Pang (chaolpan)
• rows selectivity overestimate for @> operator for arrays Alexey Ermakov
  • Re: rows selectivity overestimate for @> operator for arrays Tom Lane
  • Re: rows selectivity overestimate for @> operator for arrays Jeff Janes
• How to monitor Postgres real memory usage 徐志宇徐
  • Re: How to monitor Postgres real memory usage Justin Pryzby
  • Re: How to monitor Postgres real memory usage 徐志宇徐
  • Re: How to monitor Postgres real memory usage 徐志宇徐
  • Re: How to monitor Postgres real memory usage Justin Pryzby
  • Re: How to monitor Postgres real memory usage 徐志宇徐
  • Re: How to monitor Postgres real memory usage Justin Pryzby
  • Re: How to monitor Postgres real memory usage Justin Pryzby

• Earlier messages
• Later messages