Re: [GENERAL] problem with lost connection while running long PL/R query

2013-05-17 Thread David M. Kaplan
Conway wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 05/16/2013 08:40 AM, Tom Lane wrote: "David M. Kaplan" writes: Thanks for the help. You have definitely identified the problem, but I am still looking for a solution that works for me. I tried setting vm.overcommit_mem

Re: [GENERAL] problem with lost connection while running long PL/R query

2013-05-17 Thread David M. Kaplan
0 AM, Tom Lane wrote: "David M. Kaplan" writes: Thanks for the help. You have definitely identified the problem, but I am still looking for a solution that works for me. I tried setting vm.overcommit_memory=2, but this just made the query crash quicker than before, though without killin

Re: [GENERAL] problem with lost connection while running long PL/R query

2013-05-16 Thread David M. Kaplan
time? I imagine I could do this using PL/PGSQL and iteration, but perhaps there is a postgresql configuration parameter that can help with this? Thanks again, David On 05/16/2013 03:35 PM, Ryan Kelly wrote: On Thu, May 05/16/13, 2013 at 02:47:28PM +0200, David M. Kaplan wrote: Hi, I have a

[GENERAL] problem with lost connection while running long PL/R query

2013-05-16 Thread David M. Kaplan
, David -- ** David M. Kaplan Charge de Recherche 1 Institut de Recherche pour le Developpement Centre de Recherche Halieutique Mediterraneenne et Tropicale av. Jean Monnet B.P. 171 34203 Sete cedex France Phone: +33 (0)4 99 57 32 27 Fax: +33 (0)4 99 57 32 95 http