Re: backup-strategies for large databases

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: backup-strategies for large databases
Дата
Msg-id CAOR=d=1_VSAZy64Ho7Jrk2LGN3DdAqOkrM0PgHT_B6tOfohumw@mail.gmail.com
обсуждение исходный текст
Ответ на backup-strategies for large databases  (MirrorX <mirrorx@gmail.com>)
Ответы Re: backup-strategies for large databases
Re: backup-strategies for large databases
Список pgsql-general
One possible answer to your issues is data partitioning.  By
partitioning your data by date or primary key or some other field, you
can backup individual partitions for incremental backups. I run a
stats database that partitions by day daily and we can just backup
yesterday's partition each night.  Each partition is in the 10 to 20
meg size range.

В списке pgsql-general по дате отправления:

Предыдущее
От: Greg Williamson
Дата:
Сообщение: Re: Using Postgresql as application server
Следующее
От: Rafal Pietrak
Дата:
Сообщение: INSERT-colision/MERGE in postgresql