Re: Update performance ... Recommended configuration

From: Rod Taylor <pg(at)rbt(dot)ca>
To: erik(at)norvelle(dot)net
Cc: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Update performance ... Recommended configuration
Date: 2003-12-03 21:33:10
Message-ID: 1070487190.92431.57.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Sean Shanny 2003-12-03 21:40:37 Has anyone run on the new G5 yet
Previous Message erik 2003-12-03 21:22:27 Re: Update performance ... Recommended configuration changes?