Re: What is the general opinion on use of tablespaces
| От | David G. Johnston |
|---|---|
| Тема | Re: What is the general opinion on use of tablespaces |
| Дата | |
| Msg-id | CAKFQuwYDYwpD3Tzyawt4CdDs023FuqPdJwPt=zaASfNGty-zXg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: What is the general opinion on use of tablespaces (Rakesh Kumar <rakeshkumar464a3@gmail.com>) |
| Ответы |
Re: What is the general opinion on use of tablespaces
|
| Список | pgsql-general |
> 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.
В списке pgsql-general по дате отправления: