pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Richard Huxton <dev@archonet.com>
To: Anjan Dave <adave@vantage.com>
To: pgsql-performance@postgresql.org
Subject: Re: Tuning for mid-size server
Date: Tue, 21 Oct 2003 16:56:50 +0100
Message-ID: <200310211656.50374.dev@archonet.com> (raw)
In-Reply-To: <2F2E24372F10744588A27DEECC85FE04B6769C@vt-pe2550-001.vantage.vantage.com>
References: <2F2E24372F10744588A27DEECC85FE04B6769C@vt-pe2550-001.vantage.vantage.com>

On Tuesday 21 October 2003 15:28, Anjan Dave wrote:
> Hi,
>
> Pretty soon, a PowerEdge 6650 with 4 x 2Ghz XEONs, and 8GB Memory, with
> internal drives on RAID5 will be delivered. Postgres will be from RH8.0.

You'll want to upgrade PG to v7.3.4

> I am planning for these values for the postgres configuration - to begin
> with:
>
> Shared_buffers (25% of RAM / 8KB)) = 8589934592 * .25 / 8192 = 262144
>
> Sort_mem (4% of RAM / 1KB) = 335544. We'll take about half of that -
> 167772
>
> Effective_cache_size = 262144 (same as shared_buffers - 25%)

My instincts would be to lower the first two substantially, and increase the 
effective cache once you know load levels. I'd probably start with something 
like the values below and work up:
shared_buffers = 8,000 - 10,000 (PG is happier letting the OS do the cacheing)
sort_mem = 4,000 - 8,000 (don't forget this is for each sort)

You'll find the annotated postgresql.conf and performance tuning articles 
useful:
http://www.varlena.com/varlena/GeneralBits/Tidbits/index.php

> In a generic sense, these are recommended values I found in some
> documents. The database will be small in size and will gradually grow
> over time from few thousands to a few million records, or more. The
> activity will be mostly of select statements from a few tables with
> joins, orderby, groupby clauses. The web application is based on
> Apache/Resin and hotspot JVM 1.4.0.

You'll need to figure out how many concurrent users you'll have and how much 
memory will be required by apache/java. If your database grows radically, 
you'll probably want to re-tune as it grows.

-- 
  Richard Huxton
  Archonet Ltd



view thread (29+ messages)  latest in thread

Message-ID: <200310211656.50374.dev@archonet.com>
Permalink:  ../200310211656.50374.dev@archonet.com/
Also on:    postgresql.org/message-id/200310211656.50374.dev@archonet.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: dev@archonet.com, adave@vantage.com
  Subject: Re: Tuning for mid-size server
  In-Reply-To: <200310211656.50374.dev@archonet.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox