Re:Amazon RDS now supports PostgreSQL 9.6.1
by philliphaydon on Tuesday November 15, 2016 @05:58AM
(#12957076)
I tested 9.4 ages ago by polling a table. Upgraded the instance type while in multi az. The down time was about ~14 seconds.
With SQL server it was about ~50seconds.
2 minutes seems like a Long time but I'm curious now and want to test this again and maybe blog about it.
I agree on the IOPS - just get a larger disk (min 100G) even if you'll never use it. Storage is cheap. It's supposed to give you 3k IOPS but doesn't actually give you anywhere near that (but it is still fast). If you do need guaranteed IOPS, then it's wallet-opening time.