Re: Benchmark: Dell/Perc 6, 8 disk RAID 10

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: justin <justin(at)emproshunts(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
Date: 2008-03-14 06:12:27
Message-ID: dcc563d10803132312o1539215fk859bbae03f36e566@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Thu, Mar 13, 2008 at 3:09 PM, justin <justin(at)emproshunts(dot)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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jesper Krogh 2008-03-14 06:17:10 Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
Previous Message Scott Marlowe 2008-03-14 06:09:15 Re: Benchmark: Dell/Perc 6, 8 disk RAID 10