Re: Need solution for weekly database "snapshot"

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Re: Need solution for weekly database "snapshot"
Дата
Msg-id 66950564-1F87-4E95-A1A6-22F6794AA950@thebuild.com
обсуждение исходный текст
Ответ на Re: Need solution for weekly database "snapshot"  (Moshe Jacobson <moshe@neadwerx.com>)
Ответы Re: Need solution for weekly database "snapshot"
Список pgsql-general
On Apr 22, 2013, at 10:05 AM, Moshe Jacobson wrote:
> Not bad, but the transaction logs would fill up the file system.

I'm not sure I understand that comment.  Why would the transaction logs be particularly voluminous in this case?

> Besides, it would not be worth it to set up a whole database cluster just for this purpose.

It does seem to meet all of your needs in a very efficient way; setting up a PG cluster is not that complex.

--
-- Christophe Pettus
   xof@thebuild.com



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

Предыдущее
От: Steven Schlansker
Дата:
Сообщение: Using an index for IS DISTINCT FROM queries
Следующее
От: John R Pierce
Дата:
Сообщение: Re: Need solution for weekly database "snapshot"