Re:Debugging PostgreSQL performance the hard way
by nasalgoat on Friday September 30, 2016 @09:31AM
(#12612291)
The secret to EBS is to use General SSD, not Provisioned, but use a RAID stripe.
The reason this works is because IOPS are provisioned per EBS drive and by the size of the drive. So a RAID0 stripe of, say, ten General SSD drives will outperform the more expensive PIOPS single drive.
The reason this works is because IOPS are provisioned per EBS drive and by the size of the drive. So a RAID0 stripe of, say, ten General SSD drives will outperform the more expensive PIOPS single drive.