Re: psql crashing - don't know why

On Mon, Aug 10, 2009 at 9:10 AM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>wrote:

> 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.

Go through the section "Linux Memory Overcommit at -->
http://www.postgresql.org/docs/8.3/interactive/kernel-resources.html

... that might help in this case

--
Shoaib Mir
http://shoaibmir.wordpress.com/