pgsql-performance  

Messages by Date

• 2021/06/10 Re: waiting for client write Jeff Janes
• 2021/06/10 Re: AWS forcing PG upgrade from v9.6 a disaster Joshua Drake
• 2021/06/10 Re: Page File Size Reached Critical Threshold PostgreSQL V13 Justin Pryzby
• 2021/06/10 Re: AWS forcing PG upgrade from v9.6 a disaster Andrew Dunstan
• 2021/06/10 Re: Page File Size Reached Critical Threshold PostgreSQL V13 Justin Pryzby
• 2021/06/10 Re: waiting for client write Ayub Khan
• 2021/06/09 Re: Page File Size Reached Critical Threshold PostgreSQL V13 Haseeb Khan
• 2021/06/09 Re: Page File Size Reached Critical Threshold PostgreSQL V13 Justin Pryzby
• 2021/06/09 Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 2021/06/09 Page File Size Reached Critical Threshold PostgreSQL V13 Haseeb Khan
• 2021/06/09 Re: slow query Ayub Khan
• 2021/06/09 Re: slow query Jeff Janes
• 2021/06/09 Re: waiting for client write Ayub Khan
• 2021/06/09 Re: waiting for client write Magnus Hagander
• 2021/06/08 Re: slow query Ayub Khan
• 2021/06/08 Re: slow query Tom Lane
• 2021/06/08 Re: slow query Ayub Khan
• 2021/06/08 Re: slow query Christophe Pettus
• 2021/06/08 slow query Ayub Khan
• 2021/06/07 Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 2021/06/07 Re: AWS forcing PG upgrade from v9.6 a disaster Andrew Dunstan
• 2021/06/07 Re: dexter on AWS RDS auto tune queries Ayub Khan
• 2021/06/07 Re: dexter on AWS RDS auto tune queries Julien Rouhaud
• 2021/06/07 Re: dexter on AWS RDS auto tune queries Ayub Khan
• 2021/06/06 Re: dexter on AWS RDS auto tune queries Christophe Pettus
• 2021/06/06 Re: dexter on AWS RDS auto tune queries Julien Rouhaud
• 2021/06/06 dexter on AWS RDS auto tune queries Ayub Khan
• 2021/06/06 Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 2021/06/05 Re: query planner not using index, instead using squential scan Vijaykumar Jain
• 2021/06/05 Re: query planner not using index, instead using squential scan Ayub Khan
• 2021/06/05 Re: query planner not using index, instead using squential scan Vijaykumar Jain
• 2021/06/05 Re: query planner not using index, instead using squential scan Tom Lane
• 2021/06/05 query planner not using index, instead using squential scan Ayub Khan
• 2021/06/04 RE: PgSQL 12 on WinSrv ~3x faster than on Linux Taras Savchuk
• 2021/06/04 Re: PgSQL 12 on WinSrv ~3x faster than on Linux Tom Lane
• 2021/06/04 Re: PgSQL 12 on WinSrv ~3x faster than on Linux Vijaykumar Jain
• 2021/06/04 Re: PgSQL 12 on WinSrv ~3x faster than on Linux David Rowley
• 2021/06/04 PgSQL 12 on WinSrv ~3x faster than on Linux Taras Savchuk
• 2021/06/04 Re: slow query with inline function on AWS RDS with RDS 24x large Ayub Khan
• 2021/06/04 Re: slow query with inline function on AWS RDS with RDS 24x large Pavel Stehule
• 2021/06/04 Re: slow query with inline function on AWS RDS with RDS 24x large Ayub Khan
• 2021/06/04 Re: slow query with inline function on AWS RDS with RDS 24x large Pavel Stehule
• 2021/06/04 slow query with inline function on AWS RDS with RDS 24x large Ayub Khan
• 2021/06/01 Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 2021/05/31 Re: AWS forcing PG upgrade from v9.6 a disaster Justin Pryzby
• 2021/05/30 Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 2021/05/30 Re: AWS forcing PG upgrade from v9.6 a disaster Tom Lane
• 2021/05/30 Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 2021/05/30 Re: AWS forcing PG upgrade from v9.6 a disaster Christophe Pettus
• 2021/05/30 Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 2021/05/29 Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 2021/05/29 Re: AWS forcing PG upgrade from v9.6 a disaster Andrew Dunstan
• 2021/05/29 Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 2021/05/29 Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 2021/05/29 Re: AWS forcing PG upgrade from v9.6 a disaster Jan Wieck
• 2021/05/28 Re: AWS forcing PG upgrade from v9.6 a disaster Alexey M Boltenkov
• 2021/05/28 Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 2021/05/28 Re: AWS forcing PG upgrade from v9.6 a disaster Christophe Pettus
• 2021/05/28 Re: AWS forcing PG upgrade from v9.6 a disaster Andrew Dunstan
• 2021/05/28 Re: AWS forcing PG upgrade from v9.6 a disaster Jan Wieck
• 2021/05/28 Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 2021/05/28 Re: AWS forcing PG upgrade from v9.6 a disaster Bob Lunney
• 2021/05/28 Re: AWS forcing PG upgrade from v9.6 a disaster Bruce Momjian
• 2021/05/28 Re: AWS forcing PG upgrade from v9.6 a disaster Andrew Dunstan
• 2021/05/28 Re: AWS forcing PG upgrade from v9.6 a disaster Pavel Stehule
• 2021/05/28 Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 2021/05/28 Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator)
• 2021/05/28 Re: AWS forcing PG upgrade from v9.6 a disaster Jan Wieck
• 2021/05/28 Re: AWS forcing PG upgrade from v9.6 a disaster Michael Lewis
• 2021/05/28 Re: AWS forcing PG upgrade from v9.6 a disaster Ryan Bair
• 2021/05/28 Re: AWS forcing PG upgrade from v9.6 a disaster MichaelDBA
• 2021/05/28 Re: AWS forcing PG upgrade from v9.6 a disaster Campbell, Lance
• 2021/05/28 Re: AWS forcing PG upgrade from v9.6 a disaster Andrew Dunstan
• 2021/05/27 Re: transaction blocking on COMMIT Bob Jolliffe
• 2021/05/27 Count (select 1) subquery as constant Eugen Konkov
• 2021/05/25 Re: issue partition scan Christophe Pettus
• 2021/05/25 Re: issue partition scan David Rowley
• 2021/05/25 Re: issue partition scan Nagaraj Raj
• 2021/05/25 Re: issue partition scan Christophe Pettus
• 2021/05/25 issue partition scan Nagaraj Raj
• 2021/05/24 Re: transaction blocking on COMMIT Alexey M Boltenkov
• 2021/05/24 Re: transaction blocking on COMMIT Christophe Pettus
• 2021/05/24 Re: transaction blocking on COMMIT Bob Jolliffe
• 2021/05/24 Re: Optimising outer joins in the presence of non-nullable references Tom Lane
• 2021/05/24 Re: transaction blocking on COMMIT Vijaykumar Jain
• 2021/05/24 Re: transaction blocking on COMMIT Bob Jolliffe
• 2021/05/24 Optimising outer joins in the presence of non-nullable references Philip Lykke Carlsen
• 2021/05/24 Re: transaction blocking on COMMIT Vijaykumar Jain
• 2021/05/24 transaction blocking on COMMIT Bob Jolliffe
• 2021/05/21 RE: Partition with check constraint with "like" Michel SALAIS
• 2021/05/21 Re: Partition with check constraint with "like" David Rowley
• 2021/05/21 Re: Partition with check constraint with "like" David Rowley
• 2021/05/21 Re: Partition with check constraint with "like" Nagaraj Raj
• 2021/05/21 Re: Partition with check constraint with "like" Nagaraj Raj
• 2021/05/21 RE: Partition with check constraint with "like" Michel SALAIS
• 2021/05/21 Re: Partition with check constraint with "like" Nagaraj Raj
• 2021/05/21 Re: Partition with check constraint with "like" Vijaykumar Jain
• 2021/05/21 Re: Partition with check constraint with "like" Nagaraj Raj
• 2021/05/21 Re: logical replication Marc Millas
• 2021/05/21 Re: logical replication Andrew Dunstan
• 2021/05/21 logical replication Marc Millas
• 2021/05/21 Re: Partition with check constraint with "like" David Rowley
• 2021/05/21 Re: Partition with check constraint with "like" Nagaraj Raj
• 2021/05/20 Re: Partition with check constraint with "like" Michael Lewis
• 2021/05/20 Re: Partition with check constraint with "like" Justin Pryzby
• 2021/05/20 Re: Partition with check constraint with "like" Nagaraj Raj
• 2021/05/20 Re: Partition with check constraint with "like" David Rowley
• 2021/05/20 Partition with check constraint with "like" Nagaraj Raj
• 2021/05/17 Re: Index and statistics not used David Rowley
• 2021/05/17 Index and statistics not used rstander
• 2021/05/17 Re: BUG #16968: Planner does not recognize optimization Eugen Konkov
• 2021/05/17 Re: BUG #16968: Planner does not recognize optimization Eugen Konkov
• 2021/05/17 Re: BUG #16968: Planner does not recognize optimization David Rowley
• 2021/05/17 Re: BUG #16968: Planner does not recognize optimization David Rowley
• 2021/05/14 Re: Very slow "bloat query" Marcin Gozdalik
• 2021/05/14 Re: Very slow "bloat query" Marcin Gozdalik
• 2021/05/14 Re: Very slow "bloat query" Imre Samu
• 2021/05/14 Re: BUG #16968: Planner does not recognize optimization KES
• 2021/05/14 Re: Very slow "bloat query" Marcin Gozdalik
• 2021/05/14 Re: Very slow "bloat query" Tom Lane
• 2021/05/14 Re: Very slow "bloat query" Imre Samu
• 2021/05/14 Re: Very slow "bloat query" Gilles Darold
• 2021/05/14 Very slow "bloat query" Marcin Gozdalik
• 2021/05/14 RE: Re: PostgreSQL blocked locks query Manoj Kumar
• 2021/05/14 Re: BUG #16968: Planner does not recognize optimization David Rowley
• 2021/05/13 Re: PostgreSQL blocked locks query Justin Pryzby
• 2021/05/13 PostgreSQL blocked locks query Manoj Kumar
• 2021/05/10 Re: Very slow Query compared to Oracle / SQL - Server Semen Yefimenko
• 2021/05/08 Re: Very slow Query compared to Oracle / SQL - Server Semen Yefimenko
• 2021/05/07 Re: Very slow Query compared to Oracle / SQL - Server didier
• 2021/05/07 Re: Very slow Query compared to Oracle / SQL - Server Peter Geoghegan
• 2021/05/07 Re: Very slow Query compared to Oracle / SQL - Server Peter Geoghegan
• 2021/05/07 Re: Very slow Query compared to Oracle / SQL - Server Tom Lane
• 2021/05/07 Re: Very slow Query compared to Oracle / SQL - Server Justin Pryzby
• 2021/05/07 Re: Very slow Query compared to Oracle / SQL - Server Semen Yefimenko
• 2021/05/07 Re: Very slow Query compared to Oracle / SQL - Server Rick Otten
• 2021/05/07 Re: Very slow Query compared to Oracle / SQL - Server Vijaykumar Jain
• 2021/05/07 Re: Very slow Query compared to Oracle / SQL - Server Semen Yefimenko
• 2021/05/07 Re: Very slow Query compared to Oracle / SQL - Server Vijaykumar Jain
• 2021/05/07 Re: Very slow Query compared to Oracle / SQL - Server Semen Yefimenko
• 2021/05/06 Re: Very slow Query compared to Oracle / SQL - Server Imre Samu
• 2021/05/06 Re: Very slow Query compared to Oracle / SQL - Server Alexey M Boltenkov
• 2021/05/06 Re: Very slow Query compared to Oracle / SQL - Server Alexey M Boltenkov
• 2021/05/06 Re: Very slow Query compared to Oracle / SQL - Server Justin Pryzby
• 2021/05/06 Re: Very slow Query compared to Oracle / SQL - Server Alexey M Boltenkov
• 2021/05/06 Re: Very slow Query compared to Oracle / SQL - Server Vijaykumar Jain
• 2021/05/06 Re: Very slow Query compared to Oracle / SQL - Server Andreas Joseph Krogh
• 2021/05/06 Re: Very slow Query compared to Oracle / SQL - Server Semen Yefimenko
• 2021/05/06 Re: Very slow Query compared to Oracle / SQL - Server Alexey M Boltenkov
• 2021/05/06 Re: Very slow Query compared to Oracle / SQL - Server Alexey M Boltenkov
• 2021/05/06 Re: Very slow Query compared to Oracle / SQL - Server luis . roberto
• 2021/05/06 Very slow Query compared to Oracle / SQL - Server Semen Yefimenko
• 2021/05/05 Re: 15x slower PreparedStatement vs raw query Alex
• 2021/05/04 Re: 15x slower PreparedStatement vs raw query Justin Pryzby
• 2021/05/04 Re: 15x slower PreparedStatement vs raw query David Rowley
• 2021/05/04 Re: 15x slower PreparedStatement vs raw query Vijaykumar Jain
• 2021/05/04 Re: 15x slower PreparedStatement vs raw query Laurenz Albe
• 2021/05/04 Re: 15x slower PreparedStatement vs raw query Alex
• 2021/05/04 Re: 15x slower PreparedStatement vs raw query Rick Otten
• 2021/05/04 Re: 15x slower PreparedStatement vs raw query Alex
• 2021/05/03 Re: 15x slower PreparedStatement vs raw query Justin Pryzby
• 2021/05/03 15x slower PreparedStatement vs raw query Alex
• 2021/04/30 Re: Error while calling proc with table type from Application (npgsql) Vijaykumar Jain
• 2021/04/30 Re: Error while calling proc with table type from Application (npgsql) aditya desai
• 2021/04/30 Re: Error while calling proc with table type from Application (npgsql) aditya desai
• 2021/04/29 RES: Log number of tuples returned Edson Richter
• 2021/04/29 Re: Log number of tuples returned Justin Pryzby
• 2021/04/29 Log number of tuples returned Edson Richter
• 2021/04/29 Re: Error while calling proc with table type from Application (npgsql) Justin Pryzby
• 2021/04/29 Error while calling proc with table type from Application aditya desai
• 2021/04/27 Re: Order of execution Jean-Christophe Boggio
• 2021/04/27 Order of execution luis . roberto
• 2021/04/26 Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Marc Millas
• 2021/04/26 Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Rory Campbell-Lange
• 2021/04/26 Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Marc Millas
• 2021/04/25 Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Simon Connah
• 2021/04/24 Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Rory Campbell-Lange
• 2021/04/24 Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Tomas Vondra
• 2021/04/24 Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Christophe Pettus
• 2021/04/24 Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Bruce Momjian
• 2021/04/24 Re: Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Justin Pryzby
• 2021/04/24 Does btrfs on Linux have a negative performance impact for PostgreSQL 13? Simon Connah
• 2021/04/22 Re: hint in determining effective_io_concurrency Bruce Momjian
• 2021/04/22 Re: hint in determining effective_io_concurrency Justin Pryzby
• 2021/04/22 Re: hint in determining effective_io_concurrency Luca Ferrari
• 2021/04/22 Re: hint in determining effective_io_concurrency Justin Pryzby
• 2021/04/22 Re: hint in determining effective_io_concurrency Bruce Momjian
• 2021/04/22 Re: hint in determining effective_io_concurrency Luca Ferrari
• 2021/04/22 Re: hint in determining effective_io_concurrency Bruce Momjian
• 2021/04/22 hint in determining effective_io_concurrency Luca Ferrari
• 2021/04/21 Re: Planning performance problem (67626.278ms) Tom Lane
• 2021/04/21 Re: Planning performance problem (67626.278ms) David Rowley
• 2021/04/20 Re: OLEDB for PostgreSQL Pavan Pusuluri
• 2021/04/19 Re: OLEDB for PostgreSQL aditya desai
• 2021/04/18 Re: Most proper partitioning form on an integer column Justin Pryzby
• 2021/04/18 Most proper partitioning form on an integer column Il Mimo di Creta
• 2021/04/16 Re: Disabling options lowers the estimated cost of a query Tomas Vondra
• 2021/04/16 Re: Why is there a tenfold difference between Postgres's alleged query execution time and packet transmission time? Tom Lane
• 2021/04/16 Re: Disabling options lowers the estimated cost of a query Tom Lane
• 2021/04/16 Re: Disabling options lowers the estimated cost of a query Tom Lane

• Earlier messages
• Later messages