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
