From: Bill Moran <wmoran@potentialtech.com>
Cc: PgSQL Performance ML <pgsql-performance@postgresql.org>
Subject: Re: Perfomance Tuning
Date: Tue, 12 Aug 2003 14:39:19 -0400
Message-ID: <3F393457.1020003@potentialtech.com> (raw)
In-Reply-To: <3F38D9DE.20174.1E36D1C5@localhost>
References: <184401c3606b$c7459860$2800a8c0@mars>
<3F38D9DE.20174.1E36D1C5@localhost>
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
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: wmoran@potentialtech.com
Subject: Re: Perfomance Tuning
In-Reply-To: <3F393457.1020003@potentialtech.com>
References: <184401c3606b$c7459860$2800a8c0@mars> <3F38D9DE.20174.1E36D1C5@localhost> <3F393457.1020003@potentialtech.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