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