Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id B08721B5234C for ; Wed, 23 May 2012 12:26:57 -0300 (ADT) Received: from sss.pgh.pa.us ([66.207.139.130]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SXDSh-0005IM-8z for pgsql-admin@postgresql.org; Wed, 23 May 2012 15:26:56 +0000 Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id q4NFQgoa004393; Wed, 23 May 2012 11:26:42 -0400 (EDT) To: Vincent Dautremont cc: pgsql-admin@postgresql.org Subject: Re: out of memory error In-reply-to: References: <3902.1337708023@sss.pgh.pa.us> <5105.1337711403@sss.pgh.pa.us> <7269.1337717095@sss.pgh.pa.us> Comments: In-reply-to Vincent Dautremont message dated "Wed, 23 May 2012 10:06:00 -0400" Date: Wed, 23 May 2012 11:26:42 -0400 Message-ID: <4392.1337786802@sss.pgh.pa.us> From: Tom Lane X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201205/87 X-Sequence-Number: 39576 Vincent Dautremont writes: > I've found out that when my software does these updates the memory of the > postgres process grows constantly at 24 MB/hour. when I stop my software to > update these rows, the memory of the process stops to grow. > also I've noticed that when I stop rubyrep, this postgres process disappear. Hmm. I wondered whether rubyrep might be triggering this somehow; I don't know anything about that software. I went so far as to download rubyrep and look at the Postgres-specific source code yesterday. It doesn't look like it's doing anything strange, but I could easily have missed something. One thing you could try doing is to turn on query logging (set log_statement = all) and look to see if rubyrep, or some other part of your system, is indeed issuing repeated CREATE OR REPLACE FUNCTION commands. regards, tom lane