On: Neon Serverless Postgres is generally available

[shinypokemon]

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

[pc86 → shinypokemon]

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?

[joshstrange → pc86]

Yes, you can set the min/max for scale. I scale down to “.25” as my min.