From: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
To: pgsql-performance <pgsql-performance@postgresql.org>
Subject: Re: Looking for a cheap upgrade (RAID)
Date: Sat, 3 May 2003 13:32:49 +0530
Message-ID: <200305031332.49756.shridhar_daithankar@nospam.persistent.co.in> (raw)
In-Reply-To: <Pine.LNX.4.33.0305021512160.25254-100000@css120.ihs.com>
References: <Pine.LNX.4.33.0305021512160.25254-100000@css120.ihs.com>
On Saturday 03 May 2003 02:50, scott.marlowe wrote:
> Seeing as you'll have 2 gigs of RAM, your swap partition is likely to grow
> cob webs, so where you put it probably isn't that critical.
>
> What I usually do is say take 4 120 Gig drives, allocate 1 gig on each for
> swap, so you have 4 gigs swap (your swap should be larger than available
> memory in Linux for performance reasons) and the rest of the drives split
> so that say, the first 5 or so gigs of each is used to house most of the
> OS, and the rest for another RAID array hosting the database. Since the
> root partition can't be on RAID5, you'd have to set up either a single
> drive or a mirror set to handle that.
Setting swap in linux is a tricky proposition. If there is no swap at all,
linux has behaved crazily in past. These days situation is much better.
In my experience with single IDE disk, if swap usage goes above 20-30MB due to
shortage of memory, machine is dead in waters. Linux sometimes does memory
inversion where swap used is half the free memory but swap is not freed but
that does not hurt really..
So my advice is, setting swap more tahn 128MB is waste of disk space. OK 256
in ultra-extreme situations.. but more than that would a be unadvisable
situation..
Shridhar
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: Looking for a cheap upgrade (RAID)
In-Reply-To: <200305031332.49756.shridhar_daithankar@nospam.persistent.co.in>
References: <Pine.LNX.4.33.0305021512160.25254-100000@css120.ihs.com> <200305031332.49756.shridhar_daithankar@nospam.persistent.co.in>
* 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