What's the performance of Amazon RDS like with Postgres? (Curious, never having used it).
You max out at 30,000 IOPS so about 1/3 of consumer grade SSD or 1/10 of a decent PCIE SSD.
Amazon RDS now supports PostgreSQL 9.6.1
11–20 of 83 posts
Re: Amazon RDS now supports PostgreSQL 9.6.1
#12On a slightly tangential topic, what is Amazon doing with aurora?
Re: Amazon RDS now supports PostgreSQL 9.6.1
#13What's the performance of Amazon RDS like with Postgres? (Curious, never having used it).
For 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.
Re: Amazon RDS now supports PostgreSQL 9.6.1
#14This happened a couple days ago, noticed when spinning up a new RDS instance. I'm super excited about it. It's great to have more modern managed services on AWS especially since this brings Postgres out of the Stone Age. Lots of good JSON support added in 9.5 and 9.6. Previously only 9.4 was available.
9.5 was actually added to RDS back in April [0]. There was some serious bugs found that made them wait for 9.5.2 before adding it [1]. As a customer of RDS, I'm really happy that they're taking their time to thoroughly test the releases.
[0] https://aws.amazon.com/about-aws/whats-new/2016/04/rds-postg... [1] https://forums.aws.amazon.com/thread.jspa?threadID=240278
Re: Amazon RDS now supports PostgreSQL 9.6.1
#15I'm fairly impressed by RDS's turn around time. 9.6 dropped in late September and they're already supporting it in just over a month. I wish Google Cloud SQL supported Postgres at all. Sad that there's limited competition in managed postgres space (most notable competitor being Heroku).
Boy do I wish they had the same turnaround time on AWS Lambda Python versions. Still stuck on 2.7 :(
Re: Amazon RDS now supports PostgreSQL 9.6.1
#16I'm fairly impressed by RDS's turn around time. 9.6 dropped in late September and they're already supporting it in just over a month. I wish Google Cloud SQL supported Postgres at all. Sad that there's limited competition in managed postgres space (most notable competitor being Heroku).
Meanwhile, SQL Server on RDS doesn't support increasing the data allocation. You can't even take a snapshot and restore to a new, larger, RDS instance. Oh and by the way, SQL Server has been "supported" since 2012. Obviously it's not their focus, but this is a fundamental selling point to cloud DB's.
That's pretty lame. Do you happen to know if you can you create an AAG with a larger volume on the replica and cut it over? I don't even remember if that's possible with your own SQL Server AAG, it's been a while. At any rate, thanks for commenting about this. I'm going to need to look into this at some point in the near future so your timing was fortuitous.
Re: Amazon RDS now supports PostgreSQL 9.6.1
#17Does anyone else have abysmal IO performance on postgres RDS? I have a 200 gb provisioned ssd with 2000 iops and get abysmal bulk read performance - the panel will report 30 mb/s and query speed is really slow with disk being the bottleneck
Re: Amazon RDS now supports PostgreSQL 9.6.1
#18Now they just need to support the Foreign Data Wrapper extension with egress connections. Really wish that was built in because FDW itself is amazing, and AWS RDS is easy to manage.
Agree 100%. Would be awesome if you could have RDS with FDW connected to a Redshift instance. (don't know if that's possible given the version of Postgres upon which Redshift is based)
Re: Amazon RDS now supports PostgreSQL 9.6.1
#19I'm fairly impressed by RDS's turn around time. 9.6 dropped in late September and they're already supporting it in just over a month. I wish Google Cloud SQL supported Postgres at all. Sad that there's limited competition in managed postgres space (most notable competitor being Heroku).
Yeah Google Cloud SQL's lack of Postgres support really stings. Would be great to see them branch out a bit.
I suppose they have more experience with MySQL given that Youtube runs on it...
Re: Amazon RDS now supports PostgreSQL 9.6.1
#20Earlier quoted context omitted.
Meanwhile, SQL Server on RDS doesn't support increasing the data allocation. You can't even take a snapshot and restore to a new, larger, RDS instance. Oh and by the way, SQL Server has been "supported" since 2012. Obviously it's not their focus, but this is a fundamental selling point to cloud DB's.
That's pretty lame. Do you happen to know if you can you create an AAG with a larger volume on the replica and cut it over? I don't even remember if that's possible with your own SQL Server AAG, it's been a while. At any rate, thanks for commenting about this. I'm going to need to look into this at some point in the near future so your timing was fortuitous.
In short, I don't know. However, I highly doubt it. Most of these features/permissions are disabled when you use RDS. For example you can't take a snapshot through SSMS, you have to use the AWS console.