pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Scott Marlowe <scott.marlowe@gmail.com>
To: Jesper Krogh <jesper@krogh.cc>
Cc: justin <justin@emproshunts.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
Date: Fri, 14 Mar 2008 00:19:40 -0600
Message-ID: <dcc563d10803132319u19480a4fn16115c415ee57844@mail.gmail.com> (raw)
In-Reply-To: <47DA1866.3050500@krogh.cc>
References: <f966c2ee0803052142l6a105678jfe2da92a0d9371@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>
	<47DA1866.3050500@krogh.cc>

On Fri, Mar 14, 2008 at 12:17 AM, Jesper Krogh <jesper@krogh.cc> wrote:
>
> 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.

Is this on a 64 bit or 32 bit machine?  We had the problem with a 32
bit linux box (not sure what flavor) just a few months ago.  I would
not create a filesystem on a partition of 2+TB



view thread (45+ messages)  latest in thread

Message-ID: <dcc563d10803132319u19480a4fn16115c415ee57844@mail.gmail.com>
Permalink:  ../dcc563d10803132319u19480a4fn16115c415ee57844@mail.gmail.com/
Also on:    postgresql.org/message-id/dcc563d10803132319u19480a4fn16115c415ee57844@mail.gmail.com

 · 

reply

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: scott.marlowe@gmail.com, jesper@krogh.cc, justin@emproshunts.com
  Subject: Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  In-Reply-To: <dcc563d10803132319u19480a4fn16115c415ee57844@mail.gmail.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