Re: Needed: Simplified guide to optimal memory configuration - Mailing list pgsql-performance

From Dennis Bjorklund
Subject Re: Needed: Simplified guide to optimal memory configuration
Date
Msg-id Pine.LNX.4.44.0506151123510.1139-100000@zigo.dhs.org
Whole thread Raw
In response to Needed: Simplified guide to optimal memory configuration  (Todd Landfried <tlandfried@viatornetworks.com>)
Responses Re: Needed: Simplified guide to optimal memory configuration  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Needed: Simplified guide to optimal memory configuration  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
On Wed, 15 Jun 2005, Todd Landfried wrote:

> So, what I need is to be pointed to (or told) what are the best
> settings for our database given these memory configurations.  What
> should we do?

Maybe this will help:

http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html

> NOTICE:  shared_buffers is 256

This looks like it's way too low. Try something like 2048.

--
/Dennis Björklund


pgsql-performance by date:

Previous
From: Todd Landfried
Date:
Subject: Needed: Simplified guide to optimal memory configuration
Next
From: Tom Lane
Date:
Subject: Re: Needed: Simplified guide to optimal memory configuration