DatabasesNeon
Databases
Choosing a database instance size before you know the workload is an old building pattern. Lakebase Postgres omits the sizing experience altogether thanks to autoscaling.
log_lock_waits is the cheapest lock-contention detector PostgreSQL ships, and through version 18 it is off by default. Turn it on. PostgreSQL 19 will do it for you. The mechanism is borrowed rather than built. When a backend has to sleep…
Key takeaways A routine OS patch can take Postgres offline even when Postgres itself was never touched. Here’s what rolling OS patching on a proper HA cluster changes: OS-level patches (kernel, glibc, container runtime, storage driver) can…
If you run PostgreSQL on EC2, you've had two real choices until now: build from source, or fall back to whatever version Amazon Linux itself carries in its base repos. Neither matches what the rest of the PostgreSQL community gets from…