pgsql-performance since 2020-01-27 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

Jan. 27, 2020

Thread Author Time
Query optimization advice for beginners Kemal Ortanca 13:15
Re: Query optimization advice for beginners Andreas Kretschmer 13:57
Re: Query optimization advice for beginners Kemal Ortanca 15:33
Re: Query optimization advice for beginners Michael Lewis 16:46

Jan. 28, 2020

Thread Author Time
Re: Query optimization advice for beginners Laurenz Albe 08:37

Jan. 30, 2020

Thread Author Time
Re: Specific query taking time to process Fahiz Mohamed 09:44
Re: Specific query taking time to process Duncan Whitham 12:22
Re: Specific query taking time to process Tom Lane 16:35

Jan. 31, 2020

Thread Author Time
Re: Specific query taking time to process Duncan Whitham 11:01

Feb. 2, 2020

Thread Author Time
Statistics on array values Marco Colli 14:18
Re: Statistics on array values Justin Pryzby 14:23
Re: Statistics on array values Marco Colli 14:38
Re: Statistics on array values Tom Lane 17:11
Re: Statistics on array values Marco Colli 18:26
Re: Statistics on array values Tom Lane 18:32
Re: Statistics on array values Marco Colli 18:55

Feb. 3, 2020

Thread Author Time
Slow performance with trivial self-joins Benny Kramek 20:38
Re: Slow performance with trivial self-joins Tom Lane 21:10

Feb. 5, 2020

Thread Author Time
Writing 1100 rows per second Arya F 17:03
Re: Writing 1100 rows per second Laurenz Albe 17:12
Re: Writing 1100 rows per second Justin Pryzby 17:15
Re: Writing 1100 rows per second Arya F 17:25
Re: Writing 1100 rows per second Haroldo Kerry 17:46
Re: Slow performance with trivial self-joins Benny Kramek 21:55
Re: Slow performance with trivial self-joins Adam Brusselback 22:12
Re: Slow performance with trivial self-joins David Rowley 23:47

Feb. 6, 2020

Thread Author Time
Re: Writing 1100 rows per second Ogden Brash 18:15

Feb. 7, 2020

Thread Author Time
TOAST table performance problem Asya Nevra Buyuksoy 13:07
Sv: TOAST table performance problem Andreas Joseph Krogh 13:12
Re: TOAST table performance problem 📎 Asya Nevra Buyuksoy 13:23
Re: TOAST table performance problem Asya Nevra Buyuksoy 13:34
Re: TOAST table performance problem Andreas Joseph Krogh 13:41
Re: TOAST table performance problem MichaelDBA 13:52
Re: TOAST table performance problem Asya Nevra Buyuksoy 14:16
Re: TOAST table performance problem Andreas Joseph Krogh 14:19
Re: TOAST table performance problem Andreas Joseph Krogh 14:42
Re: TOAST table performance problem Asya Nevra Buyuksoy 14:59
Re: TOAST table performance problem Andreas Joseph Krogh 15:15
Re: proposal: schema variables 📎 Pavel Stehule 16:09

Feb. 9, 2020

Thread Author Time
Re: Writing 1100 rows per second Jeff Janes 19:30

Feb. 10, 2020

Thread Author Time
Fwd: TOAST table performance problem Asya Nevra Buyuksoy 07:52
Bad selectivity estimate when using a sub query to determine WHERE condition Chris Borckholder 10:34
Re: Fwd: TOAST table performance problem Luís Roberto Weck 12:31
Re: Fwd: TOAST table performance problem Asya Nevra Buyuksoy 12:38
Re: Fwd: TOAST table performance problem Jeff Janes 12:53
Re: Fwd: TOAST table performance problem Asya Nevra Buyuksoy 12:59
Re: Bad selectivity estimate when using a sub query to determine WHERE condition Tom Lane 15:39
Re: proposal: schema variables 📎 Pavel Stehule 18:47
Re: Bad selectivity estimate when using a sub query to determine WHERE condition Justin Pryzby 19:13

Feb. 12, 2020

Thread Author Time
Re: Writing 1100 rows per second Amol Tarte 05:28
Re: Bad selectivity estimate when using a sub query to determine WHERE condition Chris Borckholder 08:09
Re: Bad selectivity estimate when using a sub query to determine WHERE condition Chris Borckholder 08:12

Feb. 13, 2020

Thread Author Time
How to avoid UPDATE performance degradation in a transaction Karl Düüna 10:21
Re: How to avoid UPDATE performance degradation in a transaction David G. Johnston 20:50
Re: How to avoid UPDATE performance degradation in a transaction Tom Lane 21:16

Feb. 14, 2020

Thread Author Time
Re: How to avoid UPDATE performance degradation in a transaction Karl Düüna 07:14
Re: How to avoid UPDATE performance degradation in a transaction Michael Lewis 17:54

Feb. 15, 2020

Thread Author Time
Re: proposal: schema variables 📎 Pavel Stehule 08:05
Partial index creation always scans the entire table MingJu Wu 11:04
Re: Partial index creation always scans the entire table Sergei Kornilov 12:47
Re: Partial index creation always scans the entire table Justin Pryzby 12:53
Re: Partial index creation always scans the entire table Laurenz Albe 21:15

Feb. 16, 2020

Thread Author Time
Re: Partial index creation always scans the entire table Tom Lane 15:30
Re: Partial index creation always scans the entire table Justin Pryzby 15:59
Re: Partial index creation always scans the entire table Tom Lane 16:35
SubtransControlLock and performance problems Lars Aksel Opsahl 17:15

Feb. 17, 2020

Thread Author Time
RE: Partial index creation always scans the entire table Mike Sofen 00:43
Re: Partial index creation always scans the entire table Justin Pryzby 00:52
Re: Partial index creation always scans the entire table Tom Lane 01:09
Re: SubtransControlLock and performance problems Laurenz Albe 09:53
Re: SubtransControlLock and performance problems Lars Aksel Opsahl 15:03
Re: SubtransControlLock and performance problems Laurenz Albe 16:35
Re: SubtransControlLock and performance problems Pavel Stehule 18:01
Re: SubtransControlLock and performance problems Tom Lane 18:23
Re: SubtransControlLock and performance problems Pavel Stehule 18:41
Re: SubtransControlLock and performance problems Alvaro Herrera 19:10

Feb. 18, 2020

Thread Author Time
Re: SubtransControlLock and performance problems Laurenz Albe 17:27
DB running out of memory issues after upgrade Nagaraj Raj 17:46
Re: DB running out of memory issues after upgrade Tomas Vondra 17:58
Re: DB running out of memory issues after upgrade Tom Lane 18:07
Re: DB running out of memory issues after upgrade Nagaraj Raj 18:10
Re: DB running out of memory issues after upgrade Stephen Frost 18:33
Re: DB running out of memory issues after upgrade Merlin Moncure 18:38
Re: DB running out of memory issues after upgrade Justin Pryzby 18:40
Re: DB running out of memory issues after upgrade Merlin Moncure 18:49
Re: DB running out of memory issues after upgrade Nagaraj Raj 19:10
Re: SubtransControlLock and performance problems Pavel Stehule 23:46

Feb. 19, 2020

Thread Author Time
tablespace to benefit from ssd ? Nicolas PARIS 04:42
Re: tablespace to benefit from ssd ? Sebastiaan Mannem 08:02
Re: tablespace to benefit from ssd ? Laurenz Albe 10:48
Re: SubtransControlLock and performance problems Lars Aksel Opsahl 10:49
Re: tablespace to benefit from ssd ? Justin Pryzby 13:08
Re: SubtransControlLock and performance problems Alvaro Herrera 15:23

Feb. 20, 2020

Thread Author Time
Re: How to avoid UPDATE performance degradation in a transaction Andres Freund 04:35
Re: SubtransControlLock and performance problems Lars Aksel Opsahl 09:20
Re: tablespace to benefit from ssd ? Jeff Janes 17:30

Feb. 21, 2020

Thread Author Time
Can we have multiple tablespaces with in a database. Daulat Ram 05:34
Re: Can we have multiple tablespaces with in a database. amul sul 05:46
Re: Can we have multiple tablespaces with in a database. David G. Johnston 05:46
Re: Can we have multiple tablespaces with in a database. Ron 06:00
RE: Can we have multiple tablespaces with in a database. Daulat Ram 06:01
Re: Can we have multiple tablespaces with in a database. amul sul 06:18
RE: Can we have multiple tablespaces with in a database. Daulat Ram 06:23
Re: Can we have multiple tablespaces with in a database. amul sul 06:26
Re: Can we have multiple tablespaces with in a database. Christophe Pettus 06:27
RE: Can we have multiple tablespaces with in a database. Daulat Ram 06:34
RE: Can we have multiple tablespaces with in a database. Daulat Ram 06:36
Re: Can we have multiple tablespaces with in a database. Christophe Pettus 06:36
RE: Can we have multiple tablespaces with in a database. Daulat Ram 07:17
Re: Can we have multiple tablespaces with in a database. amul sul 11:50
RE: Can we have multiple tablespaces with in a database. Patrick FICHE 16:24

Feb. 22, 2020

Thread Author Time
RE: Can we have multiple tablespaces with in a database. Daulat Ram 04:45

Feb. 23, 2020

Thread Author Time
PostgreSQL 11 higher Planning time on Partitioned table Ravi Garg 09:56
Re: PostgreSQL 11 higher Planning time on Partitioned table Justin Pryzby 10:12
Re: DB running out of memory issues after upgrade Peter J. Holzer 10:19
Re: PostgreSQL 11 higher Planning time on Partitioned table Justin Pryzby 10:46
Re: PostgreSQL 11 higher Planning time on Partitioned table 📎 Ravi Garg 10:57
Re: PostgreSQL 11 higher Planning time on Partitioned table Justin Pryzby 15:10
Re: PostgreSQL 11 higher Planning time on Partitioned table Imre Samu 16:18

Feb. 24, 2020

Thread Author Time
Re: DB running out of memory issues after upgrade Merlin Moncure 16:34
Re: PostgreSQL 11 higher Planning time on Partitioned table Ravi Garg 19:40
Re: PostgreSQL 11 higher Planning time on Partitioned table Ravi Garg 19:44
LDAP with TLS is taking more time in Postgresql 11.5 Mani Sankar 19:50
Re: LDAP with TLS is taking more time in Postgresql 11.5 Adrian Klaver 20:58

Feb. 25, 2020

Thread Author Time
Re: LDAP with TLS is taking more time in Postgresql 11.5 Laurenz Albe 09:20
Re: LDAP with TLS is taking more time in Postgresql 11.5 Adrian Klaver 15:54
Connections dropping while using Postgres backend DB with Ejabberd Dipanjan Ganguly 16:28
Re: Connections dropping while using Postgres backend DB with Ejabberd Justin 17:01
Re: Connections dropping while using Postgres backend DB with Ejabberd Michael Lewis 17:20
Re: LDAP with TLS is taking more time in Postgresql 11.5 Mani Sankar 18:08
Re: LDAP with TLS is taking more time in Postgresql 11.5 Adrian Klaver 18:18
Re: LDAP with TLS is taking more time in Postgresql 11.5 Mani Sankar 18:23
Re: LDAP with TLS is taking more time in Postgresql 11.5 Adrian Klaver 18:37
Re: Connections dropping while using Postgres backend DB with Ejabberd Dipanjan Ganguly 19:16
Re: Connections dropping while using Postgres backend DB with Ejabberd Justin 19:35
Re: Connections dropping while using Postgres backend DB with Ejabberd Dipanjan Ganguly 19:53

Feb. 26, 2020

Thread Author Time
Re: LDAP with TLS is taking more time in Postgresql 11.5 Thomas Munro 01:14
Re: proposal: schema variables remi duval 14:53
much slower query in production Guillaume Cottenceau 16:17
Re: much slower query in production Justin Pryzby 16:28
Re: much slower query in production Michael Lewis 16:52
Re: much slower query in production Guillaume Cottenceau 18:02
Re: much slower query in production Guillaume Cottenceau 18:04
Re: much slower query in production Michael Lewis 18:18
Re: much slower query in production MichaelDBA@sqlexec.com 19:18
Re: much slower query in production Guillaume Cottenceau 19:37
Re: proposal: schema variables 📎 Pavel Stehule 20:40
Re: much slower query in production Jeff Janes 22:59
Re: much slower query in production Jeff Janes 23:17

Feb. 27, 2020

Thread Author Time
Re: much slower query in production Guillaume Cottenceau 08:31
Re: proposal: schema variables Pavel Stehule 14:37
RE: proposal: schema variables DUVAL REMI 14:59
Re: proposal: schema variables Pavel Stehule 15:09
Many DataFileRead - IO waits Ben Snaidero 16:33
Re: Many DataFileRead - IO waits Michael Lewis 16:54

Feb. 28, 2020

Thread Author Time
Re: Many DataFileRead - IO waits Ben Snaidero 14:01
Re: proposal: schema variables 📎 Pavel Stehule 15:30
Re: Many DataFileRead - IO waits Michael Lewis 16:40
Re: Many DataFileRead - IO waits Ben Snaidero 16:53
Re: Many DataFileRead - IO waits legrand legrand 19:00

Feb. 29, 2020

Thread Author Time
Re: proposal: schema variables 📎 Pavel Stehule 09:09
Re: Many DataFileRead - IO waits Jeff Janes 16:21

March 2, 2020

Thread Author Time
Re: Many DataFileRead - IO waits Ben Snaidero 22:31
Re: Many DataFileRead - IO waits Ben Snaidero 22:39
Re: Many DataFileRead - IO waits legrand legrand 23:09

March 5, 2020

Thread Author Time
Re: proposal: schema variables 📎 Asif Rehman 14:10
Re: proposal: schema variables 📎 Pavel Stehule 17:54

March 6, 2020

Thread Author Time
RE: proposal: schema variables DUVAL REMI 15:44
Re: proposal: schema variables 📎 Pavel Stehule 18:54

March 7, 2020

Thread Author Time
Re: proposal: schema variables 📎 Pavel Stehule 21:15

March 8, 2020

Thread Author Time
pg12 partitions show bad performance vs pg96 Mariel Cherkassky 16:05
Re: pg12 partitions show bad performance vs pg96 Mariel Cherkassky 16:14
Re: proposal: schema variables 📎 Pavel Stehule 18:12

March 9, 2020

Thread Author Time
Re: pg12 partitions show bad performance vs pg96 David Rowley 02:47
Re: pg12 partitions show bad performance vs pg96 Justin Pryzby 03:10
Re: pg12 partitions show bad performance vs pg96 Mariel Cherkassky 10:15
Re: pg12 partitions show bad performance vs pg96 Mariel Cherkassky 10:31
Re: pg12 partitions show bad performance vs pg96 Justin Pryzby 12:12
Re: pg12 partitions show bad performance vs pg96 Mariel Cherkassky 13:08
Re: pg12 partitions show bad performance vs pg96 Mariel Cherkassky 13:16
Re: pg12 partitions show bad performance vs pg96 David Rowley 21:43

March 11, 2020

Thread Author Time
Slow ext'd query via client native implementation vs. libpq & simple psql Richard Michael 19:31
Re: Slow ext'd query via client native implementation vs. libpq & simple psql Justin Pryzby 21:59
Re: Slow ext'd query via client native implementation vs. libpq & simple psql Tom Lane 22:54

March 12, 2020

Thread Author Time
Re: Slow ext'd query via client native implementation vs. libpq & simple psql Justin Pryzby 20:43

March 13, 2020

Thread Author Time
Re: proposal: schema variables 📎 Pavel Stehule 18:44

March 18, 2020

Thread Author Time
Re: proposal: schema variables 📎 Pavel Stehule 05:58

March 20, 2020

Thread Author Time
Re: proposal: schema variables 📎 Pavel Stehule 07:18
Re: proposal: schema variables 📎 Pavel Stehule 08:28

March 21, 2020

Thread Author Time
Slow planning time when public schema included (12 vs. 9.4) Anders Steinlein 12:02
Re: Slow planning time when public schema included (12 vs. 9.4) Andreas Kretschmer 13:37
Re: Slow planning time when public schema included (12 vs. 9.4) Tom Lane 14:26
Re: Slow planning time when public schema included (12 vs. 9.4) Anders Steinlein 15:45
Re: Slow planning time when public schema included (12 vs. 9.4) Anders Steinlein 15:59
Re: Slow planning time when public schema included (12 vs. 9.4) Tom Lane 19:35
Re: Slow planning time when public schema included (12 vs. 9.4) Anders Steinlein 21:13
Re: Slow planning time when public schema included (12 vs. 9.4) Tom Lane 22:55

March 22, 2020

Thread Author Time
Re: proposal: schema variables 📎 Pavel Stehule 07:40
JOIN on partitions is very slow daya airody 17:22
Re: JOIN on partitions is very slow Michael Lewis 18:08

Browse Archives

Prev | Next