pgsql-performance - April 2019

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
Jump to day: 1 2 3 4 5 8 9 10 14 15 16 17 18 19 20 21 22 23 24 28 29 30

April 1, 2019

Thread Author Time
Postgresql Sort cost Poor performance? tank.zhang 09:45
Fwd: trying to analyze deadlock Mariel Cherkassky 10:16
Re: Postgresql Sort cost Poor performance? Andrew Gierth 10:20
Re: Postgresql Sort cost Poor performance? tank.zhang 10:30
Re: Postgresql Sort cost Poor performance? Gavin Flower 10:32
Re: Postgresql Sort cost Poor performance? Christoph Berg 10:54
Re: trying to analyze deadlock Mariel Cherkassky 11:20
Re: Good afternoon. Rafia Sabih 13:03
Re: LIMIT OFFSET with DB view vs plain SQL Raj Gandhi 13:56

April 2, 2019

Thread Author Time
Re: LIMIT OFFSET with DB view vs plain SQL Raj Gandhi 02:06
Re: LIMIT OFFSET with DB view vs plain SQL SAMEER KUMAR 04:16
Re: LIMIT OFFSET with DB view vs plain SQL Ramón Bastidas 04:49
Re: Good afternoon. Ramón Bastidas 05:03
Re: Postgresql Sort cost Poor performance? Ramón Bastidas 05:25
Re: Postgresql Sort cost Poor performance? tank.zhang 07:00
Re: Postgresql Sort cost Poor performance? David Rowley 07:42
Re: Postgresql Sort cost Poor performance? tank.zhang 08:23
[No subject] Mariel Cherkassky 08:32
Re: parallel query Laurenz Albe 11:28
Re: trying to analyze deadlock Shreeyansh Dba 12:21
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 18:02

April 3, 2019

Thread Author Time
Commit(?) overhead Duncan Kinnear 21:59

April 4, 2019

Thread Author Time
RAM usage of PostgreSql Prasad 14:48
Re: Commit(?) overhead Jeff Janes 15:14
monitoring options for postgresql under AWS/RDS? Mamet, Eric (GfK) 16:28
Re: monitoring options for postgresql under AWS/RDS? Justin Pryzby 17:43
Re: RAM usage of PostgreSql Justin Pryzby 17:46
Re: monitoring options for postgresql under AWS/RDS? Rijo Roy 18:03
Re: RAM usage of PostgreSql Laurenz Albe 18:08
Re: RAM usage of PostgreSql Keith 18:09

April 5, 2019

Thread Author Time
RE: monitoring options for postgresql under AWS/RDS? Mamet, Eric (GfK) 09:46
Re: monitoring options for postgresql under AWS/RDS? Praveen Duraiswami 12:57

April 8, 2019

Thread Author Time
Oracle to postgres migration Daulat Ram 10:23
Re: Oracle to postgres migration Julien Rouhaud 12:04
Re: Oracle to postgres migration Rick Otten 12:24
Planning performance problem (67626.278ms) Krzysztof Plocharz 14:10
RE: Planning performance problem (67626.278ms) Igor Neyman 14:18
Re: Planning performance problem (67626.278ms) Krzysztof Plocharz 14:28
Re: Planning performance problem (67626.278ms) Pavel Stehule 14:33
Re: Planning performance problem (67626.278ms) Justin Pryzby 14:42
Re: Planning performance problem (67626.278ms) Krzysztof Plocharz 14:55
Re: Planning performance problem (67626.278ms) Krzysztof Plocharz 14:58
Re: Planning performance problem (67626.278ms) Pavel Stehule 15:07
Block / Page Size Optimization Gunther 15:09
Re: Block / Page Size Optimization Andres Freund 16:28
Re: Oracle to postgres migration phb07 17:45
Re: Oracle to postgres migration legrand legrand 20:02
Re: Planning performance problem (67626.278ms) Justin Pryzby 22:10
Re: Oracle to postgres migration Gavin Flower 22:31
Re: Oracle to postgres migration David G. Johnston 22:42
Re: Planning performance problem (67626.278ms) Jeremy Schneider 23:10
Re: Planning performance problem (67626.278ms) Andres Freund 23:26

April 9, 2019

Thread Author Time
Re: Commit(?) overhead Duncan Kinnear 21:26
Re: Commit(?) overhead Justin Pryzby 22:12
Re: Commit(?) overhead Andres Freund 22:23
Re: Commit(?) overhead Duncan Kinnear 22:42

April 10, 2019

Thread Author Time
PostgreSQL upgrade. Daulat Ram 05:40
Re: Commit(?) overhead Laurenz Albe 08:16
Re: PostgreSQL upgrade. Andreas Kretschmer 08:20

April 14, 2019

Thread Author Time
Out of Memory errors are frustrating as heck! Gunther 20:23
Re: Out of Memory errors are frustrating as heck! Tom Lane 21:19
Re: Out of Memory errors are frustrating as heck! Jeff Janes 21:19

April 15, 2019

Thread Author Time
Re: Out of Memory errors are frustrating as heck! Gunther 01:05
Re: Out of Memory errors are frustrating as heck! Peter 01:29
Re: Out of Memory errors are frustrating as heck! Justin Pryzby 01:48
Re: PostgreSQL upgrade. Mark Kirkwood 02:26
Re: Out of Memory errors are frustrating as heck! Jeff Janes 02:48
Re: Out of Memory errors are frustrating as heck! Gunther 03:04
Re: Out of Memory errors are frustrating as heck! Tom Lane 03:24
Re: Out of Memory errors are frustrating as heck! Gunther 03:59
Re: Out of Memory errors are frustrating as heck! Justin Pryzby 04:15
Re: Out of Memory errors are frustrating as heck! Jeff Janes 13:32
Re: Out of Memory errors are frustrating as heck! Jeff Janes 13:44
iscsi performance Mahmoud Moharam 15:02
Re: Out of Memory errors are frustrating as heck! Tomas Vondra 15:26
Re: Out of Memory errors are frustrating as heck! Tom Lane 15:28
Re: Out of Memory errors are frustrating as heck! Tomas Vondra 15:38
Re: Out of Memory errors are frustrating as heck! Tom Lane 15:53
Re: Block / Page Size Optimization Tomas Vondra 16:19
Re: Out of Memory errors are frustrating as heck! Gunther 16:34
Re: Out of Memory errors are frustrating as heck! Jeff Janes 16:51
Re: Out of Memory errors are frustrating as heck! Tom Lane 17:32
Re: Out of Memory errors are frustrating as heck! 📎 Alvaro Herrera 17:38
Re: Out of Memory errors are frustrating as heck! Tom Lane 17:45
Re: Out of Memory errors are frustrating as heck! Jeff Janes 18:14

April 16, 2019

Thread Author Time
Re: Out of Memory errors are frustrating as heck! Gunther 01:49
Re: PostgreSQL upgrade. 📎 Mark Kirkwood 02:08
Re: Out of Memory errors are frustrating as heck! Tom Lane 02:28
Re: Out of Memory errors are frustrating as heck! Alvaro Herrera 02:39
Re: Out of Memory errors are frustrating as heck! Gunther 02:39
Re: Out of Memory errors are frustrating as heck! Tom Lane 02:50
Re: Out of Memory errors are frustrating as heck! Tom Lane 03:03
Re: Out of Memory errors are frustrating as heck! Gunther 05:23
Re: Out of Memory errors are frustrating as heck! Gunther 06:33
Re: Out of Memory errors are frustrating as heck! Tom Lane 15:30
Postgres backup & restore Daulat Ram 17:41
Re: Postgres backup & restore Justin Pryzby 17:54
Re: Out of Memory errors are frustrating as heck! Jeff Janes 19:28
Re: Out of Memory errors are frustrating as heck! Tom Lane 19:43
Re: Out of Memory errors are frustrating as heck! Gavin Flower 22:39

April 17, 2019

Thread Author Time
Re: Out of Memory errors are frustrating as heck! Gunther 02:24
Re: Out of Memory errors are frustrating as heck! Justin Pryzby 04:46
Re: Out of Memory errors are frustrating as heck! Jean-David Beyer 06:01
Pg10 : Client Configuration for Parallelism ? laurent.dechambe 06:30
Re: Out of Memory errors are frustrating as heck! Gavin Flower 07:53
Re: Pg10 : Client Configuration for Parallelism ? Andreas Kretschmer 08:07
Re: Pg10 : Client Configuration for Parallelism ? Thomas Kellerer 08:33
Sv: Pg10 : Client Configuration for Parallelism ? Andreas Joseph Krogh 09:07
RE: Pg10 : Client Configuration for Parallelism ? laurent.dechambe 09:22
RE: Pg10 : Client Configuration for Parallelism ? laurent.dechambe 09:51
Re: Pg10 : Client Configuration for Parallelism ? Andreas Kretschmer 10:38
RE: Pg10 : Client Configuration for Parallelism ? laurent.dechambe 11:26
Re: Pg10 : Client Configuration for Parallelism ? Gunther Schadow 11:55
Re: Pg10 : Client Configuration for Parallelism ? Gunther Schadow 11:58
RE: Pg10 : Client Configuration for Parallelism ? laurent.dechambe 12:56
Re: Pg10 : Client Configuration for Parallelism ? Justin Pryzby 13:57
RE: Pg10 : Client Configuration for Parallelism ? laurent.dechambe 14:33
Re: Pg10 : Client Configuration for Parallelism ? Laurenz Albe 17:11
Re: Block / Page Size Optimization Bruce Momjian 20:14
Best Filesystem for PostgreSQL Stephan Schmidt 20:59
Re: Best Filesystem for PostgreSQL Bruce Momjian 21:07
Re: Best Filesystem for PostgreSQL Imre Samu 22:03
Re: Best Filesystem for PostgreSQL Gunther Schadow 22:38

April 18, 2019

Thread Author Time
AW: Best Filesystem for PostgreSQL Stephan Schmidt 02:19
Re: Out of Memory errors are frustrating as heck! Gunther 03:52
Fwd: iscsi performance Mahmoud Moharam 06:15
Re: Out of Memory errors are frustrating as heck! Tomas Vondra 15:21
Re: Best Filesystem for PostgreSQL Tomas Vondra 15:33
Re: Best Filesystem for PostgreSQL Robert Blayzor 18:11

April 19, 2019

Thread Author Time
Re: [HACKERS] proposal: schema variables 📎 Pavel Stehule 06:32
Re: Pg10 : Client Configuration for Parallelism ? Thomas Kellerer 06:52
Re: Pg10 : Client Configuration for Parallelism ? Tom Lane 13:43
Re: Out of Memory errors are frustrating as heck! Gaetano Mendola 20:28
Re: Out of Memory errors are frustrating as heck! Justin Pryzby 21:01

April 20, 2019

Thread Author Time
Re: Out of Memory errors are frustrating as heck! Gunther 03:34
Re: Out of Memory errors are frustrating as heck! Jeremy Schneider 05:54
Re: Out of Memory errors are frustrating as heck! Justin Pryzby 07:52
Re: Out of Memory errors are frustrating as heck! Justin Pryzby 10:53
Backup and Restore (pg_dump & pg_restore) Daulat Ram 18:50
Re: Out of Memory errors are frustrating as heck! 📎 Justin Pryzby 19:30
Re: Out of Memory errors are frustrating as heck! Gunther 20:00
Re: Out of Memory errors are frustrating as heck! 📎 Tomas Vondra 20:01
Re: Out of Memory errors are frustrating as heck! Tomas Vondra 20:11
Re: Out of Memory errors are frustrating as heck! Tom Lane 20:26
Re: Out of Memory errors are frustrating as heck! Tomas Vondra 20:36
Re: Out of Memory errors are frustrating as heck! Tom Lane 20:46
Re: Out of Memory errors are frustrating as heck! Tom Lane 20:47
Re: Out of Memory errors are frustrating as heck! Tomas Vondra 20:53
Re: Out of Memory errors are frustrating as heck! 📎 Tomas Vondra 21:13
Re: Out of Memory errors are frustrating as heck! Justin Pryzby 21:45
Re: Out of Memory errors are frustrating as heck! Tom Lane 22:20
Re: Out of Memory errors are frustrating as heck! Tomas Vondra 23:46

April 21, 2019

Thread Author Time
Re: Out of Memory errors are frustrating as heck! Gunther 00:33
Re: Out of Memory errors are frustrating as heck! Tomas Vondra 01:14
Re: Out of Memory errors are frustrating as heck! Gunther 05:03
Re: Out of Memory errors are frustrating as heck! Gunther 05:31
Re: Out of Memory errors are frustrating as heck! 📎 Justin Pryzby 08:08
Re: Out of Memory errors are frustrating as heck! Justin Pryzby 10:19
Re: Out of Memory errors are frustrating as heck! 📎 Tomas Vondra 11:46
Re: Out of Memory errors are frustrating as heck! Jeff Janes 13:05
Re: Out of Memory errors are frustrating as heck! Tom Lane 14:36
Re: Out of Memory errors are frustrating as heck! Tomas Vondra 16:15
Re: Backup and Restore (pg_dump & pg_restore) Tomas Vondra 16:18
Backup and Restore (pg_dump & pg_restore) Daulat Ram 16:35
Re: Out of Memory errors are frustrating as heck! 📎 Justin Pryzby 16:40
Re: Backup and Restore (pg_dump & pg_restore) Adrian Klaver 18:46
Re: Backup and Restore (pg_dump & pg_restore) Tom Lane 19:25
Re: Backup and Restore (pg_dump & pg_restore) Ron 20:42
Re: Backup and Restore (pg_dump & pg_restore) Adrian Klaver 20:58
Re: Backup and Restore (pg_dump & pg_restore) Ron 21:20
Re: Backup and Restore (pg_dump & pg_restore) Adrian Klaver 22:13
Re: Out of Memory errors are frustrating as heck! Tom Lane 23:07
Re: Out of Memory errors are frustrating as heck! Gunther 23:25
Re: Out of Memory errors are frustrating as heck! Tomas Vondra 23:51
Re: Out of Memory errors are frustrating as heck! Gunther 23:58

April 22, 2019

Thread Author Time
Re: Out of Memory errors are frustrating as heck! Gunther 00:55
Re: Out of Memory errors are frustrating as heck! 📎 Tomas Vondra 03:09
Re: Out of Memory errors are frustrating as heck! Gaetano Mendola 08:07
Re: Out of Memory errors are frustrating as heck! Tomas Vondra 13:04
Re: Out of Memory errors are frustrating as heck! Jeff Janes 17:15
Re: Out of Memory errors are frustrating as heck! Tom Lane 17:57

April 23, 2019

Thread Author Time
Re: Out of Memory errors are frustrating as heck! Gunther 20:37
Re: Out of Memory errors are frustrating as heck! Justin Pryzby 20:43
Re: Out of Memory errors are frustrating as heck! Tomas Vondra 21:46
Re: Out of Memory errors are frustrating as heck! Tomas Vondra 21:59
Re: Out of Memory errors are frustrating as heck! Gunther 23:09

April 24, 2019

Thread Author Time
Re: Out of Memory errors are frustrating as heck! Tomas Vondra 00:36

April 28, 2019

Thread Author Time
Re: Out of Memory errors are frustrating as heck! 📎 Tomas Vondra 14:19

April 29, 2019

Thread Author Time
Generic Plans for Prepared Statement are 158155 times slower than Custom Plans Naik, Sameer 10:36
Re: Generic Plans for Prepared Statement are 158155 times slower than Custom Plans Bruce Momjian 13:36
Re: Generic Plans for Prepared Statement are 158155 times slower than Custom Plans Tom Lane 14:35
Re: Generic Plans for Prepared Statement are 158155 times slower than Custom Plans Andres Freund 16:23
Re: Generic Plans for Prepared Statement are 158155 times slower than Custom Plans Tom Lane 16:51

April 30, 2019

Thread Author Time
RE: Re: Generic Plans for Prepared Statement are 158155 times slower than Custom Plans Naik, Sameer 04:58
Failure to reordering in case of a lateral join in combination with a left join (not inner join) resulting in suboptimal nested loop plan Peter Billen 18:57
Re: Failure to reordering in case of a lateral join in combination with a left join (not inner join) resulting in suboptimal nested loop plan Tom Lane 20:38

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 8 9 10 14 15 16 17 18 19 20 21 22 23 24 28 29 30