From df3c19b483613031bc2d8c51bb90b1a6ebe6b934 Mon Sep 17 00:00:00 2001 From: cassiopc Date: Fri, 24 Aug 2012 16:54:19 +0200 Subject: included info about shmmax --- boca-1.5.0/doc/INSTALL.txt | 7 +++++++ 1 file changed, 7 insertions(+) diff --git a/boca-1.5.0/doc/INSTALL.txt b/boca-1.5.0/doc/INSTALL.txt index a107e23..9c5fd57 100644 --- a/boca-1.5.0/doc/INSTALL.txt +++ b/boca-1.5.0/doc/INSTALL.txt @@ -60,6 +60,13 @@ shared_buffers = 512MB ## USE AROUND 1/3 OF YOUR RAM work_mem = 10MB effective_cache_size = 512MB ## USE AROUND 1/3 OF YOUR RAM +Note that for doing these changes you will need to increase the SHMMAX +parameter of your kernel, e.g. in file /etc/sysctl.d/10-shmmax.conf + +kernel.shmmax = 805416960 +kernel.shmall = 196635 + + ********* /etc/postgresql/*/main/pg_hba.conf: ********* #this is the access control file #restricting connections from unixsocket or localhost is -- cgit v1.2.3