On Thu, Apr 21, 2011 at 7:27 AM, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
> On Thu, Apr 21, 2011 at 3:28 AM, Tory M Blue <tmblue(at)gmail(dot)com> 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