Most hosted Postgres pricing works like this: you pick an instance size, the vendor assumes the instance will run for about 730 hours a month, and you pay for those hours. Lakebase Postgres addresses that waste with autoscaling and scale…
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…