Live data from Hacker News

AWS cancels serverless Postgres service that scales to zero

datanami.com

41–50 of 101 posts

Re: AWS cancels serverless Postgres service that scales to zero

#41

Honest question, why not just use dynamodb? If I'm already mostly server less and AWS, dynamodb seems like a natural choice for a persistent store in a world where cost and zero-scaling is important.

DynamoDB is _fantastic_ for certain scenarios. But, you also need to know your access patterns upfront and more or less end up hardcoding your indexes into the "table design". It's not a 1:1 replacement for a typical relational DB's use cases.

Re: AWS cancels serverless Postgres service that scales to zero

#43
post #30
post #10

I guess a good opportunity for someone to build a good alternative. Although it's hard to get it right because if you scale to 0 people will complain about latency and if you don't it's not really serverless.

I think the problem is that we're trying to take paradigms that are designed to be serverful (is that a word?) and shoe-horn them into working in a serverless way.

(Neon CEO).

It's possible and here is the recipe: https://twitter.com/nikitabase/status/1725394843285766463

Re: AWS cancels serverless Postgres service that scales to zero

#44

Honest question, why not just use dynamodb? If I'm already mostly server less and AWS, dynamodb seems like a natural choice for a persistent store in a world where cost and zero-scaling is important.

That's like telling people to use S3, those are completely different storage systems.

Re: AWS cancels serverless Postgres service that scales to zero

#45
post #6

Serverless V2 is also shit. The minimal one equivalent ACU to a regular instance has lots of latency spikes and much slower than a t3 instance. We also tried serverless Redis. We have a tiny machine at %10 CPU utilization, but sustained queries. It costs 20x more. We were very afraid of the result we just ran it for an hour to get an idea. Serverless, pay per use sounds only good if you have very few or unusual traff…

> Serverless, pay per use sounds only good if you have very few or unusual traffic.

And most of those cases can be handled by a $5 a month instance. Thus, usually, the most serverless can save you is $5 a month.

I suppose the real appeal of serveless is you don't have to worry about maintaining the server, doing updates, etc.

Re: AWS cancels serverless Postgres service that scales to zero

#46
post #14

Reminder that AWS Aurora claims to have broken the CAP theorem. The literature doesn’t clarify whether they are consistent or available, and when you ask AWS directly, they tell you the CAP theorem isn’t relevant due to the way Aurora is built. They claim 99.99% availability or whatever the figure is, that it’s self healing, allows up to 2 replicas to be down for write availability and 3 replicas to be down for read…

I've not seem them claim to have broken CAP. AWS is quite an academic organization I think it'd be quite unlikely for them to say something like that.

They do actually provide quite a lot of detail about Aurora storage this works. This 2019 reinvent talk gets pretty deep into the weeds.

https://www.youtube.com/watch?v=uaQEGLKtw54

https://d1.awsstatic.com/events/reinvent/2019/REPEAT_Amazon_...

Re: AWS cancels serverless Postgres service that scales to zero

#47
I started using the smallest VM I can that's free. On google cloud it's 1 GB RAM, 30 GB hard drive, small CPU. I run apt install -y postgresql after I create it and run my golang app and the database ON THE SAME VM! It's amazing how much you can do with that all for free.

Re: AWS cancels serverless Postgres service that scales to zero

#48
post #34
post #10

I guess a good opportunity for someone to build a good alternative. Although it's hard to get it right because if you scale to 0 people will complain about latency and if you don't it's not really serverless.

I mean if you scale to 0, you should expect cold start latency.

Well yes and no if you had enough resources imaging something like Spanner but highly optimised for multi-tenancy. There will be higher latency because inactive tenant's data got purged from caches but it would be nowhere near the latency of spining up a postgres instance. You could even have a smart stats layer that tracks usage and keeps some minimal amount of inactive tenants data in memory to minimize latency.

Re: AWS cancels serverless Postgres service that scales to zero

#49
post #11

Honest question, why not just use dynamodb? If I'm already mostly server less and AWS, dynamodb seems like a natural choice for a persistent store in a world where cost and zero-scaling is important.

Because you need SQL. Dynamo can be quite powerful for querying if you use all of its features but it won't be as flexible as just using SQL

Almost any SQL workload you can move to DynamoDB
Post reply on HN