On 2010-12-28, Ozz Nixon <ozznixon@xxxxxxxxx> wrote: > Is it possible (and how) to implement a data path on another partition (linux) for an existing system? And then if I do not gain anything, merging it to the production /data path? tablespaces > Scenario of what I want to achieve (/mnt/data is already running) > > /mnt/data resides on an NFS share > Contains over 2 Billion web sites crawled (yeah another search-engine site) using postgres on nfs is not recommended, > want to add: > > /opt/data resides on internal drive > Will contain keyword hash system local is good. > Then if I find this does not improve anything - or runs tight >(running on IBM Blade center with 76gb internals - so I may be >limited), that I can simple shutdown postgres, scp /opt/data/folder/ >to the NFS - bring up postgres - fix any conf file, and everything is >on the multi-terabyte array? or leave postgres running and just copy the table using "select * into" or similar. it's possibly better to use iSCSI instead of NFS, it's not like you can share the data directory. -- ââ 100% natural -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general