Message-ID: <47DA1866.3050500@krogh.cc>
Date: Fri, 14 Mar 2008 07:17:10 +0100
From: Jesper Krogh <jesper@krogh.cc>
User-Agent: Thunderbird 2.0.0.12 (X11/20080227)
MIME-Version: 1.0
To: Scott Marlowe <scott.marlowe@gmail.com>
CC: justin <justin@emproshunts.com>, pgsql-performance@postgresql.org
Subject: Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
References: <f966c2ee0803052142l6a105678jfe2da92a0d9371@mail.gmail.com>	
	<3E9C3A51-C28E-4B75-9739-E344DAC72880@fastcrypt.com>	
	<f966c2ee0803060443j3d9c1b66x5f59e00d084e841c@mail.gmail.com>	
	<Pine.GSO.4.64.0803060813570.11897@westnet.com>	
	<47D00DB2.7040007@emolecules.com> <18451.1204824562@sss.pgh.pa.us>	
	<47D0AFC1.5070305@emolecules.com>	
	<08115901408538@mail.emproshunts.com>	
	<47D93A43.6020503@emolecules.com>	
	<016301c8854e$851e06e0$3101a8c0@JDell>
	<dcc563d10803132312o1539215fk859bbae03f36e566@mail.gmail.com>
In-Reply-To: <dcc563d10803132312o1539215fk859bbae03f36e566@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Scott Marlowe wrote:
> On Thu, Mar 13, 2008 at 3:09 PM, justin <justin@emproshunts.com> wrote:
> 
>>  I chose to use ext3 on these partition
> 
> You should really consider another file system.  ext3 has two flaws
> that mean I can't really use it properly.  A 2TB file system size
> limit (at least on the servers I've tested) and it locks the whole
> file system while deleting large files, which can take several seconds
> and stop ANYTHING from happening during that time.  This means that
> dropping or truncating large tables in the middle of the day could
> halt your database for seconds at a time.  This one misfeature means
> that ext2/3 are unsuitable for running under a database.

I cannot acknowledge or deny the last one, but the first one is not 
true. I have several volumes in the 4TB+ range on ext3 performing nicely.

I can test the "large file stuff", but how large? .. several GB is not a 
problem here.

Jesper
-- 
Jesper