News for hackers. Stuff that matters.

A comment on Neon Serverless Postgres is generally available.

Re:Neon Serverless Postgres is generally available by pier25 on Monday April 15, 2024 @10:37AM (#40041129)
Anyone using it in production?

The only issue I've found with Neon is that to use listen/notify the DB needs to be awake 24/7 which defeats the purpose of serverless.

[ Parent | on HN ]
Re:Neon Serverless Postgres is generally available by shinypokemon on Monday April 15, 2024 @10:52AM (#40041367)
(Neon DevRel here)

This is valid. However, many production databases won't scale to zero often. The serverless proposition is still valuable if you factor in the development, test, and staging environments scaling to zero plus our autoscaling that doesn't require downtime or dropped connections.

For guaranteed message delivery, you're probably best of using a messaging system designed with that in mind instead of listen/notify.

[ Parent | on HN ]
Re:Neon Serverless Postgres is generally available by pc86 on Monday April 15, 2024 @11:03AM (#40041508)
Is it possible to set the production database to have a minimum scale of 1? So even if it "should" scale to zero it won't?
[ Parent | on HN ]
Re:Neon Serverless Postgres is generally available by joshstrange on Monday April 15, 2024 @11:08AM (#40041563)
Yes, you can set the min/max for scale. I scale down to “.25” as my min.
[ Parent | on HN ]
Re:Neon Serverless Postgres is generally available by mj4e on Monday April 15, 2024 @10:49AM (#40041311)
(Neon PM) This is true and very often production applications need access to their database 24/7, so they benefit from the serverless nature of autoscaling.
[ Parent | on HN ]