| From: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com> |
|---|---|
| To: | Brian Fehrle <brianf(at)consistentstate(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Hot standby having high requested checkpoints? |
| Date: | 2012-03-01 02:17:59 |
| Message-ID: | CAHGQGwFQ-4CFX_0APMSDjFse+c8vGs_-SVbF04ydXcid+0-tJQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, Mar 1, 2012 at 12:14 AM, Brian Fehrle
<brianf(at)consistentstate(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Khangelani Gama | 2012-03-01 07:51:57 | Can't recover data from a .tar.gz file which was backed up using COPY BINARY command |
| Previous Message | Ray Stell | 2012-02-29 21:25:02 | Re: re-create information_schema |