Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
Date
Msg-id dcc563d10803132312o1539215fk859bbae03f36e566@mail.gmail.com
Whole thread Raw
In response to Re: Benchmark: Dell/Perc 6, 8 disk RAID 10  ("justin" <justin@emproshunts.com>)
Responses Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
List pgsql-performance
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.

pgsql-performance by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
Next
From: "Scott Marlowe"
Date:
Subject: Re: Benchmark: Dell/Perc 6, 8 disk RAID 10