X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 689D3D1C4DB for ; Tue, 12 Aug 2003 18:39:30 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 02216-06 for ; Tue, 12 Aug 2003 15:37:57 -0300 (ADT) Received: from mta6.adelphia.net (mta6.adelphia.net [64.8.50.190]) by svr1.postgresql.org (Postfix) with ESMTP id 3C021D1C4CD for ; Tue, 12 Aug 2003 15:39:19 -0300 (ADT) Received: from potentialtech.com ([24.53.179.151]) by mta6.adelphia.net (InterMail vM.5.01.05.32 201-253-122-126-132-20030307) with ESMTP id <20030812183920.FORR8257.mta6.adelphia.net@potentialtech.com> for ; Tue, 12 Aug 2003 14:39:20 -0400 Message-ID: <3F393457.1020003@potentialtech.com> Date: Tue, 12 Aug 2003 14:39:19 -0400 From: Bill Moran User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.3) Gecko/20030429 X-Accept-Language: en-us, en MIME-Version: 1.0 Cc: PgSQL Performance ML Subject: Re: Perfomance Tuning References: <184401c3606b$c7459860$2800a8c0@mars> <3F38D9DE.20174.1E36D1C5@localhost> In-Reply-To: <3F38D9DE.20174.1E36D1C5@localhost> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/215 X-Sequence-Number: 3032 Shridhar Daithankar wrote: > On 11 Aug 2003 at 23:42, Ron Johnson wrote: > > >>On Mon, 2003-08-11 at 19:50, Christopher Kings-Lynne wrote: >> >>>>Well, yeah. But given the Linux propensity for introducing major >>>>features in "minor" releases (and thereby introducing all the >>>>attendant bugs), I'd think twice about using _any_ Linux feature >>>>until it's been through a major version (e.g. things introduced in >>>>2.4.x won't really be stable until 2.6.x) -- and even there one is >>>>taking a risk[1]. >>> >>>Dudes, seriously - switch to FreeBSD :P >> >>But, like, we want a *good* OS... 8-0 > > > Joke aside, I guess since postgresql is pretty much reliant on file system for > basic file functionality, I guess it's time to test Linux 2.6 and compare it. > > And don't forget, for large databases, there is still XFS out there which is > probably the ruler at upper end.. This is going to push the whole thing a little off-topic, but I'm curious to know the answer. Has it ever been proposed or attemped to run PostgreSQL without any filesystem (or any other database for that matter ...). Meaning ... just tell it a raw partition to keep the data on and Postgre would create its own "filesystem" ... obviously, doing that would allow Postgre to bypass all the failings of all filesystems and rely entirely apon its own rules. Or are modern filesystems advanced enough that doing something like that would lose more than it would gain? Just thinking out loud. -- Bill Moran Potential Technologies http://www.potentialtech.com