Re: Update performance ... Recommended configuration - Mailing list pgsql-performance

From Rod Taylor
Subject Re: Update performance ... Recommended configuration
Date
Msg-id 1070487190.92431.57.camel@jester
Whole thread Raw
In response to Re: Update performance ... Recommended configuration changes?  (erik@norvelle.net)
List pgsql-performance
> shared_buffers = 128        # min max_connections*2 or 16, 8KB each

Try 1500.

> sort_mem = 65535        # min 64, size in KB

I'd pull this in. You only have 640MB ram, which means about 8 large
sorts to swap.

How about 16000?

> fsync = false

I presume you understand the risks involved with this setting and
dataloss.


pgsql-performance by date:

Previous
From: erik@norvelle.net
Date:
Subject: Re: Update performance ... Recommended configuration changes?
Next
From: Sean Shanny
Date:
Subject: Has anyone run on the new G5 yet