[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Sun's lethargy

To: "James A. Peltier" <james@site-fx.net>
Subject: Re: Sun's lethargy
From: Andrew Basterfield <bob@cemetery.homeunix.org>
Date: Tue, 3 Dec 2002 02:36:10 +0000
Cc: obsd-misc@hack.kampbjorn.com, misc@openbsd.org
References: <Pine.BSO.4.44.0212012346120.22053-100000@www.stonehenge-net.com> <E18IqQD-0005Ro-00@skipper.averillpark.net> <3DEBF43D.2080905@hack.kampbjorn.com> <3DEBFD04.8010406@site-fx.net>

On Mon, 02 Dec 2002 16:38:28 -0800
"James A. Peltier" <james@site-fx.net> wrote:

> Hack Kampbjørn wrote:
> 
> >
> > Why would a DBA want the extra overhead of a filesystem and a 
> > journaling one for that case instead of using raw devices, when
> > RDBMS already have their own logs?
> 
> Can MySQL or PostgreSQL write to raw volumes?

No, neither can.

Oracle is (allegedly) faster (on Solaris at least) reading/writing to a
file system than a raw device. Modern file systems are pretty heavily
optimised.

Googling gives more info, I was only looking at this a few days ago, in
relation to PostgreSQL on OpenBSD/sparc64.

--Andrew

[demime 0.98d removed an attachment of type application/pgp-signature]

Follow-Ups:
- Re: Sun's lethargy
  - From: Mark Matthews <mark@mysql.com>

References:
- Re: Sun's lethargy
  - From: ben <ben@stonehenge-net.com>
- Re: Sun's lethargy
  - From: Richard Welty <rwelty@averillpark.net>
- Re: Sun's lethargy
  - From: Hack Kampbjørn <obsd-misc@hack.kampbjorn.com>
- Re: Sun's lethargy
  - From: "James A. Peltier" <james@site-fx.net>

Prev by Date: Re: exec question
Next by Date: Re: exec question
Prev by thread: Re: Sun's lethargy
Next by thread: Re: Sun's lethargy
Index(es):
- Date
- Thread