Re: Tablespace setup issue

Laurenz Albe <[email protected]>
Newsgroups gmane.comp.db.postgresql.general
Message-ID <[email protected]>
On Thu, 2019-11-21 at 08:54 -0600, Ron wrote:
> > Don't create tablespaces.
> > Stick with the default tablespace.
> 
> Why?

Because you won't need them.

Tablespaces have a limited number of use cases:
- Distribute I/O across several devices (you can do the same
  on a lower level using striping).
- Put some tables or indexes faster and some on slower storage.
- Provide a size limit for a table or a database.
- Have your temporary files on a different file system.

In a virtualized environment, you never want tablespaces.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.