/plushcap/analysis/neon/neon-how-to-copy-large-postgres-databases-in-seconds

How to copy large Postgres databases in seconds

What's this blog post about?

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.

Company
Neon

Date published
March 4, 2024

Author(s)
Carlota Soto

Word count
606

Hacker News points
1

Language
English


By Matt Makai. 2021-2024.