6 ms·
What's the performance of Amazon RDS like with Postgres? (Curious, never having used it).
by thejosh 10y ago
What's the performance of Amazon RDS like with Postgres? (Curious, never having used it).
- sheeshkebab 10y agoit's fine if you can leave with not doing any DBA stuff
- psycr 10y agoYou pay for the underlying instances + storage provisioning, so performance is price-configurable.
- bigdubs 10y agoIt's basically what you get from a well configured EC2 instance.
- qaq 10y agoYou max out at 30,000 IOPS so about 1/3 of consumer grade SSD or 1/10 of a decent PCIE SSD.
- jonatron 10y agoIt's frustrating that AWS doesn't offer something ideal for databases. Databases should be run with fast local storage, on reliable dedicated hardware. VM instances on shared hardware that may be retired at short notice aren't ideal.
- hagbarddenstore 10y agox and i instances.
- pjlegato 10y agoWe (databaselabs.io) did some customer dev tests for that exact product (databases with fast local hardware storage.) We found that almost all customers didn't care about getting that level of performance (enough to pay for it, anyway.) For ~99%, cloud-level shared storage is all they'll pay for. Finding the other 1% is a very expensive long-cycle sales and marketing proposition, so we decided to market cloud solutions to the 99%. That said, we are equipped to run the 'fast dedicated hardware' solution (we come from a managed services background) -- just write me, pjlegato at databaselabs.io, and I'll get you set up.
- pritambarhate 10y agoFor small to medium volume apps it's quite good. The security configuration out of the box is quite good. All standard options like changing pgsql port, opening it up to only your main dB instance is supported. If needs once a week downtime for half an hour for patches. But if you use multi AZ deployment with 2 instances it does this without any actual downtime. Automatically manages the failover for you. Provisioned IOPS are very expensive. For small loads use bigger general purposes SSD say 100 to 200gb and it works OK. The IOPS are burstable so it works out OK.
- vacri 10y agoI don't know about RDS psql, but RDS mysql multi-AZ does have up to 2 mins downtime when switching masters. We see that when scaling up our staging for loadtesting. 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.
- philliphaydon 10y agoI 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.
- vacri 10y agoI haven't tried for a while - my method for outage detection was simply trying to make a connection. It wasn't always 2 min, but usually somewhere between 1-2 min (never more, though).
- ngrilly 10y ago> If needs once a week downtime for half an hour for patches. Half an hour downtime once a week? This sounds bad.