On Thu, Apr 21, 2011 at 5:50 PM, Tory M Blue <tmblue@xxxxxxxxx> 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. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
