Re: Out of memory on SELECT in 8.3.5 - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: Out of memory on SELECT in 8.3.5
Date
Msg-id 2f4958ff0902090101r415442d6m3fbf3775381074dd@mail.gmail.com
Whole thread Raw
In response to Re: Out of memory on SELECT in 8.3.5  ("Matt Magoffin" <postgresql.org@msqr.us>)
Responses Re: Out of memory on SELECT in 8.3.5
List pgsql-general
On Mon, Feb 9, 2009 at 8:53 AM, Matt Magoffin <postgresql.org@msqr.us> wrote:
>>> We have 100+ postgres processes running, so for an individual process,
>>> could the 1024 file limit be doing anything to this query? Or would I
>>> see
>>> an explicit error message regarding this condition?
>>
>> you would get one of "Open files rlimit 1024 reached for uid xxxx" in
>> syslog (which you should checkout anyhow).
>
> No... nothing like this in syslog.
>

So did the backend crashed on this one, or just produced 'out of
memory ' message ?

--
GJ

pgsql-general by date:

Previous
From: "Matt Magoffin"
Date:
Subject: Re: Out of memory on SELECT in 8.3.5
Next
From: Scara Maccai
Date:
Subject: Re: complex custom aggregate function