Re: out of memory

Thank you, Tom.

But there's a problem, for which I hope you have
more wisdom.  The reason why I tried that query
is because someone tried the same thing via odbc
from pc quering postgres database and got the
same error ("out of memory").

What can a pc user do?  Anything?

Regards,


Tena
tsakai@gallo.ucsf.edu


-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Tue 9/11/2007 8:58 PM
To: Tena Sakai
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] out of memory

"Tena Sakai" <tsakai@gallo.ucsf.edu> writes:
>> canon=3D# select * from public.genotype;
>> out of memory

> The version is 8.2.4 and platform is redhat linux
> on dell server.  The table has 36 million rows.

Try \set FETCH_COUNT 1000

                        regards, tom lane