[Server-devel] Pg 8.3 tuning recommendations for embedded low-memory device (for OLPC :-) )

[Martin Langhoff]

On Mon, Sep 15, 2008 at 12:56 PM, Martin Langhoff
<martin.langhoff at 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 at gmail.com
 martin at 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