Re: out of memory - Mailing list pgsql-admin

From Tino Schwarze
Subject Re: out of memory
Date
Msg-id 20070912081205.GA29139@easy2.in-chemnitz.de
Whole thread Raw
In response to Re: out of memory  ("Tena Sakai" <tsakai@gallo.ucsf.edu>)
Responses Re: out of memory  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
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.

HTH,

Tino.

--
www.spiritualdesign-chemnitz.de
www.lebensraum11.de

Tino Schwarze * Parkstraße 17h * 09120 Chemnitz

pgsql-admin by date:

Previous
From: Jenny Nickel
Date:
Subject: Error installing Postgres 8.2.4
Next
From: Devrim GÜNDÜZ
Date:
Subject: Re: Error installing Postgres 8.2.4