Re: Problem with pgstat timeouts

Batteries are installed and healthy. I wonder if it did it during one of the charge/discharge cycles and just did not revert (interestingly, I have one more server that did just that). I am trying to get the info from LSI as to what may have caused it, if it is safe to revert the cache mode while it is running, and, of course, the exact command so I don't foobar things up.

> -----Original Message-----
> From: Kevin Grittner [mailto:Kevin(dot)Grittner(at)wicourts(dot)gov]
> Sent: Wednesday, January 04, 2012 11:44 AM
> To: pgsql-admin; Benjamin Krajmalnik
> Subject: Re: [ADMIN] Problem with pgstat timeouts
>
> "Benjamin Krajmalnik" <kraj(at)servoyant(dot)com> wrote:
>
> > Default Cache Policy: WriteBack, ReadAhead, Direct, No Write Cache
> > if Bad BBU
> > Current Cache Policy: WriteThrough, ReadAhead, Direct, No Write
> > Cache if Bad BBU
>
> > Is it possible that the WriteThrough is what is causing the high
> > io (and maybe the pgstat wait timeouts as well)?
>
> Yes.
>
> > If this is the case, would it be safe to change the cache to Write
> > back?
>
> Maybe. How did it get into this (non-default) state? Are batteries
> installed and healthy?
>
> > Additionally, and somewhat unrelated, is there anything special
> > which I need to do when restarting the primary server vis-à-vis
> > the streaming replication server? In other words, if I were to
> > restart the main server, will the streaming replication server
> > reconnect and pick up once the primary comes online?
>
> I think that should be pretty automatic as long as you haven't
> promoted the standby to be the new master.
>
> -Kevin