I wrote:
>Jeff Janes wrote:
All that said, there has always been a recommendation of caution around
using NFS as a backing store for PG, or any RDBMS..
>>>
>>> I know that Oracle recommends it - they even built an NFS client
>>> into their database server to make the most of it.
>
>> Why would they implement their own client? Did they have to do something
>> special in their client to
>> make it safe?
>
> I think it is mostly a performance issue. Each backend mounts its own copy
> of the data files it needs.
I personally would never put PostgreSQL on an NFS share on Li
On Tue, May 27, 2014 at 4:06 AM, Albe Laurenz wrote:
> I just learned that NFS does not use a file system cache on the client
> side.
>
That's ... incorrect. NFS is cache-capable. NFSv3 (I think? It may have
been v2) started sending metadata on file operations that was intended to
allow for clien
Jeff Janes wrote:
>>> All that said, there has always been a recommendation of caution around
>>> using NFS as a backing store for PG, or any RDBMS..
>>
>> I know that Oracle recommends it - they even built an NFS client
>> into their database server to make the most of it.
>
> Last I h
John Melesky wrote:
>> I just learned that NFS does not use a file system cache on the client side.
>
> That's ... incorrect. NFS is cache-capable. NFSv3 (I think? It may have been
> v2) started sending
> metadata on file operations that was intended to allow for client-side
> caches. NFSv4 adde
On Tue, May 27, 2014 at 4:06 AM, Albe Laurenz wrote:
> I just learned that NFS does not use a file system cache on the client
> side.
>
My experience suggested that it did something a little weirder than that.
It would cache read data as long as it was clean, but once the data was
dirtied and wr
On Tue, May 27, 2014 at 8:00 AM, Albe Laurenz wrote:
> Stephen Frost wrote:
> > All that said, there has always been a recommendation of caution around
> > using NFS as a backing store for PG, or any RDBMS..
>
> I know that Oracle recommends it - they even built an NFS client
> into their database
On 5/27/2014 9:09 AM, Shaun Thomas wrote:
On 05/27/2014 10:00 AM, Albe Laurenz wrote:
I know that Oracle recommends it - they even built an NFS client
into their database server to make the most of it.
That's odd. Every time the subject of NFS comes up, it's almost
immediately shot down wit
On 05/27/2014 10:00 AM, Albe Laurenz wrote:
I know that Oracle recommends it - they even built an NFS client
into their database server to make the most of it.
That's odd. Every time the subject of NFS comes up, it's almost
immediately shot down with explicit advice to Never Do That(tm). It c
Stephen Frost wrote:
> All that said, there has always been a recommendation of caution around
> using NFS as a backing store for PG, or any RDBMS..
I know that Oracle recommends it - they even built an NFS client
into their database server to make the most of it.
Yours,
Laurenz Albe
--
Sent vi
* Heikki Linnakangas (hlinnakan...@vmware.com) wrote:
> On 05/27/2014 02:06 PM, Albe Laurenz wrote:
> >I just learned that NFS does not use a file system cache on the client side.
> >
> >On the other hand, PostgreSQL relies on the file system cache for
> >performance,
> >because beyond a certain a
On 05/27/2014 02:06 PM, Albe Laurenz wrote:
I just learned that NFS does not use a file system cache on the client side.
On the other hand, PostgreSQL relies on the file system cache for performance,
because beyond a certain amount of shared_buffers performance will suffer.
Together these thing
12 matches
Mail list logo
