| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | "Huang, Suya" <Suya(dot)Huang(at)au(dot)experian(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: How to interpret view pg_stat_bgwriter |
| Date: | 2014-09-22 18:04:20 |
| Message-ID: | 542064A4.4020101@gmx.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2014-09-22 18:06:05 | Re: Missing locale files according to psql |
| Previous Message | John Scalia | 2014-09-22 14:44:55 | When is it safe to remove backup files from a wal archiving directory |