From: Tomas Vondra <tv@fuzzy.cz>
To: pgsql-performance@postgresql.org
Subject: Re: very long updates very small tables
Date: Wed, 06 Apr 2011 20:30:39 +0200
Message-ID: <4D9CB14F.8040901@fuzzy.cz> (raw)
In-Reply-To: <4D999038020000250003C207@gw.wicourts.gov>
References: <4D91EEFA.90707@uni-heidelberg.de>
<4D91EC7E020000250003BEEC@gw.wicourts.gov>
<4D92DD2C.8010305@uni-heidelberg.de>
<4D931A0C020000250003BF80@gw.wicourts.gov>
<4D997D3D.1080104@uni-heidelberg.de>
<4D999038020000250003C207@gw.wicourts.gov>
Dne 4.4.2011 16:32, Kevin Grittner napsal(a):
> Nothing there makes a write glut on checkpoint less likely to be the
> cause. Without a BBU write-back cache it is actually *more* likely,
> and having enough RAM to hold the whole database makes it *more*
> likely. If you haven't placed your pg_xlog directory on a separate
> file system, it is also more likely.
>
> Turning on logging of checkpoint activity and checking whether that
> correlates with your problem times is strongly indicated.
>
> -Kevin
Checkpoints would be my first guess too, but the whole database is just
500MB. Lars, how did you get this number? Did you measure the amount of
disk space occupied or somehow else?
BTW how much memory is there (total RAM and dedicated to shared
buffers)? How many checkpoint segments are there?
Have you monitored the overall behavior of the system (what processes
are running etc.) when the problems occur? I don't have much experience
with Windows but tools from sysinternals are reasonable.
And yet another idea - have you tried to use the stats collected by
PostgreSQL? I mean the pg_stat_ tables, especially pg_stat_bgwriter and
maybe pg_stat_all_tables. Those numbers are cummulative, so do two
snapshot when the problems are happening and subtract them to get an
idea of what's going on.
regards
Tomas
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-performance@postgresql.org
Cc: tv@fuzzy.cz
Subject: Re: very long updates very small tables
In-Reply-To: <4D9CB14F.8040901@fuzzy.cz>
* 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