|
Home > Archive > PostgreSQL Discussion > April 2005 > out of memory
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Hugues-Vincent Grislin 2005-04-26, 1:23 pm |
| 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.
| |
| Scott Marlowe 2005-04-26, 1:23 pm |
| On Tue, 2005-04-26 at 09:02, Hugues-Vincent Grislin wrote:
> 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,
Have you analyzed the database? Try that first. If you still get an
out of memory error, try setting enable_hashagg off (set
enable_hashagg=false
;) and then running the same query again and see if
it then works. If it does, post the result of
explain analyze YOURQUERYHERE
If it doesn't post the output of a plain explain, no analyze.
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
|
|
|
|
|