On Mon, Feb 9, 2009 at 8:53 AM, Matt Magoffin <postgresql.org@xxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general