Re: [PERFORM] Tablespaces and NFS

2007-09-20 Thread Carlos Moreno
About 5 months ago, I did an experiment serving tablespaces out of AFS, another shared file system. You can read my full post at http://archives.postgresql.org/pgsql-admin/2007-04/msg00188.php Thanks for the pointer! I had done a search on the archives, but didn't find this one (strange,

Re: [PERFORM] Tablespaces and NFS

2007-09-20 Thread Peter Koczan
Anyway... One detail I don't understand --- why do you claim that You can't take advantage of the shared file system because you can't share tablespaces among clusters or servers ??? I say that because you can't set up two servers to point to the same tablespace (i.e. you can't have server A

Re: [PERFORM] Tablespaces and NFS

2007-09-20 Thread Carlos Moreno
Thanks again, Peter, for expanding on these points. Peter Koczan wrote: Anyway... One detail I don't understand --- why do you claim that You can't take advantage of the shared file system because you can't share tablespaces among clusters or servers ??? I say that because you can't

[PERFORM] Tablespaces and NFS

2007-09-19 Thread Carlos Moreno
Hi, Anyone has tried a setup combining tablespaces with NFS-mounted partitions? I'm considering the idea as a performance-booster --- our problem is that we are renting our dedicated server from a hoster that does not offer much flexibility in terms of custom hardware configuration; so, the

Re: [PERFORM] Tablespaces and NFS

2007-09-19 Thread Craig James
Carlos Moreno wrote: Anyone has tried a setup combining tablespaces with NFS-mounted partitions? There has been some discussion of this recently, you can find it in the archives (http://archives.postgresql.org/). The word seems to be that NFS can lead to data corruption. Craig

Re: [PERFORM] Tablespaces and NFS

2007-09-19 Thread Peter Koczan
On 9/19/07, Carlos Moreno [EMAIL PROTECTED] wrote: Hi, Anyone has tried a setup combining tablespaces with NFS-mounted partitions? I'm considering the idea as a performance-booster --- our problem is that we are renting our dedicated server from a hoster that does not offer much