I saw something I had never seen with psql.
> canon=# select * from public.genotype;
> out of memory
> [tsakai(at)vixen tws]$ echo $?
> [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)?
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2007-09-12 03:58:21|
|Subject: Re: out of memory |
|Previous:||From: Tom Lane||Date: 2007-09-11 19:57:00|
|Subject: Re: Postmaster Question |