pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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
	



view thread (47+ messages)  latest in thread

Message-ID: <9B1C77393DED0D4B9DAA1AA1742942DA3BCCB1@pos_pdc.posportal.com>
Permalink:  ../9B1C77393DED0D4B9DAA1AA1742942DA3BCCB1@pos_pdc.posportal.com/
Also on:    postgresql.org/message-id/9B1C77393DED0D4B9DAA1AA1742942DA3BCCB1@pos_pdc.posportal.com

 · 

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: 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