Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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: Fri, 14 Mar 2008 00:12:27 -0600
  • Message-id: <dcc563d10803132312o1539215fk859bbae03f36e566(at)mail(dot)gmail(dot)com>

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.



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group