Re: Better I/O throughput? (was Re: create tablespace - cannot run inside a transaction block)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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






[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux