| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Tino Schwarze <postgresql(at)tisc(dot)de> |
| Cc: | pgsql-admin(at)postgresql(dot)org, "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu> |
| Subject: | Re: out of memory |
| Date: | 2007-09-12 14:20:48 |
| Message-ID: | 20997.1189606848@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-09-12 14:37:49 | Re: Error installing Postgres 8.2.4 |
| Previous Message | IgnatiusRene.Anton | 2007-09-12 12:01:16 | hi |