From: Bob Lunney <bob_lunney@yahoo.com>
To: pgsql-admin@postgresql.org, Silvio Brandani <silvio.brandani@tech.sdb.it>
Subject: Re: out of memory error
Date: Thu, 5 Aug 2010 10:39:53 -0700 (PDT)
Message-ID: <288793.40690.qm@web39707.mail.mud.yahoo.com> (raw)
In-Reply-To: <4C5AB62E.7020201@tech.sdb.it>
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 <silvio.brandani@tech.sdb.it> wrote:
> From: Silvio Brandani <silvio.brandani@tech.sdb.it>
> 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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: bob_lunney@yahoo.com, silvio.brandani@tech.sdb.it
Subject: Re: out of memory error
In-Reply-To: <288793.40690.qm@web39707.mail.mud.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox