Re: [PERFORM] PostgreSQL NetApp and NFS

2008-03-25 Thread Jurgen Haan
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 thi

Re: [PERFORM] PostgreSQL NetApp and NFS

2008-03-21 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> Aside from what's said there, I'd note that it's a seriously bad idea > >> to use a "soft mount" or any arrangement wherein it's possible for > >> Postgres to be running while the NFS disk is not mounted. > > > Do

Re: [PERFORM] PostgreSQL NetApp and NFS

2008-03-21 Thread Gregory Stark
"Dawid Kuroczko" <[EMAIL PROTECTED]> writes: > It is also possible to present block devices from NetApp over iSCSI or FC > (I am not sure about licensing model though). You get all the goodies > like thin provisioning (only non-zero blocks are allocated), snapshots and > all, but you see it as a

Re: [PERFORM] PostgreSQL NetApp and NFS

2008-03-21 Thread Dawid Kuroczko
On Thu, Mar 20, 2008 at 8:32 PM, Chris Hoover <[EMAIL PROTECTED]> 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

Re: [PERFORM] PostgreSQL NetApp and NFS

2008-03-20 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> Aside from what's said there, I'd note that it's a seriously bad idea >> to use a "soft mount" or any arrangement wherein it's possible for >> Postgres to be running while the NFS disk is not mounted. > Do the docs need updating for th

Re: [PERFORM] PostgreSQL NetApp and NFS

2008-03-20 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Chris Hoover wrote: > >> If you have any real life good or bad stories, I'd love to hear it. Given > >> the NetApp arrays supposedly being very good NFS platforms, overall, is > >> this > >> a recommended way to run PostgreSQL, or is

Re: [PERFORM] PostgreSQL NetApp and NFS

2008-03-20 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Chris Hoover wrote: >> If you have any real life good or bad stories, I'd love to hear it. Given >> the NetApp arrays supposedly being very good NFS platforms, overall, is this >> a recommended way to run PostgreSQL, or is it recommended to not run this

Re: [PERFORM] PostgreSQL NetApp and NFS

2008-03-20 Thread Frits Hoogland
My experience postgresql work good on NFS. Of course, use NFS over TCP, and use noac if you want to protect your database even more (my experience is NFS client caching doesn't lead to an irrecoverable database however) I've encountered problems with RHEL4 as a database server and a client of a Ne

Re: [PERFORM] PostgreSQL NetApp and NFS

2008-03-20 Thread Woody Woodring
> I need to know if anyone out there is/has run their PostgreSQL on NetApp arrays via NFS. My particular situation is RH Linux 4 servers running Postgresql 8.1. I need > to provide our Operations manager with specific reasons why we should not run PostgreSQL over NetApp NFS. Otherwise, they

Re: [PERFORM] PostgreSQL NetApp and NFS

2008-03-20 Thread Bruce Momjian
Chris Hoover wrote: > If you have any real life good or bad stories, I'd love to hear it. Given > the NetApp arrays supposedly being very good NFS platforms, overall, is this > a recommended way to run PostgreSQL, or is it recommended to not run this > way. We do have an NFS section in our docume

[PERFORM] PostgreSQL NetApp and NFS

2008-03-20 Thread Chris Hoover
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. Well, I am very uncomfortable w