out of memory

Hi Everybody,

I saw something I had never seen with psql.

> canon=#
> canon=# select * from public.genotype;
> out of memory
> [tsakai(at)vixen tws]$ echo $?
> 1
> [tsakai(at)vixen tws]$

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

I don't suppose there is anything I can do to prevent
such failure (short of installing more memory)?

Regards,

Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu