Re: What is the general opinion on use of tablespaces

On Fri, Jun 10, 2016 at 1:12 PM, Rakesh Kumar <rakeshkumar464a3(at)gmail(dot)com>
wrote:

> > 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.

​David J.​