News for hackers. Stuff that matters.

A comment on AWS open-sourced Postgres active-active replication extension. Parent comment

Re:AWS open-sourced Postgres active-active replication exten... by mdavidn on Wednesday July 16, 2025 @01:15PM (#44584673)
Load the snapshot to a "pristine" local database that you never modify. Whenever you need a "reset" of your dev database, drop it, then copy the pristine database using `createdb --template`. This copies prebuilt indexes rather than rebuild them, which is much faster.
[ Parent | on HN ]
Re:AWS open-sourced Postgres active-active replication exten... by nico on Wednesday July 16, 2025 @01:39PM (#44584932)
But when loading that pristine local db from the original source, it would still create the indices and thus take a long time?

The goal is not necessarily having an easy way to reset, but rather an easy/quick way to load real data

[ Parent | on HN ]