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