Re: fast-archiver tool, useful for pgsql DB backups

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: fast-archiver tool, useful for pgsql DB backups
Дата
Msg-id 1346648640.18578.2.camel@vanquo.pezone.net
обсуждение исходный текст
Ответ на fast-archiver tool, useful for pgsql DB backups  (Mathieu Fenniak <mathieu.fenniak@replicon.com>)
Список pgsql-general
Дерево обсуждения 
On Fri, 2012-08-24 at 15:48 -0600, Mathieu Fenniak wrote:
> Hi pgsql-general,
>
> Has anyone else ever noticed how slow it can be to rsync or tar a pgdata
> directory with hundreds of thousands or millions of files?

Yes:
http://petereisentraut.blogspot.com/2012/05/base-backup-compression-options.html

My analysis showed that the archiving was CPU-bound on the compression
task.  It might different when you are dealing with a lot of small files
as opposed to a few big files.  So parallelizing the archiving itself
could still be useful.

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

Предыдущее
От: johnlumby
Дата:
Сообщение: RE: [GENERAL] UPDATE RULE to be invoked when UPDATE .. WHERE fails the WHERE predicate ?‏
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: C locale versus en_US.UTF8. (Was: String comparision in PostgreSQL)