Re: PostgreSQL suitable?
От | Rakesh Kumar |
---|---|
Тема | Re: PostgreSQL suitable? |
Дата | |
Msg-id | trinity-acba7d1e-51f3-4465-a57c-8a65e523bece-1513699967925@3c-app-mailcom-lxa07 обсуждение исходный текст |
Ответ на | Re: PostgreSQL suitable? (Stephen Frost <sfrost@snowman.net>) |
Ответы |
Re: PostgreSQL suitable?
Re: PostgreSQL suitable? |
Список | pgsql-general |
> There are multiple solutions to doing incremental backups with > PostgreSQL, so I'm not sure why you're saying that they don't exist, > because that's really not accurate. PG's incremental backup is essentially WAL logs applied to a point in time. I am talking about true incremental backup wherethe db backs up only the changed blocks after the last full backup. In a DW system where most of the time it is appendonly, it makes a huge difference in backup time. I believe there is one tool which looks at mtime/atime of each of the data file and takes the decision to back it up or lot. Not sure how robust it is.
В списке pgsql-general по дате отправления: