Emanuel Calvo

3manuek

Emanuel Calvo

Contact
  • 📃 About
  • 🎤 Public Appearances
  • 📓 Posts
  • ● A PostgreSQL Hot Update study on small tables. Fillfactor and Hash Partitioning Strategies.
  • ● Upgrading Postgres Major, and Django model with Logical Replication.
  • ● Online Backups with no archives in PGBackRest
  • ● Evaluating PGCat's Sharding by hash
  • ⚙️ Toolbox
  • Guides
  • 🏷️
    • Babelfishpg 8
    • Docker 16
    • Golang 8
    • Labs 20
    • Mysql 16
    • Pooling 8
    • Postgres 50
    • Projects 12


© 2026 3manuek. All rights reserved.

PostgreSQL backup and recovery tradeoffs

Backup configuration depends on the recovery guarantees you need. Begin with the archive-storage tradeoffs below: this specialized setup is not a general recommendation for production backups.

  • PGBackRest backups without retained archives: constraints and risks

All guides · Experience