| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Mathieu Fenniak <mathieu(dot)fenniak(at)replicon(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: fast-archiver tool, useful for pgsql DB backups |
| Date: | 2012-09-03 05:04:00 |
| Message-ID: | 1346648640.18578.2.camel@vanquo.pezone.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2012-09-03 05:08:25 | Re: C locale versus en_US.UTF8. (Was: String comparision in PostgreSQL) |
| Previous Message | johnlumby | 2012-09-02 21:42:22 | RE: [GENERAL] UPDATE RULE to be invoked when UPDATE .. WHERE fails the WHERE predicate ? |