From: Carlos Moreno <moreno_pg@mochima.com>
To: pgsql-performance@postgresql.org
Subject: Tablespaces and NFS
Date: Wed, 19 Sep 2007 11:58:18 -0400
Message-ID: <46F1471A.1010501@mochima.com> (raw)
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
--
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: moreno_pg@mochima.com
Subject: Re: Tablespaces and NFS
In-Reply-To: <46F1471A.1010501@mochima.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox