3 ms·
> I also think community and industry enthusiasm around Postgres is at an all time high. There are more managed hosting options than ever (Crunchy Data, Render,
by jgalt212 3y ago
> I also think community and industry enthusiasm around Postgres is at an all time high. There are more managed hosting options than ever (Crunchy Data, Render, Fly.io, and on and on), deep extensions like PostgresML, Citus and Timescale, serverless options like Neon, and real-time services like Supabase with Postgres at their center.
Please sell me why you'd use one vendor to host your DB and another one to host your app. If they are in different racks (forget about different data centers), that's going to kill you on latency. The only way around that we've seen is to vectorize all your queries.
- jtc331 3y agoIf deploying on different racks is that big of problem for your latency then you’re severely limited in how far you can scale your application just by physical rack space. IME this just isn’t true.
- jtc331 3y agoAnd even if in different data centers (say different AZs), query latency is probably 1ms; in practice that’s quite low. How many queries are you doing in a request?
- jgalt212 3y ago> query latency is probably 1ms > This generally produces single digit millisecond roundtrip latency between AZs in the same Region. https://aws.amazon.com/blogs/architecture/improving-performance-and-reducing-cost-using-availability-zone-affinity/ https://aws.amazon.com/blogs/architecture/improving-performa... So we're both wrong.
- brightball 3y agoCrunchydata deploys in AWS, GCP or Azure if I recall correctly.