On Mon, Sep 15, 2008 at 12:56 PM, Martin Langhoff
<martin.langhoff@gmail.com> wrote:
> Assuming a 128MB target, I've been poking and probing with the
> postgresql.conf and the new settings...
Actually, I misreported the host memory - 128MB is not in the picture
anymore. The minium RAM we expect to operate with is 256MB (on the XO
hardware).
Do these settings make sense?
### 256MB RAM, 32MB for Pg
### - 16MB shmem
### - 15 max_connections (to match: 12 apache processes)
### - 15MB max for workmem: 1MB * max_connections
### 512MB RAM, 96MB for Pg
### - 24MB shmem
### - 30 max_connections (to match: 25 apache processes)
### - 60MB max for workmem: 2MB * max_connections
### 1GB RAM, 128MB for Pg
### - 32MB shmem
### - 45 max_connections (to match: 45 apache processes)
### - 90MB max for workmem: 2MB * max_connections
## 2GB RAM, 256MB for Pg
### - 64MB shmem
### - 60 max_connections (to match: 25 apache processes)
### - 180MB max for workmem: 3MB * max_connections
the config files, plus init script doing the selection can be seen at
http://dev.laptop.org/git?p=projects/xs-config;a=commitdiff;h=d2f3fe29295717d6727044e8b6152b5c3e204531
cheers,
martin
--
martin.langhoff@gmail.com
martin@laptop.org -- School Server Architect
- ask interesting questions
- don't get distracted with shiny stuff - working code first
- http://wiki.laptop.org/go/User:Martinlanghoff