Re: Problems with memory

Pau Marc Munoz Torres wrote:
> Hi
>
> I'm setting up a big database , and when i say big, i mean BIG,

I have to say, I've seen more accurate stats given. How many Terabytes
are we talking about?

> the problem
> with this is that some times, when a do a query the database run out of
> memory,

What precisely do you mean by "run out of memory" - is this work-mem or
shared-mem? How do you know this is what's happening?

> so I really need to increase the amount of memory reserved to
> postgress almost 10x, could anyone tell me how can i do that? i mean, what
> configuration file and variables do i have to modify?

What memory are you trying to reserve for PostgreSQL? Is it shared-mem
you're talking about? If you let us know where you found the manuals
confusing, we can try to improve them.

--
Richard Huxton
Archonet Ltd