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