pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Scott Marlowe <scott.marlowe@gmail.com>
To: 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:12:27 -0600
Message-ID: <dcc563d10803132312o1539215fk859bbae03f36e566@mail.gmail.com> (raw)
In-Reply-To: <016301c8854e$851e06e0$3101a8c0@JDell>
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>

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.

view thread (45+ messages)  latest in thread

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

copy link · copy postgr.es

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, justin@emproshunts.com
  Subject: Re: Benchmark: Dell/Perc 6, 8 disk RAID 10
  In-Reply-To: <dcc563d10803132312o1539215fk859bbae03f36e566@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