Skip site navigation (1) Skip section navigation (2)

Re: out of memory

From: "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: out of memory
Date: 2007-09-12 04:15:56
Message-ID: FE44E0D7EAD2ED4BB2165071DB8E328C03062BFC@egcrc-ex01.egcrc.org (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)gallo(dot)ucsf(dot)edu


-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Tue 9/11/2007 8:58 PM
To: Tena Sakai
Cc: pgsql-admin(at)postgresql(dot)org
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

Responses

pgsql-admin by date

Next:From: Jenny NickelDate: 2007-09-12 07:26:59
Subject: Postgres8.2.4 Installation Error
Previous:From: Tom LaneDate: 2007-09-12 03:58:21
Subject: Re: out of memory

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group