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

31–40 of 83 posts

Re: Amazon RDS now supports PostgreSQL 9.6.1

#31

Post by philliphaydon »

brazzledazzle wrote: post #16
ramenmeal wrote: post #9

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

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.

Re: Amazon RDS now supports PostgreSQL 9.6.1

#32

Post by vacri »

pritambarhate wrote: post #13
thejosh wrote: post #4

What'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…

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

Re: Amazon RDS now supports PostgreSQL 9.6.1

#33

Post by ignoramous »

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

Heroku isn't a competitor to AWS, AFAIK. They're a partner.

Re: Amazon RDS now supports PostgreSQL 9.6.1

#34

Post by eloff »

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

Compose (an IBM company) does managed Postgres.

Re: Amazon RDS now supports PostgreSQL 9.6.1

#35

Post by wasd »

ignoramous wrote: post #33
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).

Heroku isn't a competitor to AWS, AFAIK. They're a partner.

Sorry, I'm not sure what you mean. It used to be the case that Heroku is/was built on EC2. They also offered a managed database (Heroku Postgres) built on EC2. Do you mean they're a partner because they're building a product on top of EC2?

Re: Amazon RDS now supports PostgreSQL 9.6.1

#36

Post by ngrilly »

pritambarhate wrote: post #13
thejosh wrote: post #4

What'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…

> If needs once a week downtime for half an hour for patches.

Half an hour downtime once a week? This sounds bad.

Re: Amazon RDS now supports PostgreSQL 9.6.1

#37

Post by [deleted] »

brazzledazzle wrote: post #23
dorfsmay wrote: post #22

Earlier quoted context omitted.

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

Yep, 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. A…

[deleted]

Re: Amazon RDS now supports PostgreSQL 9.6.1

#38

Post by scrollaway »

tbrock wrote: post #26
Rezo wrote: post #14

Earlier quoted context omitted.

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

Yeah they only added 9.5 a couple weeks ago, very recently.

That'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-postg...

Re: Amazon RDS now supports PostgreSQL 9.6.1

#39

Post by markonen »

ignoramous wrote: post #33
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).

Heroku isn't a competitor to AWS, AFAIK. They're a partner.

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 dollars for such use.

Re: Amazon RDS now supports PostgreSQL 9.6.1

#40

Post by merb »

markonen wrote: post #39
ignoramous wrote: post #33

Earlier quoted context omitted.

Heroku isn't a competitor to AWS, AFAIK. They're a partner.

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.

Post reply on HN