Thread: out of memory issue

On Sun, Mar 3, 2013 at 11:05 AM, G N <myterag@gmail.com> wrote:
> Hello Friends,
>
>  Hope you are all well...
>
> I have a specific issue, where my query fails with below error while trying
> to export data from pgadmin SQL tool.
>
> There are no such issues when the result set is small. But it returns error
> when the result set is bit large.
>
> Any inputs please ? Where and how should memory be increased in case ?
>
> out of memory for query result

I'm guessing your query is returning a lot of data and the export
itself is not being produced with COPY.  As such, you are subject to
the limits of the 32 bit libpq you are probably using (or if  you are
using 64 bit, you are well and truly running out of memory).

Solution to move forward.
learn COPY and psql \copy.  Refer documentation.

merllin

04.03.2013 18:25 пользователь "Merlin Moncure" <mmoncure@gmail.com> написал:
>
> On Sun, Mar 3, 2013 at 11:05 AM, G N <myterag@gmail.com> wrote:
> > Hello Friends,
> >
> >  Hope you are all well...
> >
> > I have a specific issue, where my query fails with below error while trying
> > to export data from pgadmin SQL tool.
> >
> > There are no such issues when the result set is small. But it returns error
> > when the result set is bit large.
> >
> > Any inputs please ? Where and how should memory be increased in case ?
> >
> > out of memory for query result
>
> I'm guessing your query is returning a lot of data and the export
> itself is not being produced with COPY.  As such, you are subject to
> the limits of the 32 bit libpq you are probably using (or if  you are
> using 64 bit, you are well and truly running out of memory).
>
> Solution to move forward.
> learn COPY and psql \copy.  Refer documentation.
I am curious how about single row mode implemented in 9.2 in this case?
>
> merllin
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general