04.03.2013 18:25 пользователь "Merlin Moncure" <mmoncure(at)gmail(dot)com> написал:
>
> On Sun, Mar 3, 2013 at 11:05 AM, G N <myterag(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general