Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id EB9066329E2 for ; Fri, 6 Aug 2010 08:58:11 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 37989-07 for ; Fri, 6 Aug 2010 11:58:04 +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 32DFE6336E4 for ; Fri, 6 Aug 2010 08:58:04 -0300 (ADT) Received: by mail.sdb.it (Postfix, from userid 500) id 844598118; Fri, 6 Aug 2010 13:58:02 +0200 (CEST) Received: from geronimo.sdb.it (geronimo.sdb.it [10.101.1.20]) by mail.sdb.it (Postfix) with ESMTP id 7F1FD80DF for ; Fri, 6 Aug 2010 13:58:02 +0200 (CEST) Received: from mailtech.sdb.it (sdbit-srv01.sdb.it [10.118.122.250]) by geronimo.sdb.it (Postfix) with ESMTP id 3C6C83808B0; Fri, 6 Aug 2010 13:57:53 +0200 (CEST) Received: from [10.118.101.88] (silviob.sdb.it [10.118.101.88]) by mailtech.sdb.it (Postfix) with ESMTP id 620FD58ABA; Fri, 6 Aug 2010 13:58:02 +0200 (CEST) Message-ID: <4C5BF885.9060105@tech.sdb.it> Date: Fri, 06 Aug 2010 13:56:53 +0200 From: Silvio Brandani User-Agent: Thunderbird 2.0.0.24 (Windows/20100228) MIME-Version: 1.0 To: Silvio Brandani Cc: pgsql-admin@postgresql.org Subject: Re: out of memory error References: <288793.40690.qm@web39707.mail.mud.yahoo.com> <4C5BC43B.7050503@tech.sdb.it> In-Reply-To: <4C5BC43B.7050503@tech.sdb.it> 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/41 X-Sequence-Number: 35290 Silvio Brandani ha scritto: > 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 > it seems the execution plan is different for this query when run from the application versus the psql . How can I check the execution plan of a query run by a user?? I can set explain analyze for the query via psql but how can I check with application running the query??? Thanks --- 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. --