On Thu, Apr 21, 2011 at 7:27 AM, Merlin Moncure <mmoncure@xxxxxxxxx> wrote: > On Thu, Apr 21, 2011 at 3:28 AM, Tory M Blue <tmblue@xxxxxxxxx> wrote: >> Fedora 12 >> 32gig memory, 8 proc >> postgres 8.4.4, slony 1.20 >> 5 gigs of swap (never hit it!) > > curious: using 32/64 bit postgres? what are your postgresql.conf > memory settings? > > merlin > 32bit 32gb PAE kernel # - 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 thanks Tory -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
