out of memory

From: Hugues-Vincent Grislin <hugues-vincent(dot)grislin(at)vif(dot)tm(dot)fr>
To: pgsql-general(at)postgresql(dot)org
Subject: out of memory
Date: 2005-04-26 14:02:33
Message-ID: 426E49F9.3010806@vif.tm.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I have a problem when i try to execute my request :

ERROR: out of memory
DETAIL: Failed on request of size 336.

(I had execute the " VACCUM" before)
It's a SELECT which contains several jointures (simple ones, 1-1).
With 5 jointures there is no problem but with 6, i have this error.

_config _:
Postgres 7.4.7
Linux Redhat 7.0
RAM : 256 Mo
swap : 256 Mo

I found some threads about that but no answer.
Thanks,

Hugues-Vincent Grislin.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2005-04-26 14:02:48 Re: Immutable attributes?
Previous Message Richard_D_Levine 2005-04-26 13:58:49 Re: UltraSPARC versus AMD