Mailing lists [pgsql-performance]

1 April 2019

• 12:45   Postgresql Sort cost Poor performance? tank.zhang
• 13:20   Re: Postgresql Sort cost Poor performance? Andrew Gierth
• 13:30   Re: Postgresql Sort cost Poor performance? tank.zhang
• 13:32   Re: Postgresql Sort cost Poor performance? Gavin Flower
• 13:54   Re: Postgresql Sort cost Poor performance? Christoph Berg
• 14:20   Re: trying to analyze deadlock Mariel Cherkassky
• 16:03   Re: Good afternoon. Rafia Sabih

2 April 2019

• 08:03   Re: Good afternoon. Ramón Bastidas
• 08:25   Re: Postgresql Sort cost Poor performance? Ramón Bastidas
• 10:00   Re: Postgresql Sort cost Poor performance? tank.zhang
• 10:42   Re: Postgresql Sort cost Poor performance? David Rowley
• 11:23   Re: Postgresql Sort cost Poor performance? tank.zhang
• 11:32    Mariel Cherkassky
• 14:28   Re: parallel query Laurenz Albe

4 April 2019

• 00:59   Commit(?) overhead Duncan Kinnear
• 18:14   Re: Commit(?) overhead Jeff Janes
• 19:28   monitoring options for postgresql under AWS/RDS? Mamet, Eric (GfK)
• 20:43   Re: monitoring options for postgresql under AWS/RDS? Justin Pryzby
• 20:46   Re: RAM usage of PostgreSql Justin Pryzby
• 21:03   Re: monitoring options for postgresql under AWS/RDS? Rijo Roy

5 April 2019

• 12:46   RE: monitoring options for postgresql under AWS/RDS? Mamet, Eric (GfK)
• 15:57   Re: monitoring options for postgresql under AWS/RDS? Praveen Duraiswami

8 April 2019

• 13:23   Oracle to postgres migration Daulat Ram
• 15:04   Re: Oracle to postgres migration Julien Rouhaud
• 15:24   Re: Oracle to postgres migration Rick Otten
• 17:10   Planning performance problem (67626.278ms) Krzysztof Plocharz
• 17:18   RE: Planning performance problem (67626.278ms) Igor Neyman
• 17:28   Re: Planning performance problem (67626.278ms) Krzysztof Plocharz
• 17:33   Re: Planning performance problem (67626.278ms) Pavel Stehule
• 17:42   Re: Planning performance problem (67626.278ms) Justin Pryzby
• 17:55   Re: Planning performance problem (67626.278ms) Krzysztof Plocharz
• 17:58   Re: Planning performance problem (67626.278ms) Krzysztof Plocharz
• 18:07   Re: Planning performance problem (67626.278ms) Pavel Stehule
• 18:09   Block / Page Size Optimization Gunther
• 19:28   Re: Block / Page Size Optimization Andres Freund
• 20:45   Re: Oracle to postgres migration phb07
• 23:02   Re: Oracle to postgres migration legrand legrand

9 April 2019

• 01:10   Re: Planning performance problem (67626.278ms) Justin Pryzby
• 01:31   Re: Oracle to postgres migration Gavin Flower
• 01:42   Re: Oracle to postgres migration David G. Johnston
• 02:10   Re: Planning performance problem (67626.278ms) Jeremy Schneider
• 02:26   Re: Planning performance problem (67626.278ms) Andres Freund

10 April 2019

• 00:26   Re: Commit(?) overhead Duncan Kinnear
• 01:12   Re: Commit(?) overhead Justin Pryzby
• 01:23   Re: Commit(?) overhead Andres Freund
• 01:42   Re: Commit(?) overhead Duncan Kinnear
• 08:40   PostgreSQL upgrade. Daulat Ram
• 11:16   Re: Commit(?) overhead Laurenz Albe
• 11:20   Re: PostgreSQL upgrade. Andreas Kretschmer

14 April 2019

• 23:23   Out of Memory errors are frustrating as heck! Gunther

15 April 2019

• 00:19   Re: Out of Memory errors are frustrating as heck! Tom Lane
• 00:19   Re: Out of Memory errors are frustrating as heck! Jeff Janes
• 04:05   Re: Out of Memory errors are frustrating as heck! Gunther
• 04:29   Re: Out of Memory errors are frustrating as heck! Peter
• 04:48   Re: Out of Memory errors are frustrating as heck! Justin Pryzby
• 05:26   Re: PostgreSQL upgrade. Mark Kirkwood
• 05:48   Re: Out of Memory errors are frustrating as heck! Jeff Janes
• 06:04   Re: Out of Memory errors are frustrating as heck! Gunther
• 06:24   Re: Out of Memory errors are frustrating as heck! Tom Lane
• 06:59   Re: Out of Memory errors are frustrating as heck! Gunther
• 07:15   Re: Out of Memory errors are frustrating as heck! Justin Pryzby
• 16:32   Re: Out of Memory errors are frustrating as heck! Jeff Janes
• 16:44   Re: Out of Memory errors are frustrating as heck! Jeff Janes
• 18:26   Re: Out of Memory errors are frustrating as heck! Tomas Vondra
• 18:28   Re: Out of Memory errors are frustrating as heck! Tom Lane
• 18:38   Re: Out of Memory errors are frustrating as heck! Tomas Vondra
• 18:53   Re: Out of Memory errors are frustrating as heck! Tom Lane
• 19:19   Re: Block / Page Size Optimization Tomas Vondra
• 19:34   Re: Out of Memory errors are frustrating as heck! Gunther
• 19:51   Re: Out of Memory errors are frustrating as heck! Jeff Janes
• 20:32   Re: Out of Memory errors are frustrating as heck! Tom Lane
• 20:38   Re: Out of Memory errors are frustrating as heck! Alvaro Herrera
• 20:45   Re: Out of Memory errors are frustrating as heck! Tom Lane
• 21:14   Re: Out of Memory errors are frustrating as heck! Jeff Janes

16 April 2019

• 04:49   Re: Out of Memory errors are frustrating as heck! Gunther
• 05:08   Re: PostgreSQL upgrade. Mark Kirkwood
• 05:28   Re: Out of Memory errors are frustrating as heck! Tom Lane
• 05:39   Re: Out of Memory errors are frustrating as heck! Alvaro Herrera
• 05:39   Re: Out of Memory errors are frustrating as heck! Gunther
• 05:50   Re: Out of Memory errors are frustrating as heck! Tom Lane
• 06:03   Re: Out of Memory errors are frustrating as heck! Tom Lane
• 08:23   Re: Out of Memory errors are frustrating as heck! Gunther
• 09:33   Re: Out of Memory errors are frustrating as heck! Gunther
• 18:30   Re: Out of Memory errors are frustrating as heck! Tom Lane
• 20:41   Postgres backup & restore Daulat Ram
• 20:54   Re: Postgres backup & restore Justin Pryzby
• 22:28   Re: Out of Memory errors are frustrating as heck! Jeff Janes
• 22:43   Re: Out of Memory errors are frustrating as heck! Tom Lane

17 April 2019

• 01:39   Re: Out of Memory errors are frustrating as heck! Gavin Flower
• 05:24   Re: Out of Memory errors are frustrating as heck! Gunther
• 07:46   Re: Out of Memory errors are frustrating as heck! Justin Pryzby
• 09:01   Re: Out of Memory errors are frustrating as heck! Jean-David Beyer
• 09:30   Pg10 : Client Configuration for Parallelism ? 
• 10:53   Re: Out of Memory errors are frustrating as heck! Gavin Flower
• 11:07   Re: Pg10 : Client Configuration for Parallelism ? Andreas Kretschmer
• 11:33   Re: Pg10 : Client Configuration for Parallelism ? Thomas Kellerer
• 12:07   Sv: Pg10 : Client Configuration for Parallelism ? Andreas Joseph Krogh
• 12:22   RE: Pg10 : Client Configuration for Parallelism ? 
• 12:51   RE: Pg10 : Client Configuration for Parallelism ? 
• 13:38   Re: Pg10 : Client Configuration for Parallelism ? Andreas Kretschmer
• 14:26   RE: Pg10 : Client Configuration for Parallelism ? 
• 14:55   Re: Pg10 : Client Configuration for Parallelism ? Gunther Schadow
• 14:58   Re: Pg10 : Client Configuration for Parallelism ? Gunther Schadow
• 15:56   RE: Pg10 : Client Configuration for Parallelism ? 
• 16:57   Re: Pg10 : Client Configuration for Parallelism ? Justin Pryzby
• 17:33   RE: Pg10 : Client Configuration for Parallelism ? 
• 20:11   Re: Pg10 : Client Configuration for Parallelism ? Laurenz Albe
• 23:14   Re: Block / Page Size Optimization Bruce Momjian
• 23:59   Best Filesystem for PostgreSQL  Stephan Schmidt

18 April 2019

• 00:07   Re: Best Filesystem for PostgreSQL Bruce Momjian
• 01:03   Re: Best Filesystem for PostgreSQL Imre Samu
• 01:38   Re: Best Filesystem for PostgreSQL Gunther Schadow
• 05:19   AW: Best Filesystem for PostgreSQL Stephan Schmidt
• 06:52   Re: Out of Memory errors are frustrating as heck! Gunther
• 09:15   Fwd: iscsi performance Mahmoud Moharam
• 18:21   Re: Out of Memory errors are frustrating as heck! Tomas Vondra
• 18:33   Re: Best Filesystem for PostgreSQL Tomas Vondra
• 21:11   Re: Best Filesystem for PostgreSQL Robert Blayzor

19 April 2019

• 09:52   Re: Pg10 : Client Configuration for Parallelism ? Thomas Kellerer
• 16:43   Re: Pg10 : Client Configuration for Parallelism ? Tom Lane
• 23:28   Re: Out of Memory errors are frustrating as heck! Gaetano Mendola

20 April 2019

• 00:01   Re: Out of Memory errors are frustrating as heck! Justin Pryzby
• 06:34   Re: Out of Memory errors are frustrating as heck! Gunther
• 08:54   Re: Out of Memory errors are frustrating as heck! Jeremy Schneider
• 10:52   Re: Out of Memory errors are frustrating as heck! Justin Pryzby
• 13:53   Re: Out of Memory errors are frustrating as heck! Justin Pryzby
• 21:50   Backup and Restore (pg_dump & pg_restore) Daulat Ram
• 22:30   Re: Out of Memory errors are frustrating as heck! Justin Pryzby
• 23:00   Re: Out of Memory errors are frustrating as heck! Gunther
• 23:01   Re: Out of Memory errors are frustrating as heck! Tomas Vondra
• 23:11   Re: Out of Memory errors are frustrating as heck! Tomas Vondra
• 23:26   Re: Out of Memory errors are frustrating as heck! Tom Lane
• 23:36   Re: Out of Memory errors are frustrating as heck! Tomas Vondra
• 23:46   Re: Out of Memory errors are frustrating as heck! Tom Lane
• 23:47   Re: Out of Memory errors are frustrating as heck! Tom Lane
• 23:53   Re: Out of Memory errors are frustrating as heck! Tomas Vondra

21 April 2019

• 00:13   Re: Out of Memory errors are frustrating as heck! Tomas Vondra
• 00:45   Re: Out of Memory errors are frustrating as heck! Justin Pryzby
• 01:20   Re: Out of Memory errors are frustrating as heck! Tom Lane
• 02:46   Re: Out of Memory errors are frustrating as heck! Tomas Vondra
• 03:33   Re: Out of Memory errors are frustrating as heck! Gunther
• 04:14   Re: Out of Memory errors are frustrating as heck! Tomas Vondra
• 08:03   Re: Out of Memory errors are frustrating as heck! Gunther
• 08:31   Re: Out of Memory errors are frustrating as heck! Gunther
• 11:08   Re: Out of Memory errors are frustrating as heck! Justin Pryzby
• 13:19   Re: Out of Memory errors are frustrating as heck! Justin Pryzby
• 14:46   Re: Out of Memory errors are frustrating as heck! Tomas Vondra
• 16:05   Re: Out of Memory errors are frustrating as heck! Jeff Janes
• 17:36   Re: Out of Memory errors are frustrating as heck! Tom Lane
• 19:15   Re: Out of Memory errors are frustrating as heck! Tomas Vondra
• 19:18   Re: Backup and Restore (pg_dump & pg_restore) Tomas Vondra
• 19:40   Re: Out of Memory errors are frustrating as heck! Justin Pryzby

22 April 2019

• 02:07   Re: Out of Memory errors are frustrating as heck! Tom Lane
• 02:25   Re: Out of Memory errors are frustrating as heck! Gunther
• 02:51   Re: Out of Memory errors are frustrating as heck! Tomas Vondra
• 02:58   Re: Out of Memory errors are frustrating as heck! Gunther
• 03:55   Re: Out of Memory errors are frustrating as heck! Gunther
• 06:09   Re: Out of Memory errors are frustrating as heck! Tomas Vondra
• 11:07   Re: Out of Memory errors are frustrating as heck! Gaetano Mendola
• 16:04   Re: Out of Memory errors are frustrating as heck! Tomas Vondra
• 20:15   Re: Out of Memory errors are frustrating as heck! Jeff Janes
• 20:57   Re: Out of Memory errors are frustrating as heck! Tom Lane

23 April 2019

• 23:37   Re: Out of Memory errors are frustrating as heck! Gunther
• 23:43   Re: Out of Memory errors are frustrating as heck! Justin Pryzby

24 April 2019

• 00:46   Re: Out of Memory errors are frustrating as heck! Tomas Vondra
• 00:59   Re: Out of Memory errors are frustrating as heck! Tomas Vondra
• 02:09   Re: Out of Memory errors are frustrating as heck! Gunther
• 03:36   Re: Out of Memory errors are frustrating as heck! Tomas Vondra

28 April 2019

• 17:19   Re: Out of Memory errors are frustrating as heck! Tomas Vondra

29 April 2019

• 13:36   Generic Plans for Prepared Statement are 158155 times slower thanCustom Plans Naik, Sameer
• 16:36   Re: Generic Plans for Prepared Statement are 158155 times slowerthan Custom Plans Bruce Momjian
• 17:35   Re: Generic Plans for Prepared Statement are 158155 times slower than Custom Plans Tom Lane
• 19:23   Re: Generic Plans for Prepared Statement are 158155 times slowerthan Custom Plans Andres Freund
• 19:51   Re: Generic Plans for Prepared Statement are 158155 times slower than Custom Plans Tom Lane

30 April 2019

• 07:58   RE: Re: Generic Plans for Prepared Statement are 158155 times slower thanCustom Plans Naik, Sameer
• 21:57   Failure to reordering in case of a lateral join in combination with aleft join (not inner join) resulting in suboptimal nested loop plan Peter Billen
• 23:38   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