Startup Time
During the months of Preview, we put a special focus on improving our scale to zero and cold start behavior. Today, tens of thousands of Neon databases scale to zero every day, saving developers money. And we keep working hard on our cold start metrics: we are now at a P50 of 500 ms to start a database, and we’re working to reduce it further. https://neon.tech/blog/neon-gaA) This is awesome. B) I'm doing a startup. There are still many times throughout the day when there are no visitors. Will the first visitor have an extra 1/2 second page load time while the db does a cold start?
Neon
Neon: A New Approach to Database Development - Neon
Postgres continues to hold its position as one of the most popular developer databases ever created. While MySQL lost some of its luster after acquisition by Oracle, Postgres continues to win more developer trust. In 2023, it topped the poll in the StackOverflow Developers Survey and in the same year, was voted the DBMS of […]
3 Replies
noble-gold•2y ago
Yes, if you have
1. auto-suspend enabled, and
2. no cache in place
You can avoid this by setting your production database to not auto-suspend, or having some sort of cache to avoid it
old-apricotOP•2y ago
@ShinyPokemon , thanks for this info. Would the cache be on the Neon server side?
noble-gold•2y ago
To clarify, by "cache" I meant something like Redis or Next.js caching. Neon has a cache, but it's more like
shared_buffers and therefore only applies when the database is awake (https://neon.tech/docs/reference/glossary#local-file-cache)Neon
Glossary - Neon Docs
Access token See Token. Active hours A usage metric that tracks the amount of time a compute is active, rather than idle when suspended due to inactivity. The time that your compute is idle is not cou...