Re: out of memory

Many thanks, Tom and Tino.

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

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Wed 9/12/2007 7:20 AM
To: Tino Schwarze
Cc: pgsql-admin(at)postgresql(dot)org; Tena Sakai
Subject: Re: [ADMIN] out of memory

Tino Schwarze <postgresql(at)tisc(dot)de> writes:
> On Tue, Sep 11, 2007 at 09:15:56PM -0700, Tena Sakai wrote:
>> 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?

> Tell the user that he/she should use an appropiate WHERE clause. You
> might also consider adding more swap to the machine. Then it will go
> horribly slow, but it will work.

Or turn the query into a cursor so you can FETCH a reasonable number of
rows at a time.

regards, tom lane