Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Amazon RDS now supports PostgreSQL 9.6.1

postgresql.org

Post reply on HN
Print view View original

41–50 of 83 posts

Re: Amazon RDS now supports PostgreSQL 9.6.1

#41

Post by markonen »

merb wrote: post #40
markonen wrote: post #39

Earlier quoted context omitted.

In this context it's useful to note that RDS instance pricing is ~50% higher than the pricing for the underlying EC2 instances. That 50% reflects the (pure software) value-add over EC2. When someone like Heroku offers a competing product, the fact that the product is also being run on EC2 is only a part of the overall story. Over time, AWS will probably be less and less happy with earning just the bare infrastructure…

> In this context it's useful to note that RDS instance pricing is ~50% higher than the pricing for the underlying EC2 instances. That 50% reflects the (pure software) value-add over EC2. Just build a HA RDS Cluster yourself with Click and Scale, than you can sell it to me with ~25% higher prices than the EC2 instances. Btw. AWS RDS is cheaper than most other competitors like ElephantSQL.

Just stating a fact about their pricing (in the context of whether Heroku is a competitor or not). Not judging the relative value of the offerings at all. I'm an RDS user, FWIW.

Re: Amazon RDS now supports PostgreSQL 9.6.1

#42

Post by rurounijones »

scrollaway wrote: post #15
wasd wrote: post #3

I'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 :(

At least you have a supported language! (Ruby dev)

Re: Amazon RDS now supports PostgreSQL 9.6.1

#43

Post by brazzledazzle »

philliphaydon wrote: post #31
brazzledazzle wrote: post #16

Earlier quoted context omitted.

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.

We had this issue. Luckily they recently added native backups to s3 so we had 3 hours of downtime to backup a 180gb db and restore to a new 500gb instance.

Jesus. I'm no strategy genius but sometimes it seems like they want to cede the Windows market to Azure. Some of the Windows stuff in AWS seems kind of "me too".

Re: Amazon RDS now supports PostgreSQL 9.6.1

#44

Post by jakobegger »

wasd wrote: post #3

I'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).

There are many options for hosted PostgreSQL.

See for example this staggering list of hosting providers in Europe: https://www.postgresql.org/support/professional_hosting/euro...

Yes, most of those are smaller companies. But some of these companies are directly involved in the development of PostgreSQL (just look at the PostgreSQL-hackers mailing list), so they should really know what they are doing!

Re: Amazon RDS now supports PostgreSQL 9.6.1

#45

Post by jaequery »

are 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.

Re: Amazon RDS now supports PostgreSQL 9.6.1

#46

Post by yuanchuan »

kyleblarson wrote: post #18
psycr wrote: post #6

Now 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)

It is definitely doable. You can refer to this blog post by AWS (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.

Re: Amazon RDS now supports PostgreSQL 9.6.1

#47

Post by pritambarhate »

ngrilly wrote: post #36
pritambarhate wrote: post #13

Earlier quoted context omitted.

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…

> If needs once a week downtime for half an hour for patches. Half an hour downtime once a week? This sounds bad.

I checked the FAQ once again: https://aws.amazon.com/rds/faqs/

Here are the exact words from Amazon:

> The Amazon RDS maintenance window is your opportunity to control when DB Instance modifications (such as scaling DB Instance class) and software patching occur, in the event they are requested or required. If a maintenance event is scheduled for a given week, it will be initiated and completed at some point during the maintenance window you identify. Maintenance windows are 30 minutes in duration. The only maintenance events that require Amazon RDS to take your DB Instance offline are scale compute operations (which generally take only a few minutes from start-to-finish) or required software patching. Required patching is automatically scheduled only for patches that are security and durability related. Such patching occurs infrequently (typically once every few months) and should seldom require more than a fraction of your maintenance window. If you do not specify a preferred weekly maintenance window when creating your DB Instance, a 30 minute default value is assigned. If you wish to modify when maintenance is performed on your behalf, you can do so by modifying your DB Instance in the AWS Management Console, the ModifyDBInstance API or the modify-db-instance command. Each of your DB Instances can have different preferred maintenance windows, if you so choose.

Running your DB Instance as a Multi-AZ deployment can further reduce the impact of a maintenance event. Please refer to the Amazon RDS User Guide for more information on maintenance operations.

Re: Amazon RDS now supports PostgreSQL 9.6.1

#50

Post by jonatron »

qaq wrote: post #11
thejosh wrote: post #4

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.

It'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.
Post reply on HN