Re: Out of Memory - 8.2.4

From: Jeff Amiel <becauseimjeff(at)yahoo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Erik Jones <erik(at)myemma(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Out of Memory - 8.2.4
Date: 2007-08-28 20:43:38
Message-ID: 569622.71172.qm@web60821.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I notice in the log entries for the out of memory events have no username, database name or host
identifier (while regular logged events do) Does that mean anything to anybody?

Aug 28 08:25:50 db-1 postgres[29019]: [ID 748848 local0.warning] [111900-1] 2007-08-28
08:25:50.081 CDT 29019ERROR: out of memory
Aug 28 08:25:50 db-1 postgres[29019]: [ID 748848 local0.warning] [111900-2] 2007-08-28
08:25:50.081 CDT 29019DETAIL: Failed on request of size 536870910.

(regular log entry)
Aug 28 08:26:45 db-1 postgres[28785]: [ID 748848 local0.info] [114999-1] 2007-08-28 08:26:45.413
CDT jboss prod 192.168.20.44 28785LOG: duration: 22606.146 ms execute <unnamed>: select

--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Can you correlate these occurrences with anything in the regular system
> logs (kernel log in particular)? The Postgres log shows nothing out of
> the ordinary --- it's simply that the kernel won't give us 512M for some
> reason. I'm guessing it's got something to do with overall system load.
>
> regards, tom lane
>


____________________________________________________________________________________
Moody friends. Drama queens. Your life? Nope! - their life, your story. Play Sims Stories at Yahoo! Games.
http://sims.yahoo.com/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2007-08-28 20:52:56 Re: Out of Memory - 8.2.4
Previous Message Kevin Neufeld 2007-08-28 20:39:38 Re: PickSplit method of 2 columns ... error