pgsql-performance  

Messages by Thread

• • Re: max_wal_senders Andres Freund
• Window Functions & Table Partitions Benjamin Tingle
  • Re: Window Functions & Table Partitions David Rowley
  • Re: Window Functions & Table Partitions Benjamin Tingle
  • Re: Window Functions & Table Partitions David Rowley
• Domain check taking place unnecessarily? Mark Hills
  • Re: Domain check taking place unnecessarily? David G. Johnston
  • Re: Domain check taking place unnecessarily? Mark Hills
  • Re: Domain check taking place unnecessarily? Laurenz Albe
  • Re: Domain check taking place unnecessarily? Mark Hills
  • Re: Domain check taking place unnecessarily? Tom Lane
  • Re: Domain check taking place unnecessarily? Mark Hills
• Routing & Concurrency with trigger functions chanukya SDS
• Getting an index scan to be a parallel index scan Alex Kaiser
  • Re: Getting an index scan to be a parallel index scan Ranier Vilela
  • Re: Getting an index scan to be a parallel index scan David Rowley
  • Re: Getting an index scan to be a parallel index scan Alex Kaiser
  • Re: Getting an index scan to be a parallel index scan Justin Pryzby
  • Re: Getting an index scan to be a parallel index scan Thomas Munro
  • Re: Getting an index scan to be a parallel index scan Alex Kaiser
  • Re: Getting an index scan to be a parallel index scan Thomas Munro
  • Re: Getting an index scan to be a parallel index scan David Rowley
  • Re: Getting an index scan to be a parallel index scan Alex Kaiser
• Database Stalls Mok
  • Re: Database Stalls Justin Pryzby
  • Re: Database Stalls José Arthur Benetasso Villanova
  • Re: Database Stalls Shiv Iyer
  • Re: Database Stalls Mok
  • Fwd: Database Stalls Rick Otten
  • Re: Database Stalls Craig Jackson
• LIKE CLAUSE on VIEWS aditya desai
  • Re: LIKE CLAUSE on VIEWS Samed YILDIRIM
  • Re: LIKE CLAUSE on VIEWS Rick Otten
  • Re: LIKE CLAUSE on VIEWS Jeff Janes
• ALTER STATEMENT getting blocked aditya desai
  • Re: ALTER STATEMENT getting blocked Tom Lane
  • Re: ALTER STATEMENT getting blocked MichaelDBA
  • Re: ALTER STATEMENT getting blocked aditya desai
• change the default value of enable_bitmapscan to off [email protected]
  • Re: change the default value of enable_bitmapscan to off Pavel Stehule
  • Re: change the default value of enable_bitmapscan to off Tom Lane
• Advice on best way to store a large amount of data in postgresql spiral
  • Re: Advice on best way to store a large amount of data in postgresql [email protected]
  • Re: Advice on best way to store a large amount of data in postgresql Justin Pryzby
  • Re: Advice on best way to store a large amount of data in postgresql spiral
  • Re: Advice on best way to store a large amount of data in postgresql Samed YILDIRIM
• Max write throughput for single COPY Joe Wildish
• How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) Maxim Boguk
  • Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) Justin Pryzby
  • Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) Maxim Boguk
  • Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) MichaelDBA
  • Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) Maxim Boguk
  • Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) MichaelDBA
  • Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) Maxim Boguk
  • Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) MichaelDBA
  • Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) Maxim Boguk
  • Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) Maxim Boguk
  • Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) MichaelDBA
  • Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) Maxim Boguk
  • Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) MichaelDBA
• When you really want to force a certain join type? Gunther Schadow
  • Re: When you really want to force a certain join type? Justin Pryzby
  • Re: When you really want to force a certain join type? Gunther Schadow
  • Re: When you really want to force a certain join type? Tom Lane
• temp_file_limit? Frits Jalvingh
  • Re: temp_file_limit? Justin Pryzby
  • Fwd: temp_file_limit? Frits Jalvingh
  • Re: Fwd: temp_file_limit? Tom Lane
  • Re: Fwd: temp_file_limit? Justin Pryzby
  • Re: Fwd: temp_file_limit? Thomas Munro
  • Re: Fwd: temp_file_limit? Thomas Munro
  • Re: Fwd: temp_file_limit? Frits Jalvingh
  • Re: Fwd: temp_file_limit? Ranier Vilela
  • Re: Fwd: temp_file_limit? Frits Jalvingh
  • Re: Fwd: temp_file_limit? Ranier Vilela
  • Re: Fwd: temp_file_limit? Frits Jalvingh
  • Re: Fwd: temp_file_limit? Justin Pryzby
  • Re: Fwd: temp_file_limit? Frits Jalvingh
  • Re: Fwd: temp_file_limit? Ranier Vilela
  • Re: Fwd: temp_file_limit? Frits Jalvingh
  • Re: Fwd: temp_file_limit? Thomas Munro
  • Re: Fwd: temp_file_limit? Frits Jalvingh
  • Re: Fwd: temp_file_limit? Frits Jalvingh
  • Re: Fwd: temp_file_limit? Justin Pryzby
  • Re: Fwd: temp_file_limit? Justin Pryzby
  • Re: Fwd: temp_file_limit? Frits Jalvingh
  • Re: Fwd: temp_file_limit? Justin Pryzby
  • Re: Fwd: temp_file_limit? Frits Jalvingh
• Postgres12 looking for possible HashAggregate issue workarounds? João Paulo Luís
  • Re: Postgres12 looking for possible HashAggregate issue workarounds? Justin Pryzby
  • RE: Postgres12 looking for possible HashAggregate issue workarounds? João Paulo Luís
  • Re: Postgres12 looking for possible HashAggregate issue workarounds? David Rowley
  • RE: Postgres12 looking for possible HashAggregate issue workarounds? João Paulo Luís
• JSON down performacen when id:1 Render Comunicacion S . L .
  • Re: JSON down performacen when id:1 Tom Lane
  • Re: JSON down performacen when id:1 Render Comunicacion S.L.
• time sorted UUIDs Tim Jones
  • Re: time sorted UUIDs Laurenz Albe
  • Re: time sorted UUIDs Adrien Nayrat
  • Re: time sorted UUIDs peter plachta
• DML sql execution time slow down PGv14 compared with PGv13 James Pang (chaolpan)
  • Re: DML sql execution time slow down PGv14 compared with PGv13 David Rowley
  • RE: DML sql execution time slow down PGv14 compared with PGv13 James Pang (chaolpan)
  • RE: DML sql execution time slow down PGv14 compared with PGv13 James Pang (chaolpan)
  • DML sql execution time slow down PGv14 compared with PGv13 James Pang (chaolpan)
  • Re: DML sql execution time slow down PGv14 compared with PGv13 Samed YILDIRIM
  • RE: DML sql execution time slow down PGv14 compared with PGv13 James Pang (chaolpan)
  • RE: DML sql execution time slow down PGv14 compared with PGv13 James Pang (chaolpan)
• creating hash indexes Rick Otten
  • Re: creating hash indexes Peter Geoghegan
• Re: Increased iowait and blk_read_time with higher shared_buffers Samed YILDIRIM
  • Re: Increased iowait and blk_read_time with higher shared_buffers Jordan Hurwich
  • Re: Increased iowait and blk_read_time with higher shared_buffers Tom Lane
  • Re: Increased iowait and blk_read_time with higher shared_buffers Jordan Hurwich
  • Re: Increased iowait and blk_read_time with higher shared_buffers Samed YILDIRIM
  • Re: Increased iowait and blk_read_time with higher shared_buffers Jordan Hurwich
• wrong rows and cost estimation when generic plan James Pang
  • RE: wrong rows and cost estimation when generic plan James Pang (chaolpan)
  • Re: wrong rows and cost estimation when generic plan David Rowley
  • RE: wrong rows and cost estimation when generic plan James Pang (chaolpan)
  • Re: wrong rows and cost estimation when generic plan David Rowley
  • RE: wrong rows and cost estimation when generic plan James Pang (chaolpan)
• Odd Choice of seq scan Paul McGarry
  • Re: Odd Choice of seq scan Justin Pryzby
  • Re: Odd Choice of seq scan Ronuk Raval
  • Re: Odd Choice of seq scan Tom Lane
  • Re: Odd Choice of seq scan Paul McGarry
  • Re: Odd Choice of seq scan Chris Hoover
• Geometric types row estimation Igor ALBUQUERQUE SILVA
  • Re: Geometric types row estimation Igor ALBUQUERQUE SILVA
  • Re: Geometric types row estimation Tom Lane
  • Re: Geometric types row estimation Igor ALBUQUERQUE SILVA
  • Re: Geometric types row estimation Tom Lane
  • Re: Geometric types row estimation Igor ALBUQUERQUE SILVA
• Catching up with performance & PostgreSQL 15 Josh Berkus
  • Re: Catching up with performance & PostgreSQL 15 Justin Pryzby
  • Re: Catching up with performance & PostgreSQL 15 Josh Berkus
  • Re: Catching up with performance & PostgreSQL 15 Mladen Gogala
  • Re: Catching up with performance & PostgreSQL 15 Alvaro Herrera
  • Re: Catching up with performance & PostgreSQL 15 Mladen Gogala
  • Re: Catching up with performance & PostgreSQL 15 Alvaro Herrera
  • Re: Catching up with performance & PostgreSQL 15 Mladen Gogala
  • Re: Catching up with performance & PostgreSQL 15 Alvaro Herrera
  • Re: Catching up with performance & PostgreSQL 15 Mladen Gogala
  • Re: Catching up with performance & PostgreSQL 15 Tom Lane
  • Re: Catching up with performance & PostgreSQL 15 David Rowley
  • Re: Catching up with performance & PostgreSQL 15 Andrew Dunstan
  • Re: Catching up with performance & PostgreSQL 15 Andres Freund
  • Re: Catching up with performance & PostgreSQL 15 Tom Lane
  • Re: Catching up with performance & PostgreSQL 15 Andrew Dunstan
  • Re: Catching up with performance & PostgreSQL 15 Jeff Janes
• Need suggestion to set-up RDS alerts on GP3 volumes Sengottaiyan T
• 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

• Earlier messages
• Later messages