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