On Thu, May 05/16/13, 2013 at 02:47:28PM +0200, David M. Kaplan wrote: > Hi, > > I have a query that uses a PL/R function to run a statistical model > on data in a postgresql table. The query runs the function 4 times, > each of which generates about 2 million lines of results, generating > a final table that has about 8 million lines. Each time the > function is called, it takes about ~3-5 minutes to finish its work. > I know that the function is running fine as it gives me progress and > I have had no trouble using it on slightly smaller datasets. > However, this time it does the 4 runs, but ends with psql saying the > connection to the server has been lost. In the postgresql log file, > I have: > > 2013-05-16 14:05:47 CEST LOG: server process (PID 27488) was terminated by signal 9: Killed This usually indicates the OOM killer has killed your backend. Please see the documentation here: http://www.postgresql.org/docs/9.2/interactive/kernel-resources.html#LINUX-MEMORY-OVERCOMMIT -Ryan -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
