From: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
To: pgsql-performance@postgresql.org
Subject: Re: Performance advice
Date: Tue, 24 Jun 2003 13:49:54 +0530
Message-ID: <3EF85702.30194.3A69859@localhost> (raw)
In-Reply-To: <3EF85224.1633.3939548@localhost>
References: <CJEBLDCHAADCLAGIGCOOCEJECKAA.michael.mattox@verideon.com>
On 24 Jun 2003 at 13:29, Shridhar Daithankar wrote:
> > - I have at my disposal one other server which has 2 Xeons, 10,000 RPM SCSI
> > drive. Would it make sense to put Postgres on it and leave my apps running
> > on the more powerful 4 CPU server?
Argh.. Forgot it first time.
With java runnning on same machine, I would not trust that machine for having
free RAM all the time, no matter how much RAM you have put into it.
Secondly you are running linux which is known to have weird behaviour problems
when it runs low on memory.
For both these reasons, I suggest you put your database on another machine. A
dual CPU machine is more than enough. Put good deal RAM, around a GB and two
SCSI disks, one for data and another for WAL. If you get RAID for data, great.
But that should suffice otherwise as well.
> >
> > - Would a RAID setup make the disk faster? Because top rarely shows the
> > CPUs above 50%, I suspect maybe the disk is the bottleneck.
>
> Yes it is. You need to move WAL to a different disk. Even if it is IDE. (OK
> that was over exaggeration but you got the point). If your data directories and
> WAL logs are on physically different disks, that should bump up performance
> plenty.
In addition to that, on linux, it matters a lot as in what filesystem you use.
IMO ext3 is strict no-no. Go for either reiserfs or XFS.
There is no agreement as in which file system is best on linux. so you need to
experiment if you need every ounce of performance.
And for that you got to try freeBSD. That would gave you plenty of idea about
performance differences. ( Especially I love man hier and man tuning on
freeBSD. Nothing on linux comes anywhere near to that)
Bye
Shridhar
--
"Who is General Failure and why is he reading my hard disk ?"Microsoft spel
chekar vor sail, worgs grate !!(By leitner@inf.fu-berlin.de, Felix von Leitner)
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: shridhar_daithankar@persistent.co.in
Subject: Re: Performance advice
In-Reply-To: <3EF85702.30194.3A69859@localhost>
References: <CJEBLDCHAADCLAGIGCOOCEJECKAA.michael.mattox@verideon.com> <3EF85702.30194.3A69859@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