>> 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.
Regards,
Matt