Re: Speeding up replication startup/recovery

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: Speeding up replication startup/recovery
Дата
Msg-id BANLkTi=xehhaV1_7iGxy8K2YU+LU-WruKw@mail.gmail.com
обсуждение исходный текст
Ответ на Speeding up replication startup/recovery  ("Henry C." <henka@cityweb.co.za>)
Ответы Re: Speeding up replication startup/recovery
Список pgsql-general
On Wed, Apr 13, 2011 at 10:03 AM, Henry C. <henka@cityweb.co.za> wrote:

> My test replication seems to be proceeding normally, but the process appears
> to be quite slow:
>
> SLAVE
> ...postgres: startup process   recovering 000000010000019000000024    (1)
> ...postgres: wal receiver process   streaming 190/244FEA80
>
> MASTER
> ...postgres: wal sender process replicator 1.1.1.1(55390) streaming 190/244FEA80
>
> There are quite a few log files to process and both machines are not heavily
> taxed.  Is there any way to expedite this initial recovery process (1)?  It
> seems to be chugging along at a rather sedate pace.

The replication lag is zero since the master and slave WAL locations match.

There seems to be nothing to expedite... why do you say it is slow?

Maybe because you see this as an "initial recovery process". The
recovery process remains active while processing continues.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

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

Предыдущее
От: "Henry C."
Дата:
Сообщение: Speeding up replication startup/recovery
Следующее
От: "Henry C."
Дата:
Сообщение: Re: Speeding up replication startup/recovery