pgsql-performance  

Messages by Date

• 2022/12/16 Postgres12 looking for possible HashAggregate issue workarounds? João Paulo Luís
• 2022/12/16 Re: JSON down performacen when id:1 Tom Lane
• 2022/12/16 JSON down performacen when id:1 Render Comunicacion S . L .
• 2022/12/15 RE: DML sql execution time slow down PGv14 compared with PGv13 James Pang (chaolpan)
• 2022/12/15 Re: time sorted UUIDs Adrien Nayrat
• 2022/12/15 Re: time sorted UUIDs Laurenz Albe
• 2022/12/15 time sorted UUIDs Tim Jones
• 2022/12/15 RE: DML sql execution time slow down PGv14 compared with PGv13 James Pang (chaolpan)
• 2022/12/15 Re: DML sql execution time slow down PGv14 compared with PGv13 David Rowley
• 2022/12/15 RE: DML sql execution time slow down PGv14 compared with PGv13 James Pang (chaolpan)
• 2022/12/15 RE: DML sql execution time slow down PGv14 compared with PGv13 James Pang (chaolpan)
• 2022/12/15 Re: DML sql execution time slow down PGv14 compared with PGv13 Samed YILDIRIM
• 2022/12/15 DML sql execution time slow down PGv14 compared with PGv13 James Pang (chaolpan)
• 2022/12/15 DML sql execution time slow down PGv14 compared with PGv13 James Pang (chaolpan)
• 2022/12/14 Re: creating hash indexes Peter Geoghegan
• 2022/12/14 creating hash indexes Rick Otten
• 2022/12/14 Re: Increased iowait and blk_read_time with higher shared_buffers Jordan Hurwich
• 2022/12/14 Re: Increased iowait and blk_read_time with higher shared_buffers Samed YILDIRIM
• 2022/12/14 Re: Increased iowait and blk_read_time with higher shared_buffers Jordan Hurwich
• 2022/12/14 Re: Increased iowait and blk_read_time with higher shared_buffers Tom Lane
• 2022/12/14 Re: Increased iowait and blk_read_time with higher shared_buffers Jordan Hurwich
• 2022/12/14 Re: Increased iowait and blk_read_time with higher shared_buffers Samed YILDIRIM
• 2022/12/06 wrong rows and cost estimation when generic plan James Pang
• 2022/12/06 Re: wrong rows and cost estimation when generic plan David Rowley
• 2022/12/05 RE: wrong rows and cost estimation when generic plan James Pang (chaolpan)
• 2022/12/05 Re: wrong rows and cost estimation when generic plan David Rowley
• 2022/12/05 RE: wrong rows and cost estimation when generic plan James Pang (chaolpan)
• 2022/12/05 RE: wrong rows and cost estimation when generic plan James Pang (chaolpan)
• 2022/12/03 Re: Catching up with performance & PostgreSQL 15 Jeff Janes
• 2022/12/02 Re: Odd Choice of seq scan Chris Hoover
• 2022/12/02 Re: Odd Choice of seq scan Paul McGarry
• 2022/12/01 Re: Odd Choice of seq scan Tom Lane
• 2022/12/01 Re: Odd Choice of seq scan Ronuk Raval
• 2022/12/01 Re: Odd Choice of seq scan Justin Pryzby
• 2022/12/01 Odd Choice of seq scan Paul McGarry
• 2022/12/01 Re: Catching up with performance & PostgreSQL 15 Andrew Dunstan
• 2022/11/30 Re: Geometric types row estimation Igor ALBUQUERQUE SILVA
• 2022/11/30 Re: Geometric types row estimation Tom Lane
• 2022/11/30 Re: Geometric types row estimation Igor ALBUQUERQUE SILVA
• 2022/11/30 Re: Geometric types row estimation Tom Lane
• 2022/11/30 Re: Geometric types row estimation Igor ALBUQUERQUE SILVA
• 2022/11/30 Geometric types row estimation Igor ALBUQUERQUE SILVA
• 2022/11/30 Re: Catching up with performance & PostgreSQL 15 Tom Lane
• 2022/11/30 Re: Catching up with performance & PostgreSQL 15 Andres Freund
• 2022/11/30 Re: Catching up with performance & PostgreSQL 15 Andrew Dunstan
• 2022/11/29 Re: Catching up with performance & PostgreSQL 15 Mladen Gogala
• 2022/11/29 Re: Catching up with performance & PostgreSQL 15 David Rowley
• 2022/11/29 Re: Catching up with performance & PostgreSQL 15 Alvaro Herrera
• 2022/11/29 Re: Catching up with performance & PostgreSQL 15 Tom Lane
• 2022/11/29 Re: Catching up with performance & PostgreSQL 15 Mladen Gogala
• 2022/11/29 Re: Catching up with performance & PostgreSQL 15 Mladen Gogala
• 2022/11/29 Re: Catching up with performance & PostgreSQL 15 Alvaro Herrera
• 2022/11/29 Re: Catching up with performance & PostgreSQL 15 Alvaro Herrera
• 2022/11/28 Re: Catching up with performance & PostgreSQL 15 Josh Berkus
• 2022/11/28 Re: Catching up with performance & PostgreSQL 15 Mladen Gogala
• 2022/11/28 Re: Catching up with performance & PostgreSQL 15 Justin Pryzby
• 2022/11/28 Catching up with performance & PostgreSQL 15 Josh Berkus
• 2022/11/18 Need suggestion to set-up RDS alerts on GP3 volumes Sengottaiyan T
• 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

• Earlier messages
• Later messages