Re: Selecting large tables gets killed - Mailing list pgsql-hackers

From Bernd Helmle
Subject Re: Selecting large tables gets killed
Date
Msg-id F3269A63EC7B12A7788707C0@apophis.credativ.lan
Whole thread Raw
In response to Re: Selecting large tables gets killed  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
Responses Re: Selecting large tables gets killed  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
List pgsql-hackers

--On 20. Februar 2014 14:49:28 +0530 Ashutosh Bapat 
<ashutosh.bapat@enterprisedb.com> wrote:

> If I set some positive value for this variable, psql runs smoothly with
> any size of data. But unset that variable, and it gets killed. But it's
> nowhere written explicitly that psql can run out of memory while
> collecting the result set. Either the documentation or the behaviour
> should be modified.

Maybe somewhere in the future we should consider single row mode for psql, 
see

<http://www.postgresql.org/docs/9.3/static/libpq-single-row-mode.html>

However, i think nobody has tackled this yet, afair.

-- 
Thanks
Bernd



pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: GIN improvements part2: fast scan
Next
From: Ashutosh Bapat
Date:
Subject: Re: Selecting large tables gets killed