On Sat, 2002-03-16 at 07:32, Arsalan Zaidi wrote:
> >
> > Does your server log have any entries at around that point for the actual
> > backend death? Do you have a core file?
>
> No core file, but here's the stuff from the log. Strange, I don't remember
> kill -9'ing the backend...
>
And this happened after a couple of days running a single query? I would
suspect that your system[*] is imposing resource limits, and the backend
exceeded its limit for CPU time. (It would be better for the resource
limiting to try an ordinary kill first before using kill -9, though...)
Or as you suggest, you may be running out of some other resource -I
would check ordinary syslog/kernel messages -out of memory process
killing might be reported there.
Regards
John
[*] or sysadmin.