Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 8B156632400 for ; Thu, 5 Aug 2010 14:40:02 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 38608-05 for ; Thu, 5 Aug 2010 17:39:55 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from web39707.mail.mud.yahoo.com (web39707.mail.mud.yahoo.com [209.191.106.53]) by mail.postgresql.org (Postfix) with SMTP id 2AC2E632E10 for ; Thu, 5 Aug 2010 14:39:55 -0300 (ADT) Received: (qmail 41363 invoked by uid 60001); 5 Aug 2010 17:39:53 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1281029993; bh=+WC16WEJ3wdNqY3aStppxZ5GorD31VHV/iAVFkskizw=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=dOWq+/Bq3u4paK62OxCTqgG9uBI9nLr8jjQDjfynmbcvk9193hY1Waupp9AsrTYNyCQXk/n4I2IX1HpHgv0WiJQWL1SZcYAuWb8+yGcV7GNiOpqLHueyWp58f+du6njC3AKoF6/VCPqWbc19dvXhz9Mu2hIPqU5O50MF3aVCc9M= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=eolKN9KsQuDHGVRE90yYf3PYlpiXyw6feozLCqUR8dbB4sDyTVBeC6BQ1h5IwR34f/H64sNDnE/O1Vi3d9c/ilQQvhgG/l49Jrdx9lfFj43xPfwKLvcFyJrqs9uUF0jxGAO5W9YpNqHB7DJyr7te1doAefuZvbCPRn6SRxpfQCs=; Message-ID: <288793.40690.qm@web39707.mail.mud.yahoo.com> X-YMail-OSG: qf.bHQUVM1mDCbkoGqghtWgFi3NEh7uAop_oWvKbge.GeZ2 aK2JMuSYVWx5qmLa5C3fTseDVHU7ZQ8EeGMAaNwZnkbp3274AM2a8sXOi_vB ODCOHjClntzoa38NTulHndAavL0rhDR7opj68n3P7M3UAAlLf0RQryLLvvhB W028j7sNoQIVmVm5lnrUXB_AhQ.ctAdBaQXQuIgg_tkUbfFrT6JuVCo9BRSb mWXztbIrGYTnqcvlt3SDQsvTD93fJnT23eFHYRtmfiSyotAAlQDoNiW.3uyn e.z4wnZtmblt.KJWhcRwF8ftBuXQoEL2xd0k.N5iFRHUUyCHRLtn959gAK00 yMqvTUg-- Received: from [64.126.29.122] by web39707.mail.mud.yahoo.com via HTTP; Thu, 05 Aug 2010 10:39:53 PDT X-Mailer: YahooMailClassic/11.3.2 YahooMailWebService/0.8.105.279950 Date: Thu, 5 Aug 2010 10:39:53 -0700 (PDT) From: Bob Lunney Subject: Re: out of memory error To: pgsql-admin@postgresql.org, Silvio Brandani In-Reply-To: <4C5AB62E.7020201@tech.sdb.it> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.79 tagged_above=-10 required=5 tests=BAYES_50=0.8, RCVD_IN_DNSWL_NONE=-0.0001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201008/27 X-Sequence-Number: 35276 Silvio , =0A=0AI had a similar problem when starting the database from an a= ccount that didn't have the appropriate ulimits set. Check the ulimit valu= es using ulimit -a.=0A=0AHTH,=0A=0ABob Lunney=0A=0A--- On Thu, 8/5/10, Silv= io Brandani wrote:=0A=0A> From: Silvio Branda= ni =0A> Subject: [ADMIN] out of memory error= =0A> To: pgsql-admin@postgresql.org=0A> Date: Thursday, August 5, 2010, 9:0= 1 AM=0A> Hi,=0A> =0A> a query on our production database give following err= ror:=0A> =0A> =0A> 2010-08-05 10:52:40 CEST [12106]: [278-1] ERROR:=A0 out= =0A> of memory=0A> 2010-08-05 10:52:40 CEST [12106]: [279-1] DETAIL:=A0=0A>= Failed on request of size 48.=0A> =0A> =0A> =0A> =0A> any suggestion ?=0A>= =0A> -- Silvio Brandani=0A> Infrastructure Administrator=0A> SDB Informati= on Technology=0A> Phone: +39.055.3811222=0A> Fax:=A0=A0=A0+39.055.5201119= =0A> =0A> ---=0A> =0A> =0A> =0A> =0A> =0A> =0A> Utilizziamo i dati personal= i che la riguardano=0A> esclusivamente per nostre finalit=E0 amministrative= e=0A> contabili, anche quando li comunichiamo a terzi.=0A> Informazioni de= ttagliate, anche in ordine al Suo diritto di=0A> accesso e agli altri Suoi = diritti, sono riportate alla=0A> pagina http://www.savinodelbene.com/news/p= rivacy.html=0A> Se avete ricevuto questo messaggio per errore Vi preghiamo= =0A> di ritornarlo al mittente eliminandolo assieme agli=0A> eventuali alle= gati, ai sensi art. 616 codice penale http://www.savinodelbene.com/codice_p= enale_616.html=0A> L'Azienda non si assume alcuna responsabilit=E0 giuridic= a=0A> qualora pervengano da questo indirizzo messaggi estranei=0A> all'atti= vit=E0 lavorativa o contrari a norme.=0A> --=0A> =0A> -- Sent via pgsql-adm= in mailing list (pgsql-admin@postgresql.org)=0A> To make changes to your su= bscription:=0A> http://www.postgresql.org/mailpref/pgsql-admin=0A> =0A=0A= =0A