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

61–70 of 83 posts

Re: Amazon RDS now supports PostgreSQL 9.6.1

#61

Post by vacri »

philliphaydon wrote: post #52
vacri wrote: post #32

Earlier quoted context omitted.

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 wal…

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

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

Re: Amazon RDS now supports PostgreSQL 9.6.1

#62

Post by fuhrysteve »

boyd wrote: post #29
kstrauser wrote: post #10

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

Another option is to use Aptible: 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!

But 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

Re: Amazon RDS now supports PostgreSQL 9.6.1

#64

Post by craigkerstiens »

theptip wrote: post #19
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).

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

It looks like it's pretty clear recently that Postgres support in some form from Google is coming - https://code.google.com/p/googlecloudsql/issues/detail?id=96

Re: Amazon RDS now supports PostgreSQL 9.6.1

#65

Post by ZitchDog »

fuhrysteve wrote: post #62
boyd wrote: post #29

Earlier quoted context omitted.

Another option is to use Aptible: 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!

But 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

Aptible absolutely has managed postgres, and it's great. I'm using it at this very second.

Re: Amazon RDS now supports PostgreSQL 9.6.1

#66

Post by fuhrysteve »

ZitchDog wrote: post #65
fuhrysteve wrote: post #62

Earlier quoted context omitted.

But 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

Aptible absolutely has managed postgres, and it's great. I'm using it at this very second.

Where can I find out more? All I see on their marketing site is "database containers" which I interpreted as little more than a container that happens to run a database, not as something that manages backups, point-in-time restoration, multi-az failover, upgrades, and all the other things that RDS has built in that many folks would otherwise prefer to have an (expensive) postgres specialist setup and manage for you.

Re: Amazon RDS now supports PostgreSQL 9.6.1

#67

Post by estefan »

snissn wrote: post #17

Does 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

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

Re: Amazon RDS now supports PostgreSQL 9.6.1

#68

Post by oskari »

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 multiple DB-as-a-Service services that provide PostgreSQL in Google Cloud. My company, Aiven (https://aiven.io) is one of the providers and I believe DatabaseLabs and ElephantSQL also provide managed PG in Google Cloud.

Re: Amazon RDS now supports PostgreSQL 9.6.1

#69

Post by oskari »

tokenizerrr wrote: post #54
jakobegger wrote: post #44

Earlier quoted context omitted.

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!

Do people really talk to databases over WAN (which means relatively high latency)? I was under the impression this was a bad idea.

Many of the hosting providers provide PG as a service in multiple clouds / hosting providers allowing you to run your applications on your own VMs in the same cloud. So while you would be using the external IP addresses to communicate with the database it'd still be in the same datacenter.

Also, as pointed out in the parent post, some of the hosting providers such as us (Aiven, https://aiven.io) are directly involved in PostgreSQL development and one of the bugfixes in the latest releases (9.6.1 and 9.5.5) that just came out was contributed by us.

Re: Amazon RDS now supports PostgreSQL 9.6.1

#70

Post by wasd »

jakobegger wrote: post #44
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!

That's a great point. I've heard of some smaller companies (compose, elephantsql) but to be honest, I have definitely not considered them. The reason is that I just want all inclusive solution and I don't have much context for these companies. How healthy they are, what's the likelyhood of them going out of business, etc.

I think you bring up a good point. I'm going to put aside my bias and give a smaller company a shot. Thanks for sharing.

Post reply on HN