| From: | "Arsalan Zaidi" <azaidi(at)directi(dot)com> |
|---|---|
| To: | "John Gray" <jgray(at)azuli(dot)co(dot)uk> |
| Cc: | "Stephan Szabo" <sszabo(at)megazone23(dot)bigpanda(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Back end dies... |
| Date: | 2002-03-16 10:03:07 |
| Message-ID: | 01e701c1ccd3$95a26c20$4301a8c0@directi.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
>
> 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pirtea Calin | 2002-03-16 10:13:41 | limit /offset |
| Previous Message | John Gray | 2002-03-16 09:04:08 | Re: Back end dies... |