pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rudi Starcevic <tech@wildcash.com>
To: pgsql-performance@postgresql.org
Subject: NFS RAID 0/5
Date: Tue, 29 Mar 2005 01:34:38 +1000
Message-ID: <4248240E.7030805@wildcash.com> (raw)

Hi,

I have a web app using PostgreSQL which indexes, searches and 
streams/downloads online movies.
I think I have a problem with NFS and RAID, it is not strictly 
PostgreSQL but closely linked and I know
many people on this list are experienced with this technology. Apologies 
if it is off topic.
Sometimes it is hard to not  be the Developer, Database and System 
Administrator all rolled into one.

I have a FreeBSD box with 1TB disk space RAID 5, 800GB is used.
This is mount via NFS onto Debian Linux running Apache/PHP/PostgreSQL.

I have a script which loads the directory structure etc. into the database.
As users surf the site web pages are generated by selecting from the 
database as per a standard web app.
The server is on a 100mbit link and has reached up to 80mbits/s in the 
past not using NFS or RAID.

The problem is when users start to stream/download the content the load 
averages go through the roof.
Sometimes as high as 300.

I can only see mostly Apache processes running, up to 2000 is the max. 
limit.
Even after 200 Apache connections the load avg. is over 10.

Could it be that using RAID 5 and NFS is causing the high load avg. on 
the Linux web servers?
I have a machine with RAID 0 but not ready for a day or so.

I will soon need to move the databases onto the NFS partition and am 
concerned it will increase my problem.

Any advise much appreciated.
Thank you.
Regards,
Rudi














Message-ID: <4248240E.7030805@wildcash.com>
Permalink:  ../4248240E.7030805@wildcash.com/
Also on:    postgresql.org/message-id/4248240E.7030805@wildcash.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: tech@wildcash.com
  Subject: Re: NFS RAID 0/5
  In-Reply-To: <4248240E.7030805@wildcash.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