out of memory - Mailing list pgsql-admin

From Tena Sakai
Subject out of memory
Date
Msg-id FE44E0D7EAD2ED4BB2165071DB8E328C03062BF9@egcrc-ex01.egcrc.org
Whole thread Raw
Responses Re: out of memory  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin

Hi Everybody,

I saw something I had never seen with psql.

> canon=#
> canon=# select * from public.genotype;
> out of memory
> [tsakai@vixen tws]$ echo $?
> 1
> [tsakai@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@gallo.ucsf.edu

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postmaster Question
Next
From: Tom Lane
Date:
Subject: Re: out of memory