8 ms·
To summarize. This is a new possible feature for the upcoming release. No, you don't have only full backups with Postgres right now - it is possible to perform
by genman 3y ago
To summarize. This is a new possible feature for the upcoming release. No, you don't have only full backups with Postgres right now - it is possible to perform incremental backups using Write Ahead Log (WAL), but with WAL you have to replay all the changes one by one while the new feature is a real diff meaning that backups will be smaller and faster to apply.
- sroussey 3y agoBy watching which records the WAL changed since last backup, it saves a list of records to back up as incremental. Neat. Now if your db works like append only, this may need t be as big as a savings as someone who updates the same records a lot (as at incremental backup time it only needs to save the final values of those records). This could be used in replication topographies and scenarios. Maybe PG 18.