| From: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
|---|---|
| To: | Jean-Armel Luce <jaluce06(at)gmail(dot)com> |
| Cc: | Cédric Villemain <cedric(dot)villemain(dot)debian(at)gmail(dot)com>, "[ADMIN]" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: rsync and streaming replication |
| Date: | 2011-11-17 17:45:10 |
| Message-ID: | B2C15563-E31A-41A8-AE9A-5F2D65097362@elevated-dev.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Nov 17, 2011, at 10:11 AM, Jean-Armel Luce wrote:
> > Also, I believe you said -z seemed to slow it down?
> I confirm
Is there a lot of your data that is already compressed? Either something like images which you are storing as bytea or large objects? Or long text values that pg will itself compress out of line?
> Today, I tried with command : rsync -rc --block-size=8192
> Rsync duration with blksize=8192 was 31 minutes (yesterday without blocksize, duration was 32 minutes exactly)
That seems not too bad, in that you're sustaining >3GB/min of reading & checksumming. (Some of my earlier comments were based on the belief that your db was 20GB.)
--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Silvio Brandani | 2011-11-18 14:09:42 | database not using indexes, yet |
| Previous Message | Cédric Villemain | 2011-11-17 17:40:27 | Re: rsync and streaming replication |