| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Brent Wood <b(dot)wood(at)niwa(dot)co(dot)nz> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: psql crashing - don't know why |
| Date: | 2009-08-09 23:10:07 |
| Message-ID: | dcc563d10908091610s3d380b0etad80d5f4a5a499c@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sun, Aug 9, 2009 at 5:04 PM, Brent Wood<b(dot)wood(at)niwa(dot)co(dot)nz> wrote:
> Hi...
>
> I have a view across 3 tables, total some 5m rows.
>
> I can extract parts of the view, entire rows, with a where clause
> (eg: select * from view where cell_id=100000;)
>
> If I try to select the entire view (eg: select * from view;) it runs for a while then gives the error msg "Killed" and returns to the system prompt, having exited psql.
>
> The log says:
> 2009-08-10 00:19:01 NZST ben200601 woodb LOG: could not send data to client: Broken pipe
> 2009-08-10 00:19:48 NZST ben200601 woodb LOG: unexpected EOF on client connection
>
Most likely you're getting bitten by the OOM killer in linux.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2009-08-09 23:31:13 | Re: Postgres memory question |
| Previous Message | Brent Wood | 2009-08-09 23:04:24 | psql crashing - don't know why |