pgsql-performance before 2021-07-08 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

May 17, 2021

Thread Author Time
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

June 12, 2021

Thread Author Time
Re: waiting for client write Ayub Khan 08:19
Re: waiting for client write Ranier Vilela 12:03
Re: waiting for client write Vijaykumar Jain 12:04
Re: waiting for client write Ayub Khan 12:34

June 13, 2021

Thread Author Time
Re: waiting for client write Ayub Khan 14:00
Re: waiting for client write Vijaykumar Jain 16:30
Re: waiting for client write Ayub Khan 17:00

June 14, 2021

Thread Author Time
Re: waiting for client write Ayub Khan 05:02
overcommit_ratio setting Yi Sun 10:16
pg_dumpall --exclude-database case folding, was Re: AWS forcing PG upgrade from v9.6 a disaster Andrew Dunstan 13:21
Re: pg_dumpall --exclude-database case folding, was Re: AWS forcing PG upgrade from v9.6 a disaster Tom Lane 13:32
pg_dumpall --exclude-database case folding Andrew Dunstan 13:46
Re: overcommit_ratio setting Julien Rouhaud 14:14
Re: overcommit_ratio setting Laurenz Albe 16:18
Re: Planning performance problem (67626.278ms) Manuel Weitzman 17:25
Master - Slave Replication Window Server Haseeb Khan 19:36
Re: Master - Slave Replication Window Server Rory Campbell-Lange 19:41

June 15, 2021

Thread Author Time
Re: overcommit_ratio setting Yi Sun 00:34
Re: Master - Slave Replication Window Server Haseeb Khan 05:42
Re: Master - Slave Replication Window Server Haseeb Khan 06:17
Re: overcommit_ratio setting Laurenz Albe 07:07
Re: overcommit_ratio setting Yi Sun 07:45
Re: Master - Slave Replication Window Server Rory Campbell-Lange 12:05
Re: Master - Slave Replication Window Server Haseeb Khan 12:29
Re: waiting for client write Ayub Khan 15:43
Re: Master - Slave Replication Window Server 📎 Atul Kumar 16:14
Re: waiting for client write Vijaykumar Jain 17:22

June 16, 2021

Thread Author Time
PostgreSQL V13 Replication Issue Haseeb Khan 16:25
Re: PostgreSQL V13 Replication Issue Dean Gibson (DB Administrator) 16:30

June 17, 2021

Thread Author Time
Estimating wal_keep_size Dean Gibson (DB Administrator) 00:36
Re: Estimating wal_keep_size Julien Rouhaud 01:02
Re: PostgreSQL V13 Replication Issue Michael Paquier 01:02

June 18, 2021

Thread Author Time
Re: Estimating wal_keep_size Dean Gibson (DB Administrator) 18:13
Re: Estimating wal_keep_size Julien Rouhaud 18:27
Re: Estimating wal_keep_size Vijaykumar Jain 18:40

June 20, 2021

Thread Author Time
Re: Planning performance problem (67626.278ms) 📎 Manuel Weitzman 00:09
Re: Planning performance problem (67626.278ms) Tom Lane 21:06
Re: Planning performance problem (67626.278ms) Ranier Vilela 23:23
Re: Estimating wal_keep_size Dean Gibson (DB Administrator) 23:53

June 21, 2021

Thread Author Time
Re: Planning performance problem (67626.278ms) Tom Lane 00:17

June 25, 2021

Thread Author Time
Partition column should be part of PK Nagaraj Raj 03:10
Re: Partition column should be part of PK Justin Pryzby 04:22
slow performance with cursor Ayub Khan 16:09
Re: slow performance with cursor Justin Pryzby 16:21
Re: slow performance with cursor Ayub Khan 16:37
Re: slow performance with cursor Tom Lane 18:04

June 29, 2021

Thread Author Time
Re: Planning performance problem (67626.278ms) Manuel Weitzman 19:26
Re: Planning performance problem (67626.278ms) Tom Lane 19:43
Re: Planning performance problem (67626.278ms) 📎 Manuel Weitzman 21:35
Re: Planning performance problem (67626.278ms) Tom Lane 22:31

June 30, 2021

Thread Author Time
Re: Planning performance problem (67626.278ms) Manuel Weitzman 20:56

July 1, 2021

Thread Author Time
Re: slow performance with cursor Ayub Khan 16:29
Re: slow performance with cursor Justin Pryzby 16:32
Re: slow performance with cursor Ayub Khan 20:25
Re: Planning performance problem (67626.278ms) 📎 Manuel Weitzman 20:49

July 2, 2021

Thread Author Time
Re: Planning performance problem (67626.278ms) David Rowley 09:55
Re: slow performance with cursor Tomas Vondra 14:30

July 7, 2021

Thread Author Time
Re: hint in determining effective_io_concurrency Merlin Moncure 21:42
ETL - sql orchestrator is stuck when there is not sleep() between queries Allan Barrielle 23:00

Browse Archives

Prev | Next