Re: DAFS? - Mailing list pgsql-general

From Vincent Janelle
Subject Re: DAFS?
Date
Msg-id 20021030180028.39a0ec51.random@goblinstudios.com
Whole thread Raw
In response to Re: DAFS?  ("scott.marlowe" <scott.marlowe@ihs.com>)
Responses Re: DAFS?  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
*shrugs*, I use shared attached storage.  Routing this stuff through
nscd (which is what most of those user-space apps do) would be silly.

You'd still need a filesystem on top of it for postgres, which negates
the whole issue.  You'd might was well just use a SAN then.  Netapp
announced that they're adding an option for this, the original poster
might want to look into that.

On Wed, 30 Oct 2002 15:15:01 -0700 (MST)
"scott.marlowe" <scott.marlowe@ihs.com> wrote:

> On Wed, 30 Oct 2002, Vincent Janelle wrote:
>
> > On 30 Oct 2002 08:47:18 -0500
> > Doug McNaught <doug@mcnaught.org> wrote:
> >
> > > Graeme Hinchliffe <graeme@vianetworks.co.uk> writes:
> > >
> > > > but dafs isn't nfs.  we were trialing netapp for storage but are
> > > > going back to local disks as the db ran VERY slowly in
> > > > comparison. dafs should accelerate things from what i have read.
> > >
> > > If it presents a POSIX filesystem API then PG should work OK with
> > > it.
> > >
> > > -Doug
> >
> > Doesn't appear to.  A quick scan of the SDK docs appears as though
> > as if its a direct implementation to access the storage of a device
> > supporting it by applications, such as database servers over a
> > network.. Kinda like raw devices.
>
> Look and see if there's some code out there for your OS (Linux???) to
> mount a remote network device like this in loop back mode.
>
> Then you might be able to let the OS turn it into a file system for
> the database, which would get you caching on the database server box
> at the file system level, but block access across the network for
> speed.
>
> Then test it as thouroughly as an Apollo mission. :-)


pgsql-general by date:

Previous
From: "Craig Sturman"
Date:
Subject: 6.5 data export issues
Next
From: Justin Clift
Date:
Subject: Swedish version of the PostgreSQL "Advocacy and Marketing" site is ready