51–60 of 83 posts
Earlier quoted context omitted.
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...
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…
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…
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.
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'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!
Earlier quoted context omitted.
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)
On a slightly tangential topic, what is Amazon doing with aurora?
Does 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?
Earlier quoted context omitted.
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.
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
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.