On Mon, Aug 10, 2009 at 9:10 AM, Scott Marlowe <scott.marl...@gmail.com>wrote:
> On Sun, Aug 9, 2009 at 5:04 PM, Brent Wood<b.w...@niwa.co.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/