Re: Tuning PostgreSQL - Mailing list pgsql-performance

> 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,
rotationalspeed, and transfer rate aren't going to help at all when the drive itself degrades and corrupts data.  If
youcan 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
setusing the other 2 drives.  If you need more space for data, or want your OS drives to be mirrored - it's going to
costmore.  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
theroad.
 
 
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