Fernando Schapachnik wrote:
I could play soft links tricks, but I'm afraid of paying the FS-traversal penalty on each file access (is that right?).
Compared to everything else that goes into I/O, symlink traversal overhead is pretty low.
So, any way of instructing PG (8.1 if that matters) to place those files elsewhere without an initdb?
You can create another table just like the original on a tablespace using the new storage, drop the original, and then rename the new one to the original name. This is described as "another way to cluster data" in the Notes section of http://www.postgresql.org/docs/8.4/static/sql-cluster.html , and it has a few warnings related to information that can be lost in this situation. Make sure you've moved all temporary files onto the new filesystem first, observing the warning about that there too.
-- Greg Smith 2ndQuadrant Baltimore, MD PostgreSQL Training, Services and Support greg@xxxxxxxxxxxxxxx www.2ndQuadrant.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
