From: Jurgen Haan <jurgen@easyflex.nl>
Cc: PGSQL Performance <pgsql-performance@postgresql.org>
Subject: Re: PostgreSQL NetApp and NFS
Date: Tue, 25 Mar 2008 14:33:23 +0100
Message-ID: <47E8FF23.2010905@easyflex.nl> (raw)
In-Reply-To: <1d219a6f0803201232g54924fb3ka206c9b03e4664c7@mail.gmail.com>
References: <1d219a6f0803201232g54924fb3ka206c9b03e4664c7@mail.gmail.com>
Well, we're not running PGSQL on a Netapp over NFS, but a DB2 Database.
But nevertheless, it runs quite well. NFS is not a bad choice for your
database, the big memory buffer that allocates the raid6 blocks makes it
all very quick, like you're working directly on a 1+ TB ramdisk.
One important thing to keep in mind, is to make sure the NFS protocol
used is at least V3 and to check your locking options.
This made our DB2 crash, because when configured wrong, the file locking
mechanism on an NFS mount behaves differently than that of the local
storage. These parameters can be forced from the client side (fstab).
But still, with our 100+ GB OLTP database, I'm still quite fond of our
netapp.
-R-
Chris Hoover wrote:
> I just found out that my company is planning on migrating my databases
> from our current ISCSI storage solution to NetApps connected via NFS. I
> knew about the NetApp migration, but always assumed (and shame on me)
> that I would have direct attachments to the servers.
>
> Chris
> --
> Come see how to SAVE money on fuel, decrease harmful emissions, and even
> make MONEY. Visit http://colafuelguy.mybpi.com and join the revolution!
--
Easyflex diensten b.v.
Acaciastraat 16
4921 MA MADE
T: 0162 - 690410
F: 0162 - 690419
E: info@easyflex.nl
W: http://www.easyflex.nl
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 using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jurgen@easyflex.nl
Subject: Re: PostgreSQL NetApp and NFS
In-Reply-To: <47E8FF23.2010905@easyflex.nl>
* 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