On Wed, 2019-09-25 at 14:40 -0500, Ron wrote:
> > No, normally you don't create tablespaces in PostgreSQL.
> > They are a few use cases for them, but not many.
>
> Do I/O requests in the Linux kernel get "backlogged" when they all
> hit the
> same device? Or would you get better throughput (or less latency)
> by
> spreading the load across multiple devices?
Sure, spreading I/O across multiple devices is one use case for
tablespaces. But usually this is easier to do by striping a
logical volume across several physical volumes at a lower level.
Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com