Bruce Momjian writes: > Thomas, are you going to extend this to locations for any table/index? > Seems whatever we do for WAL should fix in that scheme.
The trick is that it might not. For relations you simply need a system table mapping location names to file system locations, and you can add and remove those mappings at will. Moving an object between locations can be accomplished by locking the object down, moving the files, updating the system catalogs, and unlocking. But the location of the WAL logs, and the commit logs, if anyone is thinking in that direction, needs to be known to initdb. And if you want to move them later you'd need to halt the entire system or implement some smarts for transition. So I'm not sure if these things fit under one umbrella. It would probably be nice if they did. -- Peter Eisentraut [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
