>
> 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.
Bang on... It seems I'm running out of mem during the query... Looks like
I'll have to add some swap space :-)
Thanks.
--Arsalan.