Company
Date Published
March 4, 2024
Author
Carlota Soto
Word count
606
Language
English
Hacker News points
1

Summary

The text discusses various methods of copying Postgres databases and introduces Neon branching as an alternative solution. Traditional methods such as physical file copy, logical backup and restore, logical replication, and database forking can be time-consuming and resource-intensive, especially for large databases. Neon branching utilizes the copy-on-write technique to create instant copies of Postgres databases without requiring additional storage until changes are made. This method is efficient, affordable, and allows developers to work on isolated database instances for testing, development, staging, point-in-time restores, and more.