> Their main problem to overcome when using them is that they tie PostgreSQL > much more tightly to the underlying configuration of the operating system > and thus you need to ensure that your processes and procedures accommodate > that reality since the tools that PostgreSQL provides can only do so much.
Are you specifically referring to the restore process.
Yes
Tablespaces help distributing large tables in different file systems.
Can you be more precise? A single table can only be placed onto one file system.
Only if those different file systems have different physical characteristics is using a tablespace likely to be a good solution. In other scenarios having some kind of virtual file system overlay at the O/S level and exposed to PostgreSQL is probably a better option.
