From: | Soni M <diptatapa(at)gmail(dot)com> |
---|---|
To: | Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Estimating WAL usage during pg_basebackup |
Date: | 2014-10-31 02:22:51 |
Message-ID: | CAAMgDXk_DuHx4QgRnWni-Ys28bCA+U5bo529FJQjVqMU2ndjbg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
This is hard to tell, but You can get some estimation.
1. You can have WAL rate estimation from pg_xlog/ dir, i.e. How many WAL
generated per minutes
2. How long this pg_basebackup will last. Lets say for 3 hours.
Then You can multiple values in #1 and #2 to get rough estimation.
Hope this would help.
On Fri, Oct 31, 2014 at 1:52 AM, Mike Blackwell <mike(dot)blackwell(at)rrd(dot)com>
wrote:
> I need to get an idea of how much WAL space will be required during a long
> (many hours) pg_basebackup over a relatively slow network connection. This
> is for a server that's not yet running PITR / streaming.
>
> Any thoughts?
> * <Mike(dot)Blackwell(at)rrd(dot)com>*
>
--
Regards,
Soni Maula Harriz
From | Date | Subject | |
---|---|---|---|
Next Message | Jayadevan M | 2014-10-31 07:46:05 | Query planning |
Previous Message | Craig Ringer | 2014-10-31 01:49:35 | Re: DBlink, postgres to DB2 |