On Thu, Apr 21, 2011 at 5:50 PM, Tory M Blue <tmblue(at)gmail(dot)com> wrote:
> # - Checkpoints -
> checkpoint_segments = 100
> max_connections = 300
> shared_buffers = 2500MB # min 128kB or max_connections*16kB
> max_prepared_transactions = 0
> work_mem = 100MB
> maintenance_work_mem = 128MB
> fsync = on
That's an unrealistic setting for a 32-bit system, which can only
address 3GB of memory per process.
You take away 2500MB for shared buffers, that leaves you only 500M for
data, some of which is code.
There's no way PG can operate with 100MB work_mem llike that.
Either decrease shared_buffers, or get a 64-bit system.