From: Roman Fail <rfail@posportal.com>
To: Alexander Priem <ap@cict.nl>
To: shridhar_daithankar@persistent.co.in
To: pgsql-performance@postgresql.org
Subject: Re: Tuning PostgreSQL
Date: Mon, 21 Jul 2003 06:45:32 -0700
Message-ID: <9B1C77393DED0D4B9DAA1AA1742942DA3BCCB1@pos_pdc.posportal.com> (raw)
> What would you guys think of not using RAID5 in that case, but just a really
> fast 15.000 rpm SCSI-320 disk?
I'd say you must be able to tolerate losing all the data since your last database backup. Your battery backed cache, rotational speed, and transfer rate aren't going to help at all when the drive itself degrades and corrupts data. If you can really only afford 3 drives, I'd have a single drive with the OS & WAL on it, and the data on a RAID-1 mirror set using the other 2 drives. If you need more space for data, or want your OS drives to be mirrored - it's going to cost more. See if you can get 2x18GB drives for the OS and 2x73GB drives for the data.
You have to consider how much headache that small amount of additional money is going to save you (and your users) down the road.
Roman
-----Original Message-----
From: Alexander Priem [mailto:ap@cict.nl]
Sent: Mon 7/21/2003 5:43 AM
To: shridhar_daithankar@persistent.co.in; pgsql-performance@postgresql.org
Cc:
Subject: Re: [PERFORM] Tuning PostgreSQL
Thanks, i'll look further into these mount setting.
I was just thinking, the server will have a (RAID) controller containing
128Mb of battery-backed cache memory. This would really speed up inserts to
the disk and would prevent data loss in case of a power-down also.
What would you guys think of not using RAID5 in that case, but just a really
fast 15.000 rpm SCSI-320 disk?
Kind regards,
Alexander.
----- Original Message -----
From: "Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>
To: <pgsql-performance@postgresql.org>
Sent: Monday, July 21, 2003 2:05 PM
Subject: Re: [PERFORM] Tuning PostgreSQL
> On 21 Jul 2003 at 13:45, Alexander Priem wrote:
>
> > So where can I set the noatime & data=writeback variables? They are not
> > PostgreSQL settings, but rather Linux settings, right? Where can I find
> > these?
>
> These are typicaly set in /etc/fstab.conf. These are mount settings. man
mount
> for more details.
>
> The second setting data=writeback is ext3 specific, IIRC.
>
> HTH
>
> Bye
> Shridhar
>
> --
> History tends to exaggerate. -- Col. Green, "The Savage Curtain", stardate
> 5906.4
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
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: rfail@posportal.com, ap@cict.nl, shridhar_daithankar@persistent.co.in
Subject: Re: Tuning PostgreSQL
In-Reply-To: <9B1C77393DED0D4B9DAA1AA1742942DA3BCCB1@pos_pdc.posportal.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