From: | Josh Berkus <josh(at)agliodbs(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-hackers(at)postgreSQL(dot)org, pgsql-novice(at)postgreSQL(dot)org, Mija Lee <mija(at)scharp(dot)org> |
Subject: | Re: [HACKERS] PG on NFS may be just a bad idea |
Date: | 2007-10-01 17:13:41 |
Message-ID: | 47012AC5.9040808@agliodbs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs pgsql-hackers pgsql-novice |
Tom,
> Maybe we need to actively discourage people from running Postgres
> against NFS-mounted data directories. Shane Kerr's paper cited above
> mentions some other rather scary properties, including O_EXCL file
> creation not really working properly.
Wouldn't you be describing a Linux-specific issue, though? And possibly
kernel-specific?
It's hard to reconcile this with the real-world performance of
PostgreSQL on NFS, which is happening all over the place. Most notably,
Joe Conway's 20,000 txn/sec.
I *do* think it's an accurate statement that if you're going to use
Postgres, or any other OLTP database, on NFS you'd better have access to
a NAS expert. But to say that it's a bad idea even if you have expert
help is probably going to far.
--Josh Berkus
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-10-01 17:24:41 | Re: [HACKERS] PG on NFS may be just a bad idea |
Previous Message | Zdenek Kotala | 2007-09-29 14:23:59 | Re: PG on NFS may be just a bad idea |
From | Date | Subject | |
---|---|---|---|
Next Message | Gregory Stark | 2007-10-01 17:15:08 | Re: First steps with 8.3 and autovacuum launcher |
Previous Message | Alvaro Herrera | 2007-10-01 17:06:58 | Re: Enforcing database encoding and locale match |
From | Date | Subject | |
---|---|---|---|
Next Message | Wright, George | 2007-10-01 17:19:47 | DST question |
Previous Message | Nis Jørgensen | 2007-10-01 10:19:05 | Re: Why is my view ddl being altered by postgres? |