Florian Weimer schrieb:
Please guide me how to change it permanently and what is the correct
value for it.
I am going for 8GB .
Usually, you can put these lines
kernel.shmall = 9000000000
kernel.shmmax = 9000000000
into /etc/sysctl.conf. Run "sysctl -p" to activate them. However,
this is a bit distribution-specific.
If you're using FreeBSD you even have to restart the machine.
Greetings,
Torsten
--
http://www.dddbl.de - ein Datenbank-Layer, der die Arbeit mit 8
verschiedenen Datenbanksystemen abstrahiert,
Queries von Applikationen trennt und automatisch die Query-Ergebnisse
auswerten kann.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
