pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
To: pgsql-performance@postgresql.org
Subject: Re: Tuning PostgreSQL
Date: Mon, 21 Jul 2003 14:21:53 +0530
Message-ID: <3F1BF701.248.144C5B84@localhost> (raw)
In-Reply-To: <002a01c34f62$75c01de0$b696a8c0@APR>

On 21 Jul 2003 at 10:31, Alexander Priem wrote:
> What I am thinking about is buying a server with the following specifications:
> 
> * 1 or 2 Intel Xeon processors (2.4 GHz).
> * 2 Gigabytes of RAM (DDR/ECC).
> * Three 36Gb SCSI160 disks (10.000rpm) in a RAID-5 config, giving 72Gb storage 
> space (right?). The RAID-5 controller has a(hardware) cache of 128Mb.
> * 100Mbit ethernet.
> 
> I will run RedHat Linux 9 (kernel 2.40) with PostgreSQL 7.3.3 on this server.

You might scale down a little on hardware front if required. Of course, if you 
can get it, get it.

> What would you think of this hardware config? Would it do? Of would 4Gb RAM be 
> a lot better? What do you think about the need for two Xeon procs?

I would say get an SMP board with one processor in it. If requierd you can 
upgrade. I suppose that would make hefty difference in price.

> shared_buffers = 6000(kernel.shmmax = 60000000)
> sort_mem = 4096
> max_connections = 150
> vacuum_mem = 65536

effective_cache_size
noatime for data partition
A good filesystem.
WAL on separate drive.

Now that is a good start..

Bye
 Shridhar

--
QOTD:	"I'm on a seafood diet -- I see food and I eat it."




view thread (47+ messages)  latest in thread

Message-ID: <3F1BF701.248.144C5B84@localhost>
Permalink:  ../3F1BF701.248.144C5B84@localhost/
Also on:    postgresql.org/message-id/3F1BF701.248.144C5B84@localhost

 · 

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: shridhar_daithankar@persistent.co.in
  Subject: Re: Tuning PostgreSQL
  In-Reply-To: <3F1BF701.248.144C5B84@localhost>

* 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