Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 0249A63359E for ; Fri, 6 Aug 2010 05:15:07 -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 28218-09 for ; Fri, 6 Aug 2010 08:14:58 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.sdb.it (mail.sdb.it [212.141.11.2]) by mail.postgresql.org (Postfix) with ESMTP id 709CA6333B9 for ; Fri, 6 Aug 2010 05:14:58 -0300 (ADT) Received: by mail.sdb.it (Postfix, from userid 500) id 42DBF8120; Fri, 6 Aug 2010 10:14:57 +0200 (CEST) Received: from geronimo.sdb.it (geronimo.sdb.it [10.101.1.20]) by mail.sdb.it (Postfix) with ESMTP id 3D960811D; Fri, 6 Aug 2010 10:14:57 +0200 (CEST) Received: from mailtech.sdb.it (sdbit-srv01.sdb.it [10.118.122.250]) by geronimo.sdb.it (Postfix) with ESMTP id D9FE03808A1; Fri, 6 Aug 2010 10:14:49 +0200 (CEST) Received: from [10.118.101.88] (silviob.sdb.it [10.118.101.88]) by mailtech.sdb.it (Postfix) with ESMTP id 23B3E58ABA; Fri, 6 Aug 2010 10:14:56 +0200 (CEST) Message-ID: <4C5BC43B.7050503@tech.sdb.it> Date: Fri, 06 Aug 2010 10:13:47 +0200 From: Silvio Brandani User-Agent: Thunderbird 2.0.0.24 (Windows/20100228) MIME-Version: 1.0 To: Bob Lunney Cc: pgsql-admin@postgresql.org Subject: Re: out of memory error References: <288793.40690.qm@web39707.mail.mud.yahoo.com> In-Reply-To: <288793.40690.qm@web39707.mail.mud.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit X-Private-Material: Please read notice 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, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201008/40 X-Sequence-Number: 35289 Bob Lunney ha scritto: > Silvio , > > I had a similar problem when starting the database from an account that didn't have the appropriate ulimits set. Check the ulimit values using ulimit -a. > > HTH, > > Bob Lunney > > --- On Thu, 8/5/10, Silvio Brandani wrote: > > >> From: Silvio Brandani >> Subject: [ADMIN] out of memory error >> To: pgsql-admin@postgresql.org >> Date: Thursday, August 5, 2010, 9:01 AM >> Hi, >> >> a query on our production database give following errror: >> >> >> 2010-08-05 10:52:40 CEST [12106]: [278-1] ERROR: out >> of memory >> 2010-08-05 10:52:40 CEST [12106]: [279-1] DETAIL: >> Failed on request of size 48. >> >> >> >> >> any suggestion ? >> >> -- Silvio Brandani >> Infrastructure Administrator >> SDB Information Technology >> Phone: +39.055.3811222 >> Fax: +39.055.5201119 >> >> --- >> >> >> >> >> >> >> Utilizziamo i dati personali che la riguardano >> esclusivamente per nostre finalitą amministrative e >> contabili, anche quando li comunichiamo a terzi. >> Informazioni dettagliate, anche in ordine al Suo diritto di >> accesso e agli altri Suoi diritti, sono riportate alla >> pagina http://www.savinodelbene.com/news/privacy.html >> Se avete ricevuto questo messaggio per errore Vi preghiamo >> di ritornarlo al mittente eliminandolo assieme agli >> eventuali allegati, ai sensi art. 616 codice penale http://www.savinodelbene.com/codice_penale_616.html >> L'Azienda non si assume alcuna responsabilitą giuridica >> qualora pervengano da questo indirizzo messaggi estranei >> all'attivitą lavorativa o contrari a norme. >> -- >> >> -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-admin >> >> > > > > > I have the following set: ulimit -a core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited max nice (-e) 0 file size (blocks, -f) unlimited pending signals (-i) 71679 max locked memory (kbytes, -l) 32 max memory size (kbytes, -m) unlimited open files (-n) 1024 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 max rt priority (-r) 0 stack size (kbytes, -s) 10240 cpu time (seconds, -t) unlimited max user processes (-u) 71679 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited Silvio B --- Utilizziamo i dati personali che la riguardano esclusivamente per nostre finalitą amministrative e contabili, anche quando li comunichiamo a terzi. Informazioni dettagliate, anche in ordine al Suo diritto di accesso e agli altri Suoi diritti, sono riportate alla pagina http://www.savinodelbene.com/news/privacy.html Se avete ricevuto questo messaggio per errore Vi preghiamo di ritornarlo al mittente eliminandolo assieme agli eventuali allegati, ai sensi art. 616 codice penale http://www.savinodelbene.com/codice_penale_616.html L'Azienda non si assume alcuna responsabilitą giuridica qualora pervengano da questo indirizzo messaggi estranei all'attivitą lavorativa o contrari a norme. --