This latency graph shows a r6id → i7i upgrade. Same vCPU count. Same amount of RAM. Both using local SSDs.
Upgrading to a newer instance makes a big difference.
This latency graph shows a r6id → i7i upgrade. Same vCPU count. Same amount of RAM. Both using local SSDs.
Upgrading to a newer instance makes a big difference.
Connection pooling is broadly important for databases, but especially for Postgres because of its process-per-connection architecture.
Don't know what that means? I have the perfect article!
Connection pooling is broadly important for databases, but especially for Postgres because of its process-per-connection architecture.
Don't know what that means? I have the perfect article!
Try btree.app and bplustree.app.
These are standalone sandboxes of the visuals I built for my "B-trees and database indexes" article. Helpful for learning B-tree insertion, search, and node splits.
Try btree.app and bplustree.app.
These are standalone sandboxes of the visuals I built for my "B-trees and database indexes" article. Helpful for learning B-tree insertion, search, and node splits.
My personal biggest takeaway? Gemini is fast! I mostly stick with Claude but maybe I should give it a go.
My personal biggest takeaway? Gemini is fast! I mostly stick with Claude but maybe I should give it a go.
Time to bring it back?
Started this long before PlanetScale Postgres. Would be a fun opportunity to compare the MVCC models of Postgres and MySQL.
Time to bring it back?
Started this long before PlanetScale Postgres. Would be a fun opportunity to compare the MVCC models of Postgres and MySQL.
There's a few surprising results, but overall Postgres 18 has some nice improvements.
Read all about it at the link below.
There's a few surprising results, but overall Postgres 18 has some nice improvements.
Read all about it at the link below.
In Javascript.
For a blog.
In Javascript.
For a blog.