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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to