12 ms·
Amazon RDS now supports PostgreSQL 9.6.1
- tbrock 10y agoThis 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.
- Rezo 10y ago9.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-postgresql-9-5-support/ https://aws.amazon.com/about-aws/whats-new/2016/04/rds-postg... [1] https://forums.aws.amazon.com/thread.jspa?threadID=240278 https://forums.aws.amazon.com/thread.jspa?threadID=240278
- tbrock 10y agoYeah they only added 9.5 a couple weeks ago, very recently.
- scrollaway 10y agoThat's simply not true. We've been running with Postgresql 9.5 since May. Apparently it was added in April: https://aws.amazon.com/about-aws/whats-new/2016/04/rds-postgresql-9-5-support/ https://aws.amazon.com/about-aws/whats-new/2016/04/rds-postg...
- philliphaydon 10y agoI think he meant 9.6 which would make more sense.
- wasd 10y agoI'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).
- ramenmeal 10y agoMeanwhile, 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.
- brazzledazzle 10y agoThat'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.
- ramenmeal 10y agoIn 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.
- dorfsmay 10y agoI'm assuming MS SQL? Isn't much cheaper to run it on an instance yourself if you have company licenses? And I suspect people who don't already have licenses run postgres or mysql.
- brazzledazzle 10y agoYep, MS SQL Server. I think that's something you have to determine on a case-by-case basis. If you have Software Assurance you can run it on any instance but if you don't you have to pay Amazon for dedicated hardware. As usual Microsoft's enterprise licensing is pretty much shit. You might also incur more operations overhead than you can afford by having to deal with patching, outages, performance degradation, etc. And your management might want to engage in a slide deck circle jerk with animations about how modern and in the cloud you are by using RDS so that's worth throwing a few $30K+SA enterprise proc licenses away.
- thejosh 10y agoWhat'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.
- psycr 10y agoNow 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.
- kyleblarson 10y agoAgree 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)
- numlocked 10y agoYou can definitely do FDWs to Other Postgres instances, and since I think you can just point the same wrapper to redshift and voila.
- yuanchuan 10y agoIt is definitely doable. You can refer to this blog post by AWS (https://aws.amazon.com/blogs/big-data/join-amazon-redshift-and-amazon-rds-postgresql-with-dblink/ https://aws.amazon.com/blogs/big-data/join-amazon-redshift-a...) to set up FDW to Redshift. What is more exciting is you can leverage Redshift MPP architecture with this method.
- kstrauser 10y agoAnd is it HIPAA certified yet? Because the lack of that is what made me spend a week porting a project to use RDS/MySQL just a little while ago. We've been told it's coming Real Soon Now since last year. I wanted to use PostgreSQL for a whole host of reasons, but not so much that we wanted to certify our own instances.
- johladam 10y agoAlthough dirty, you could still technically use Postgres I believe, you would just need to run it on EC2 and EBS instead. The covered services for the BAA include EC2 and EBS, so you would still be covered under the signed BAA with Amazon. When it is eventually covered under the BAA, you could port over to Postgres RDS.
- boyd 10y agoAnother option is to use Aptible: https://www.aptible.com/ https://www.aptible.com/ It's basically (a better) Heroku with an emphasis on enabling HIPAA/HITECH compliance. They do both app and DB hosting (including Postgres). And it's on AWS so integrates easily with existing infrastructure/code. Disclaimer: Biased as I know the founders and we use the product. But they are good people and it's a good product!
- fuhrysteve 10y agoBut aptible doesn't have managed postgres. I still have to do all the work of setting up a database and managing backups, upgrades, etc. The only thing aptible brings to the table is single tenant hardware and encryption by default. I can just get that from Amazon. Am I missing something about aptible? I don't understand the attraction although it does look fancy
- ZitchDog 10y agoAptible absolutely has managed postgres, and it's great. I'm using it at this very second.
- 10y ago
- enahs-sf 10y agoOn a slightly tangential topic, what is Amazon doing with aurora?
- RhodesianHunter 10y agoSo far good things IMO. Released a new version recently, the performance has been outstanding.
- sudhirj 10y agoAurora supports MySQL so far, heard lots of good things about it. Hopefully they'll put Postgres on it soon.
- snissn 10y agoDoes 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
- slagfart 10y agoAny indexes on the table? Are you using COPY, INSERT INTO or /COPY via PSQL?
- dhd415 10y agoI'm using RDS MySQL and have never been able to utilize more than ~25% of the provisioned IOPS or more than 100MB/s transfer rate. Also, as best as I can tell, EBS latency is pretty high so making lots of small, serial database calls is a lot slower than it would be on local disks.
- estefan 10y agoIIRC there are various tricks you used to have to perform to get it to strip across different disks in the backend. Something along the lines of allocating 20% of your storage and then increasing it 5 times until you had what you wanted. If you provisioned a server immediately to full capacity you'd end up with your data too close together which degraded performance. That's something I heard that used to be true but not sure whether it's still required with upgrades to S3 over the years...
- dhd415 10y agoInteresting, I've never heard of striping tricks like that. Do you have any links on that? And I suppose that could be applicable to EBS since it rather than S3 is the backing store for RDS.
- estefan 10y agoSorry I don't have links. But yes, I think it was primarily to improve the performance of EBS, not S3 (been a while since I had to work on that sort of thing).
- rodgerd 10y agoOut of interest, do Amazon send anything upstream to the pg team?
- IndianAstronaut 10y agoDoes this indicate if it will include a REST API to build some quick applications off of or is it easier to return a JSON from a query?
- pmontra 10y agoI dont think so but you might look at https://www.postgresql.org/about/news/1616/https://www.postgresql.org/about/news/1616/ https://www.postgresql.org/about/news/1616/https://www.postg...
- jaequery 10y agoare there any other companies out there that provide hosting with multi-regional failovers? i love RDS and it's fine for mission critical stuffs but sometimes i just don't want to fork so much money on smaller projects and need an alternative.
- bvrlt 10y agoHow does this compare to Heroku PostgreSQL? It seems to be that it's cheaper but it's hard to compare without knowing what the Heroku instances are.
- asah 10y agoI upgraded - took <10mins and also upgraded instance types. One slow query (that parallelizes) is 3x faster with no SQL changes or new indices.
- JoshGlazebrook 10y agoI wish Azure would launch hosted Postgres.
- edpichler 10y agoAnyone using Amazon RDS in production and satisfied?