ngosangns Knowledge Base

#postgresql

  • Database Connection Pooling
    Explains why a database connection is an expensive OS process, how connection pools work, and how to size a pool using Little's Law, Kingman's formula, and the process-to-core ratio.
  • PostgreSQL HA Patroni Best Practices
    Best practices for running highly available PostgreSQL with Patroni, PgBouncer, and etcd, including when to use the Ivory management UI versus the CLI.