Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id D234B2E2F0C for ; Fri, 14 Mar 2008 03:12:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 05243-05 for ; Fri, 14 Mar 2008 03:12:26 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.182]) by postgresql.org (Postfix) with ESMTP id 044F32E2F0A for ; Fri, 14 Mar 2008 03:12:28 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id m38so4401959waf.5 for ; Thu, 13 Mar 2008 23:12:27 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=YHcczWWKHeIncROFip74Z3l+4iVgW92uwDsKoHmhLy8=; b=LwZ1/O96wXFg4nBOe3zJq3/nm+ykwwOsoad+CqKdq/8WJiWRN3vwzq+EovXcIie41uTDYOfRT9ACq+9HgudPB9haSFkjaupE4UPXF3tMopwJV8oLHXUqQV79jAaRxHHSW1ApHp43uIFlXvUKMl/GB82Mwl9yqc9Sx3U8OAsieaw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=CCdUlcJ3TRtZnTK5VffooAyXRGifZh3rQBzi93wkCg3TQ8Jt+9Op8giKhKKg7DJEu//aA2daHP0PpO2WLx5nFERtoEb4QepflXfbEOzsojJSX3f45TyjruPHbjQjKOFJ7n/+W3Wgao7/AoquZpy6h+M0sR2qaVxaH97etVyTbTI= Received: by 10.115.54.1 with SMTP id g1mr11508857wak.136.1205475147230; Thu, 13 Mar 2008 23:12:27 -0700 (PDT) Received: by 10.114.133.6 with HTTP; Thu, 13 Mar 2008 23:12:27 -0700 (PDT) Message-ID: Date: Fri, 14 Mar 2008 00:12:27 -0600 From: "Scott Marlowe" To: justin Subject: Re: Benchmark: Dell/Perc 6, 8 disk RAID 10 Cc: pgsql-performance@postgresql.org In-Reply-To: <016301c8854e$851e06e0$3101a8c0@JDell> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <3E9C3A51-C28E-4B75-9739-E344DAC72880@fastcrypt.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> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/296 X-Sequence-Number: 29250 On Thu, Mar 13, 2008 at 3:09 PM, justin 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.