pgsql-performance  

Messages by Date

• 2023/03/07 Planner choosing nested loop in place of Hashjoin Praneel Devisetty
• 2023/03/01 Re: INSERT statement going in IPC Wait_event Andrew Dunstan
• 2023/03/01 INSERT statement going in IPC Wait_event aditya desai
• 2023/02/25 Re: BRIN index worse than sequential scan for large search set Tomas Vondra
• 2023/02/24 Re: BRIN index worse than sequential scan for large search set Justin Pryzby
• 2023/02/24 Re: BRIN index worse than sequential scan for large search set Mickael van der Beek
• 2023/02/24 Re: BRIN index worse than sequential scan for large search set Justin Pryzby
• 2023/02/24 BRIN index worse than sequential scan for large search set Mickael van der Beek
• 2023/02/20 Re: Window Functions & Table Partitions David Rowley
• 2023/02/15 Re: Connection forcibly closed remote server error. Ranier Vilela
• 2023/02/15 Re: Connection forcibly closed remote server error. aditya desai
• 2023/02/15 Re: Connection forcibly closed remote server error. Jeff Janes
• 2023/02/15 Re: Connection forcibly closed remote server error. Tom Lane
• 2023/02/15 Re: Connection forcibly closed remote server error. aditya desai
• 2023/02/15 Connection forcibly closed remote server error. aditya desai
• 2023/02/13 Re: For loop execution times in PostgreSQL 12 vs 15 Pavel Stehule
• 2023/02/13 Re: Performance of UPDATE operation Jeff Janes
• 2023/02/13 Re: For loop execution times in PostgreSQL 12 vs 15 Andres Freund
• 2023/02/13 Re: Performance of UPDATE operation Oluwatobi Ogunsola
• 2023/02/13 Re: Performance of UPDATE operation Laurenz Albe
• 2023/02/13 Performance of UPDATE operation Mkrtchyan, Tigran
• 2023/02/10 Re: For loop execution times in PostgreSQL 12 vs 15 Pavel Stehule
• 2023/02/10 Re: For loop execution times in PostgreSQL 12 vs 15 Pavel Stehule
• 2023/02/10 For loop execution times in PostgreSQL 12 vs 15 Adithya Kumaranchath
• 2023/02/10 Re: Domain check taking place unnecessarily? Mark Hills
• 2023/02/09 Re: Window Functions & Table Partitions Benjamin Tingle
• 2023/02/09 Re: Domain check taking place unnecessarily? Tom Lane
• 2023/02/09 Re: Domain check taking place unnecessarily? Mark Hills
• 2023/02/09 Re: Domain check taking place unnecessarily? Mark Hills
• 2023/02/08 Re: max_wal_senders Andres Freund
• 2023/02/08 Re: max_wal_senders Laurenz Albe
• 2023/02/08 max_wal_senders Rick Otten
• 2023/02/08 Re: Window Functions & Table Partitions David Rowley
• 2023/02/08 Window Functions & Table Partitions Benjamin Tingle
• 2023/02/08 Re: Domain check taking place unnecessarily? Laurenz Albe
• 2023/02/08 Re: Domain check taking place unnecessarily? David G. Johnston
• 2023/02/08 Domain check taking place unnecessarily? Mark Hills
• 2023/02/07 Routing & Concurrency with trigger functions chanukya SDS
• 2023/02/03 Re: Database Stalls Craig Jackson
• 2023/02/01 Re: Getting an index scan to be a parallel index scan Alex Kaiser
• 2023/02/01 Re: Getting an index scan to be a parallel index scan David Rowley
• 2023/02/01 Re: Getting an index scan to be a parallel index scan Thomas Munro
• 2023/02/01 Re: Getting an index scan to be a parallel index scan Alex Kaiser
• 2023/02/01 Re: Getting an index scan to be a parallel index scan Thomas Munro
• 2023/02/01 Re: Getting an index scan to be a parallel index scan Justin Pryzby
• 2023/02/01 Re: Getting an index scan to be a parallel index scan Alex Kaiser
• 2023/02/01 Re: Getting an index scan to be a parallel index scan David Rowley
• 2023/02/01 Re: Getting an index scan to be a parallel index scan Ranier Vilela
• 2023/01/31 Getting an index scan to be a parallel index scan Alex Kaiser
• 2023/01/30 Fwd: Database Stalls Rick Otten
• 2023/01/30 Re: Database Stalls Mok
• 2023/01/30 Re: Database Stalls Shiv Iyer
• 2023/01/30 Re: Database Stalls José Arthur Benetasso Villanova
• 2023/01/30 Re: Database Stalls Justin Pryzby
• 2023/01/30 Database Stalls Mok
• 2023/01/22 Re: LIKE CLAUSE on VIEWS Jeff Janes
• 2023/01/22 Re: LIKE CLAUSE on VIEWS Rick Otten
• 2023/01/22 Re: LIKE CLAUSE on VIEWS Samed YILDIRIM
• 2023/01/22 LIKE CLAUSE on VIEWS aditya desai
• 2023/01/22 Re: ALTER STATEMENT getting blocked aditya desai
• 2023/01/19 Re: ALTER STATEMENT getting blocked MichaelDBA
• 2023/01/19 Re: ALTER STATEMENT getting blocked Tom Lane
• 2023/01/19 ALTER STATEMENT getting blocked aditya desai
• 2023/01/14 Re: change the default value of enable_bitmapscan to off Tom Lane
• 2023/01/14 Re: change the default value of enable_bitmapscan to off Pavel Stehule
• 2023/01/14 change the default value of enable_bitmapscan to off hehaoc...@hotmail.com
• 2023/01/10 Re: Advice on best way to store a large amount of data in postgresql spiral
• 2023/01/09 Re: Advice on best way to store a large amount of data in postgresql Samed YILDIRIM
• 2023/01/09 Re: Advice on best way to store a large amount of data in postgresql Justin Pryzby
• 2023/01/09 Re: Advice on best way to store a large amount of data in postgresql michael...@sqlexec.com
• 2023/01/09 Advice on best way to store a large amount of data in postgresql spiral
• 2023/01/06 Max write throughput for single COPY Joe Wildish
• 2023/01/05 Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) Maxim Boguk
• 2023/01/05 Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) MichaelDBA
• 2023/01/05 Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) MichaelDBA
• 2023/01/05 Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) Maxim Boguk
• 2023/01/01 Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) Maxim Boguk
• 2023/01/01 Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) MichaelDBA
• 2023/01/01 Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) Maxim Boguk
• 2023/01/01 Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) MichaelDBA
• 2023/01/01 Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) Maxim Boguk
• 2023/01/01 Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) MichaelDBA
• 2023/01/01 Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) Maxim Boguk
• 2022/12/31 Re: How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) Justin Pryzby
• 2022/12/31 How to analyze of short but heavy intermittent slowdown on BIND on production database (or BIND vs log_lock_waits) Maxim Boguk
• 2022/12/28 Re: When you really want to force a certain join type? Tom Lane
• 2022/12/28 Re: When you really want to force a certain join type? Gunther Schadow
• 2022/12/28 Re: When you really want to force a certain join type? Justin Pryzby
• 2022/12/28 When you really want to force a certain join type? Gunther Schadow
• 2022/12/23 Re: Fwd: temp_file_limit? Frits Jalvingh
• 2022/12/20 Re: Fwd: temp_file_limit? Justin Pryzby
• 2022/12/19 Re: Fwd: temp_file_limit? Frits Jalvingh
• 2022/12/19 Re: Fwd: temp_file_limit? Frits Jalvingh
• 2022/12/19 Re: Fwd: temp_file_limit? Thomas Munro
• 2022/12/19 Re: Fwd: temp_file_limit? Frits Jalvingh
• 2022/12/19 Re: Fwd: temp_file_limit? Justin Pryzby
• 2022/12/19 Re: Fwd: temp_file_limit? Ranier Vilela
• 2022/12/19 Re: Fwd: temp_file_limit? Frits Jalvingh
• 2022/12/19 Re: Fwd: temp_file_limit? Justin Pryzby
• 2022/12/19 Re: Fwd: temp_file_limit? Justin Pryzby
• 2022/12/19 Re: Fwd: temp_file_limit? Frits Jalvingh
• 2022/12/19 RE: Postgres12 looking for possible HashAggregate issue workarounds? João Paulo Luís
• 2022/12/19 Re: Fwd: temp_file_limit? Frits Jalvingh
• 2022/12/19 Re: Fwd: temp_file_limit? Ranier Vilela
• 2022/12/19 Re: Fwd: temp_file_limit? Frits Jalvingh
• 2022/12/19 Re: Fwd: temp_file_limit? Ranier Vilela
• 2022/12/19 Re: Fwd: temp_file_limit? Frits Jalvingh
• 2022/12/18 Re: Fwd: temp_file_limit? Thomas Munro
• 2022/12/18 Re: Fwd: temp_file_limit? Thomas Munro
• 2022/12/18 Re: Fwd: temp_file_limit? Justin Pryzby
• 2022/12/18 Re: Fwd: temp_file_limit? Tom Lane
• 2022/12/18 Fwd: temp_file_limit? Frits Jalvingh
• 2022/12/18 Re: temp_file_limit? Justin Pryzby
• 2022/12/18 temp_file_limit? Frits Jalvingh
• 2022/12/18 Re: Postgres12 looking for possible HashAggregate issue workarounds? David Rowley
• 2022/12/18 RE: Postgres12 looking for possible HashAggregate issue workarounds? João Paulo Luís
• 2022/12/18 Re: JSON down performacen when id:1 Render Comunicacion S.L.
• 2022/12/16 Re: Postgres12 looking for possible HashAggregate issue workarounds? Justin Pryzby
• 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

• Earlier messages
• Later messages