Re: Hot standby having high requested checkpoints?

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: Hot standby having high requested checkpoints?
Дата
Msg-id CAHGQGwFQ-4CFX_0APMSDjFse+c8vGs_-SVbF04ydXcid+0-tJQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Hot standby having high requested checkpoints?  (Brian Fehrle <brianf@consistentstate.com>)
Список pgsql-admin
On Thu, Mar 1, 2012 at 12:14 AM, Brian Fehrle
<brianf@consistentstate.com> wrote:
> I am taking periodic snapshots from the system view 'pg_stat_bgwriter' from
> both the master and the hot standby.

You mean that you observed that pg_stat_bgwriter.checkpoints_timed in
the standby was larger than that in the master? I ran pgbench on streaming
replication and checked pg_stat_bgwriter, but I could not reproduce the
problem you encountered. pg_stat_bgwriter.checkpoints_timed in the
standby was equal to or one more than that in the master. Could you tell me
the self-contained test case?

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

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

Предыдущее
От: Ray Stell
Дата:
Сообщение: Re: re-create information_schema
Следующее
От: Khangelani Gama
Дата:
Сообщение: Can't recover data from a .tar.gz file which was backed up using COPY BINARY command