pgsql-performance since 2020-02-17 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

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 [email protected] 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

March 23, 2020

Thread Author Time
Partitions to improve write/update speed for tables with indexes? Arya F 01:22
Re: Partitions to improve write/update speed for tables with indexes? Justin Pryzby 01:29
Partition Pruning (Hash Partitions) Support for DELETEs in PostgreSQL 11 and 12 Ronnie S 03:45
Re: Partition Pruning (Hash Partitions) Support for DELETEs in PostgreSQL 11 and 12 Justin Pryzby 04:10
Re: JOIN on partitions is very slow daya airody 07:40
Re: Partition Pruning (Hash Partitions) Support for DELETEs in PostgreSQL 11 and 12 Ronnie S 14:18
Re: JOIN on partitions is very slow Michael Lewis 16:16
Re: JOIN on partitions is very slow Thomas Kellerer 16:33

March 24, 2020

Thread Author Time
Random function Luis Roberto Weck 18:10
Re: Random function Tom Lane 18:33
Re: Random function David G. Johnston 18:33
Re: Slow planning time when public schema included (12 vs. 9.4) Anders Steinlein 22:55

March 27, 2020

Thread Author Time
Best way to delete big amount of records from big table Ekaterina Amez 14:13
Re: Best way to delete big amount of records from big table Michael Lewis 14:41
Re: Best way to delete big amount of records from big table Laurenz Albe 14:46
Re: Best way to delete big amount of records from big table Ekaterina Amez 14:55
Re: Best way to delete big amount of records from big table Ekaterina Amez 14:56
Re: Best way to delete big amount of records from big table Rick Otten 15:03
Re: Best way to delete big amount of records from big table Justin Pryzby 15:09
Re: Best way to delete big amount of records from big table Ekaterina Amez 15:15
Re: JOIN on partitions is very slow daya airody 15:24

March 28, 2020

Thread Author Time
Re: Best way to delete big amount of records from big table Laurenz Albe 04:32

March 30, 2020

Thread Author Time
Increasing work_mem slows down query, why? Silvio Moioli 06:47
Re: Increasing work_mem slows down query, why? Pavel Stehule 06:56
Re: Increasing work_mem slows down query, why? Silvio Moioli 08:12
Re: Increasing work_mem slows down query, why? Pavel Stehule 10:12
Re: Increasing work_mem slows down query, why? Silvio Moioli 13:09
Re: Increasing work_mem slows down query, why? Pavel Stehule 13:33
Re: Increasing work_mem slows down query, why? Pavel Stehule 13:40
Re: Increasing work_mem slows down query, why? Tom Lane 16:02
Re: Increasing work_mem slows down query, why? Pavel Stehule 16:18
Re: Increasing work_mem slows down query, why? Tom Lane 16:36
Re: Increasing work_mem slows down query, why? Pavel Stehule 16:49

April 2, 2020

Thread Author Time
BUG #16334: We recently upgraded PG version from 9.5 to 10.10 and system performance is not so good PG Bug reporting form 03:52
Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10 and system performance is not so good Julien Rouhaud 08:46
Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10 and system performance is not so good Tejaswini GC 10:22
Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10 and system performance is not so good Julien Rouhaud 11:04
Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10 and system performance is not so good Tejaswini GC 11:09
Could someone please help us share the procedure to troubleshoot the locks on proc issues. 📎 postgann2020 s 19:37
Re: Could someone please help us share the procedure to troubleshoot the locks on proc issues. Adrian Klaver 23:00

April 3, 2020

Thread Author Time
Re: Could someone please help us share the procedure to troubleshoot the locks on proc issues. postgann2020 s 05:11
slow query dangal 16:03
Re: slow query Justin Pryzby 16:07
Re: slow query dangal 16:18
Re: Increasing work_mem slows down query, why? Silvio Moioli 21:46

April 4, 2020

Thread Author Time
Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10 and system performance is not so good Tejaswini GC 06:27
Re: BUG #16334: We recently upgraded PG version from 9.5 to 10.10 and system performance is not so good Julien Rouhaud 07:06

April 5, 2020

Thread Author Time
Postgresql 12, 512 partition by hash. Slow select Arya F 17:48
Re: Postgresql 12, 512 partition by hash. Slow select Andreas Kretschmer 18:41
Re: Postgresql 12, 512 partition by hash. Slow select Tom Lane 18:55
Re: Postgresql 12, 512 partition by hash. Slow select Arya F 19:50
Re: Postgresql 12, 512 partition by hash. Slow select Neil 20:48

April 6, 2020

Thread Author Time
Postgres not using index on views Rick Vincent 14:19

April 7, 2020

Thread Author Time
Re: Postgres not using index on views Justin Pryzby 04:59
Re: Postgres not using index on views Tom Lane 05:09
Re: Postgres not using index on views Laurenz Albe 06:42
RE: Postgres not using index on views Rick Vincent 07:53
RE: Postgres not using index on views Rick Vincent 09:08
Re: Postgres not using index on views Thomas Kellerer 09:18
Re: Postgres not using index on views Thomas Kellerer 09:24
Re: slow query Michael Christofides 10:20
PostgreSQL DBA consulting daya airody 11:50
Re: PostgreSQL DBA consulting Justin Pryzby 11:56

April 9, 2020

Thread Author Time
High insert rate server, unstable insert latency and load peaks with buffer_content and XidGenLock LWlocks with Postgresql 12 version Maxim Boguk 14:51
Re: High insert rate server, unstable insert latency and load peaks with buffer_content and XidGenLock LWlocks with Postgresql 12 version Justin Pryzby 15:16
Re: High insert rate server, unstable insert latency and load peaks with buffer_content and XidGenLock LWlocks with Postgresql 12 version Maxim Boguk 15:29

Browse Archives

Prev | Next