Re: Needed: Simplified guide to optimal memory configuration

From: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
To: Todd Landfried <tlandfried(at)viatornetworks(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Needed: Simplified guide to optimal memory configuration
Date: 2005-06-15 09:25:37
Message-ID: Pine.LNX.4.44.0506151123510.1139-100000@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-06-15 14:18:25 Re: Needed: Simplified guide to optimal memory configuration
Previous Message Todd Landfried 2005-06-15 09:06:27 Needed: Simplified guide to optimal memory configuration