Re: Estimating WAL usage during pg_basebackup

Поиск
Список
Период
Сортировка
От Soni M
Тема Re: Estimating WAL usage during pg_basebackup
Дата
Msg-id CAAMgDXk_DuHx4QgRnWni-Ys28bCA+U5bo529FJQjVqMU2ndjbg@mail.gmail.com
обсуждение исходный текст
Ответ на Estimating WAL usage during pg_basebackup  (Mike Blackwell <mike.blackwell@rrd.com>)
Список 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.blackwell@rrd.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?



--
Regards,

Soni Maula Harriz

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

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: DBlink, postgres to DB2
Следующее
От: Jayadevan M
Дата:
Сообщение: Query planning