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