From: Peter Eisentraut <peter_e@gmx.net>
To: Huang, Suya <Suya.Huang@au.experian.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: How to interpret view pg_stat_bgwriter
Date: Mon, 22 Sep 2014 14:04:20 -0400
Message-ID: <542064A4.4020101@gmx.net> (raw)
In-Reply-To: <D83E55F5F4D99B4A9B4C4E259E6227CD190F3A6C@AUX1EXC01.apac.experian.local>
References: <D83E55F5F4D99B4A9B4C4E259E6227CD01EBFA82@AUX1EXC02.apac.experian.local>
<5419F1CC.8060309@gmx.net>
<D83E55F5F4D99B4A9B4C4E259E6227CD190F3A6C@AUX1EXC01.apac.experian.local>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
On 9/19/14 1:54 AM, Huang, Suya wrote:
> How to compare buffers_backend against buffers_checkpoint?
This is a very general question, but generally you want buffers_backend
to be as small as possible.
> Below is some statistics of check point activities happened on the day while backend is loading data:
>
> Day Hour Written buffers Write time Sync time Total time
> 06 107,338 1,475.583s 3.142s 1,478.828s
> 07 601,672 1,041.482s 348.215s 1,390.153s
> 08 3,613 361.422s 0.053s 361.535s
> 09 1,006,704 1,456.898s 14.501s 1,471.545s
> 10 1,116,463 1,987.896s 6.164s 1,995.11s
>
> Can we tell something about the configuration?
If this is while loading data, there isn't much to say. I'd be worried
about the 348s sync time if this were during normal transaction
processing load.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: peter_e@gmx.net, Suya.Huang@au.experian.com
Subject: Re: How to interpret view pg_stat_bgwriter
In-Reply-To: <542064A4.4020101@gmx.net>
* 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