Postgres Pro
Downloads
Home   >   mailing lists

out of memory - Mailing list pgsql-general

From Hugues-Vincent Grislin
Subject out of memory
Date
Msg-id 426E49F9.3010806@vif.tm.fr
Whole thread Raw
Responses Re: out of memory  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: Shelby Cain
Date:
Subject: Re: Change Windows path to Unix path...
Next
From: Jake Stride
Date:
Subject: Re: Intervals