Tablespaces and NFS
От | Carlos Moreno |
---|---|
Тема | Tablespaces and NFS |
Дата | |
Msg-id | 46F1471A.1010501@mochima.com обсуждение исходный текст |
Ответы |
Re: Tablespaces and NFS
Re: Tablespaces and NFS |
Список | pgsql-performance |
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 *ideal* alternative to load the machine with 4 or 6 hard drives and use tablespaces is off the table (no pun intended). We could, however, set up a few additional servers where we could configure NFS shares, mount them on the main PostgreSQL server, and configure tablespaces to "load balance" the access to disk. Would you estimate that this will indeed boost performance?? (our system does lots of writing to DB --- in all forms: inserts, updates, and deletes) As a corollary question: what about the WALs and tablespaces?? Are the WALs "distributed" when we setup a tablespace and create tables in it? (that is, are the WALs corresponding to the tables in a tablespace stored in the directory corresponding to the tablespace? Or is it only the data, and the WAL keeps being the one and only?) Thanks, Carlos --
В списке pgsql-performance по дате отправления: