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?
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Tue 9/11/2007 8:58 PM
To: Tena Sakai
Subject: Re: [ADMIN] out of memory
"Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)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
In response to
pgsql-admin by date
|Next:||From: Jenny Nickel||Date: 2007-09-12 07:26:59|
|Subject: Postgres8.2.4 Installation Error|
|Previous:||From: Tom Lane||Date: 2007-09-12 03:58:21|
|Subject: Re: out of memory |