Re: memory allocation

Michael Ryan S. Puncia wrote:
> Hi everyone .
>
>
>
> How much memory should I give to the kernel and postgresql
>
> I have 1G of memory and 120G of HD

Devrim's pointed you to a guide to the configuration file. There's also
an introduction to performance tuning on the same site.

An important thing to remember is that the sort_mem is the amount of
memory available *per sort* and some queries can use several sorts.

--
   Richard Huxton
   Archonet Ltd