From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: pgsql-admin <pgsql-admin@postgresql.org>
To: Benjamin Krajmalnik <kraj@servoyant.com>
Subject: Re: Problem with pgstat timeouts
Date: Wed, 04 Jan 2012 12:43:59 -0600
Message-ID: <4F04498F020000250004438B@gw.wicourts.gov> (raw)
In-Reply-To: <F4E6A2751A2823418A21D4A160B689888CA623@fletch.stackdump.local>
References: <F4E6A2751A2823418A21D4A160B689888CA5A0@fletch.stackdump.local>
<F4E6A2751A2823418A21D4A160B689888CA623@fletch.stackdump.local>
"Benjamin Krajmalnik" <kraj@servoyant.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, kraj@servoyant.com
Subject: Re: Problem with pgstat timeouts
In-Reply-To: <4F04498F020000250004438B@gw.wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox