Re: psql crashing - don't know why
| От | Scott Marlowe |
|---|---|
| Тема | Re: psql crashing - don't know why |
| Дата | |
| Msg-id | dcc563d10908091610s3d380b0etad80d5f4a5a499c@mail.gmail.com обсуждение исходный текст |
| Ответ на | psql crashing - don't know why ("Brent Wood" <b.wood@niwa.co.nz>) |
| Ответы |
Re: psql crashing - don't know why
|
| Список | pgsql-general |
On Sun, Aug 9, 2009 at 5:04 PM, Brent Wood<b.wood@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" andreturns 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.
В списке pgsql-general по дате отправления: