Re: [GENERAL] psql crashing - don't know why

2009-08-10 Thread Martijn van Oosterhout
On Mon, Aug 10, 2009 at 11:04:24AM +1200, Brent Wood 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=10;) If I try to select the entire view (eg: select * from

[GENERAL] psql crashing - don't know why

2009-08-09 Thread Brent Wood
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=10;) If I try to select the entire view (eg: select * from view;) it runs for a while then gives the error msg Killed and

Re: [GENERAL] psql crashing - don't know why

2009-08-09 Thread Scott Marlowe
On Sun, Aug 9, 2009 at 5:04 PM, Brent Woodb.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=10;) If I try to select the entire view (eg: select * from

Re: [GENERAL] psql crashing - don't know why

2009-08-09 Thread Shoaib Mir
On Mon, Aug 10, 2009 at 9:10 AM, Scott Marlowe scott.marl...@gmail.comwrote: On Sun, Aug 9, 2009 at 5:04 PM, Brent Woodb.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 *