On Mon, Sep 15, 2008 at 12:56 PM, Martin Langhoff <martin.langhoff@xxxxxxxxx> 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@xxxxxxxxx martin@xxxxxxxxxx -- School Server Architect - ask interesting questions - don't get distracted with shiny stuff - working code first - http://wiki.laptop.org/go/User:Martinlanghoff
