pgsql-performance since 2021-04-30 00:00

Discussion of PostgreSQL's performance issues. Please see Guide to reporting problems and Slow Query Questions for some tips on how to write your performance question.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next

April 30, 2021

Thread Author Time
Re: Error while calling proc with table type from Application (npgsql) aditya desai 13:02
Re: Error while calling proc with table type from Application (npgsql) aditya desai 13:22
Re: Error while calling proc with table type from Application (npgsql) Vijaykumar Jain 17:43

May 2, 2021

Thread Author Time
15x slower PreparedStatement vs raw query Alex 19:45

May 3, 2021

Thread Author Time
Re: 15x slower PreparedStatement vs raw query Justin Pryzby 20:18

May 4, 2021

Thread Author Time
Re: 15x slower PreparedStatement vs raw query Alex 09:21
Re: 15x slower PreparedStatement vs raw query Rick Otten 12:12
Re: 15x slower PreparedStatement vs raw query Alex 13:59
Re: 15x slower PreparedStatement vs raw query Laurenz Albe 15:22
Re: 15x slower PreparedStatement vs raw query Vijaykumar Jain 15:50

May 5, 2021

Thread Author Time
Re: 15x slower PreparedStatement vs raw query David Rowley 06:57
Re: 15x slower PreparedStatement vs raw query Justin Pryzby 06:59
Re: 15x slower PreparedStatement vs raw query Alex 15:21

May 6, 2021

Thread Author Time
Very slow Query compared to Oracle / SQL - Server Semen Yefimenko 14:38
Re: Very slow Query compared to Oracle / SQL - Server luis.roberto 16:11
Re: Very slow Query compared to Oracle / SQL - Server Alexey M Boltenkov 18:15
Re: Very slow Query compared to Oracle / SQL - Server Alexey M Boltenkov 18:20
Re: Very slow Query compared to Oracle / SQL - Server Semen Yefimenko 18:59
Re: Very slow Query compared to Oracle / SQL - Server Andreas Joseph Krogh 19:26
Re: Very slow Query compared to Oracle / SQL - Server Vijaykumar Jain 19:48
Re: Very slow Query compared to Oracle / SQL - Server 📎 Alexey M Boltenkov 19:58
Re: Very slow Query compared to Oracle / SQL - Server Justin Pryzby 20:01
Re: Very slow Query compared to Oracle / SQL - Server Alexey M Boltenkov 20:02
Re: Very slow Query compared to Oracle / SQL - Server Alexey M Boltenkov 20:17
Re: Very slow Query compared to Oracle / SQL - Server Imre Samu 21:16

May 7, 2021

Thread Author Time
Re: Very slow Query compared to Oracle / SQL - Server Semen Yefimenko 08:04
Re: Very slow Query compared to Oracle / SQL - Server Vijaykumar Jain 08:44
Re: Very slow Query compared to Oracle / SQL - Server Semen Yefimenko 09:02
Re: Very slow Query compared to Oracle / SQL - Server Vijaykumar Jain 09:55
Re: Very slow Query compared to Oracle / SQL - Server Rick Otten 12:50
Re: Very slow Query compared to Oracle / SQL - Server Semen Yefimenko 15:57
Re: Very slow Query compared to Oracle / SQL - Server Justin Pryzby 16:15
Re: Very slow Query compared to Oracle / SQL - Server Tom Lane 16:28
Re: Very slow Query compared to Oracle / SQL - Server Peter Geoghegan 21:28
Re: Very slow Query compared to Oracle / SQL - Server Peter Geoghegan 21:43
Re: Very slow Query compared to Oracle / SQL - Server didier 22:17

May 8, 2021

Thread Author Time
Re: Very slow Query compared to Oracle / SQL - Server Semen Yefimenko 12:06
Re: [PATCH] force_parallel_mode and GUC categories Tom Lane 16:39

May 10, 2021

Thread Author Time
Re: Very slow Query compared to Oracle / SQL - Server Semen Yefimenko 11:14

May 13, 2021

Thread Author Time
Re: BUG #16968: Planner does not recognize optimization Eugen Konkov 13:35
PostgreSQL blocked locks query Manoj Kumar 13:54
Re: PostgreSQL blocked locks query Justin Pryzby 20:09
Re: BUG #16968: Planner does not recognize optimization David Rowley 23:52

May 14, 2021

Thread Author Time
RE: Re: PostgreSQL blocked locks query Manoj Kumar 06:51
Very slow "bloat query" Marcin Gozdalik 11:06
Re: Very slow "bloat query" Gilles Darold 11:50
Re: Very slow "bloat query" Imre Samu 12:07
Re: Very slow "bloat query" Marcin Gozdalik 12:11
Re: BUG #16968: Planner does not recognize optimization 📎 KES 12:39
Re: Very slow "bloat query" Tom Lane 15:04
Re: Very slow "bloat query" Marcin Gozdalik 15:15
Re: Very slow "bloat query" Imre Samu 15:44
Re: Very slow "bloat query" Marcin Gozdalik 15:47

May 15, 2021

Thread Author Time
Re: BUG #16968: Planner does not recognize optimization 📎 Eugen Konkov 14:34
Re: BUG #16968: Planner does not recognize optimization David Rowley 14:52
Re: BUG #16968: Planner does not recognize optimization David Rowley 14:59
Re: BUG #16968: Planner does not recognize optimization Eugen Konkov 16:10
Re: BUG #16968: Planner does not recognize optimization Eugen Konkov 16:10

May 17, 2021

Thread Author Time
Index and statistics not used rstander 20:42
Re: Index and statistics not used David Rowley 22:31

May 21, 2021

Thread Author Time
Partition with check constraint with "like" Nagaraj Raj 00:32
Re: Partition with check constraint with "like" David Rowley 01:22
Re: Partition with check constraint with "like" Nagaraj Raj 02:36
Re: Partition with check constraint with "like" Justin Pryzby 02:38
Re: Partition with check constraint with "like" Michael Lewis 03:24
Re: Partition with check constraint with "like" Nagaraj Raj 07:02
Re: Partition with check constraint with "like" David Rowley 08:23
logical replication Marc Millas 12:41
Re: logical replication Andrew Dunstan 13:21
Re: logical replication Marc Millas 13:44
Re: Partition with check constraint with "like" Nagaraj Raj 16:38
Re: Partition with check constraint with "like" Vijaykumar Jain 19:08
Re: Partition with check constraint with "like" Nagaraj Raj 19:26
RE: Partition with check constraint with "like" Michel SALAIS 21:00
Re: Partition with check constraint with "like" Nagaraj Raj 22:59
Re: Partition with check constraint with "like" Nagaraj Raj 23:28

May 22, 2021

Thread Author Time
Re: Partition with check constraint with "like" David Rowley 01:38
Re: Partition with check constraint with "like" David Rowley 01:38
RE: Partition with check constraint with "like" Michel SALAIS 05:41

May 24, 2021

Thread Author Time
transaction blocking on COMMIT Bob Jolliffe 11:30
Re: transaction blocking on COMMIT Vijaykumar Jain 11:35
Optimising outer joins in the presence of non-nullable references 📎 Philip Lykke Carlsen 12:10
Re: transaction blocking on COMMIT Bob Jolliffe 13:52
Re: transaction blocking on COMMIT Vijaykumar Jain 14:09
Re: Optimising outer joins in the presence of non-nullable references Tom Lane 14:11
Re: transaction blocking on COMMIT Bob Jolliffe 16:22
Re: transaction blocking on COMMIT Christophe Pettus 16:24
Re: transaction blocking on COMMIT Alexey M Boltenkov 21:59

May 25, 2021

Thread Author Time
issue partition scan Nagaraj Raj 22:50
Re: issue partition scan Christophe Pettus 23:01
Re: issue partition scan Nagaraj Raj 23:38

May 26, 2021

Thread Author Time
Re: issue partition scan David Rowley 00:16
Re: issue partition scan Christophe Pettus 00:27

May 27, 2021

Thread Author Time
Count (select 1) subquery as constant Eugen Konkov 10:37
Re: transaction blocking on COMMIT Bob Jolliffe 13:08

May 28, 2021

Thread Author Time
AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 03:41
Re: AWS forcing PG upgrade from v9.6 a disaster Adrian Klaver 15:12
Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 18:40
AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 18:48
Re: AWS forcing PG upgrade from v9.6 a disaster Andrew Dunstan 19:08
Re: AWS forcing PG upgrade from v9.6 a disaster Campbell, Lance 19:18
Re: AWS forcing PG upgrade from v9.6 a disaster Ron 19:38
Re: AWS forcing PG upgrade from v9.6 a disaster MichaelDBA 19:38
Re: AWS forcing PG upgrade from v9.6 a disaster Ryan Bair 19:39
Re: AWS forcing PG upgrade from v9.6 a disaster Michael Lewis 20:11
Re: AWS forcing PG upgrade from v9.6 a disaster Jan Wieck 20:23
Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 20:33
Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 20:37
Re: AWS forcing PG upgrade from v9.6 a disaster Pavel Stehule 20:38
Re: AWS forcing PG upgrade from v9.6 a disaster Andrew Dunstan 21:15
Re: AWS forcing PG upgrade from v9.6 a disaster Bruce Momjian 21:30
Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 22:06
Re: AWS forcing PG upgrade from v9.6 a disaster Bob Lunney 22:09
Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 22:13
Re: AWS forcing PG upgrade from v9.6 a disaster Ron 23:51

May 29, 2021

Thread Author Time
Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 00:38
Re: AWS forcing PG upgrade from v9.6 a disaster Jan Wieck 02:27
Re: AWS forcing PG upgrade from v9.6 a disaster Andrew Dunstan 02:41
Re: AWS forcing PG upgrade from v9.6 a disaster Christophe Pettus 02:43
Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 04:08
Re: AWS forcing PG upgrade from v9.6 a disaster Alexey M Boltenkov 05:24
Re: AWS forcing PG upgrade from v9.6 a disaster Lionel Bouton 10:40
Re: AWS forcing PG upgrade from v9.6 a disaster Jan Wieck 11:39
Re: AWS forcing PG upgrade from v9.6 a disaster Adrian Klaver 16:25
Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 19:59
Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 20:17
Re: AWS forcing PG upgrade from v9.6 a disaster Andrew Dunstan 20:35
Re: AWS forcing PG upgrade from v9.6 a disaster Michael Lewis 22:34
Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 22:47

May 31, 2021

Thread Author Time
Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 03:07
Re: AWS forcing PG upgrade from v9.6 a disaster Christophe Pettus 03:41
Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 04:23
Re: AWS forcing PG upgrade from v9.6 a disaster Tom Lane 04:44
Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 05:24

June 1, 2021

Thread Author Time
Re: AWS forcing PG upgrade from v9.6 a disaster Justin Pryzby 04:16
Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 17:44

June 4, 2021

Thread Author Time
slow query with inline function on AWS RDS with RDS 24x large Ayub Khan 08:06
Re: slow query with inline function on AWS RDS with RDS 24x large Pavel Stehule 08:22
Re: slow query with inline function on AWS RDS with RDS 24x large Ayub Khan 08:32
Re: slow query with inline function on AWS RDS with RDS 24x large Pavel Stehule 08:40
Re: slow query with inline function on AWS RDS with RDS 24x large Ayub Khan 08:51
PgSQL 12 on WinSrv ~3x faster than on Linux Taras Savchuk 11:53
Re: PgSQL 12 on WinSrv ~3x faster than on Linux David Rowley 12:42
Re: PgSQL 12 on WinSrv ~3x faster than on Linux Vijaykumar Jain 13:14
Re: PgSQL 12 on WinSrv ~3x faster than on Linux Tom Lane 13:40
RE: PgSQL 12 on WinSrv ~3x faster than on Linux Taras Savchuk 14:01

June 5, 2021

Thread Author Time
query planner not using index, instead using squential scan Ayub Khan 16:42
Re: query planner not using index, instead using squential scan Tom Lane 19:29
Re: query planner not using index, instead using squential scan Vijaykumar Jain 19:52
Re: query planner not using index, instead using squential scan Ayub Khan 21:14
Re: query planner not using index, instead using squential scan Vijaykumar Jain 21:18

June 6, 2021

Thread Author Time
Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 23:49

June 7, 2021

Thread Author Time
dexter on AWS RDS auto tune queries Ayub Khan 04:51
Re: dexter on AWS RDS auto tune queries Julien Rouhaud 04:57
Re: dexter on AWS RDS auto tune queries Christophe Pettus 05:00
Re: dexter on AWS RDS auto tune queries Ayub Khan 07:49
Re: dexter on AWS RDS auto tune queries Julien Rouhaud 07:57
Re: dexter on AWS RDS auto tune queries Ayub Khan 10:05
Re: AWS forcing PG upgrade from v9.6 a disaster Andrew Dunstan 11:52
Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 17:27

June 8, 2021

Thread Author Time
slow query Ayub Khan 16:03
Re: slow query Christophe Pettus 16:08
Re: slow query Ayub Khan 16:32
Re: slow query Tom Lane 17:14
Re: slow query Ayub Khan 17:43

June 9, 2021

Thread Author Time
waiting for client write 📎 Ayub Khan 14:47
Re: waiting for client write Magnus Hagander 14:49
Re: waiting for client write Ayub Khan 18:59
Re: slow query Jeff Janes 19:57
Re: slow query Ayub Khan 20:23

June 10, 2021

Thread Author Time
Page File Size Reached Critical Threshold PostgreSQL V13 Haseeb Khan 00:45
Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 01:50
Re: Page File Size Reached Critical Threshold PostgreSQL V13 Justin Pryzby 04:28
Re: Page File Size Reached Critical Threshold PostgreSQL V13 Haseeb Khan 06:41
Re: waiting for client write 📎 Ayub Khan 08:06
Re: Page File Size Reached Critical Threshold PostgreSQL V13 Justin Pryzby 08:55
Re: AWS forcing PG upgrade from v9.6 a disaster Andrew Dunstan 10:29
Re: Page File Size Reached Critical Threshold PostgreSQL V13 Justin Pryzby 14:33
Re: AWS forcing PG upgrade from v9.6 a disaster Joshua Drake 14:36
Re: waiting for client write Jeff Janes 15:40
Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 16:07
Re: AWS forcing PG upgrade from v9.6 a disaster Ranier Vilela 16:54
Re: waiting for client write Vijaykumar Jain 16:58
Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 17:43
Re: AWS forcing PG upgrade from v9.6 a disaster Tom Lane 18:00
Re: AWS forcing PG upgrade from v9.6 a disaster Andrew Dunstan 18:23
Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 19:29
Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 21:46

June 11, 2021

Thread Author Time
Re: waiting for client write Ayub Khan 16:28
Re: waiting for client write Pavan Pusuluri 16:46
Re: waiting for client write Ranier Vilela 16:52
Re: waiting for client write Ayub Khan 16:59
Re: waiting for client write Ranier Vilela 17:37
Re: waiting for client write Ayub Khan 17:59
Re: waiting for client write Ranier Vilela 18:03
Re: waiting for client write Ayub Khan 18:19
Re: waiting for client write Ranier Vilela 18:25
Re: waiting for client write Ayub Khan 19:45
Re: waiting for client write Jeff Janes 21:58
Re: waiting for client write Ayub Khan 22:06

Browse Archives

Prev | Next