"Ralph Mason" <ralph(dot)mason(at)telogis(dot)com> writes:
> Ralph Mason wrote:
>> We have a database running on a 4 processor machine. As time goes by
>> the IO gets worse and worse peeking at about 200% as the machine loads up.
>>
>> The weird thing is that if we restart postgres it's fine for hours but
>> over time it goes bad again.
Do you by any chance have stats collection enabled and
stats_reset_on_server_start set to true? If so, maybe this is explained
by growth in the size of the stats file over time. It'd be interesting
to keep an eye on the size of $PGDATA/global/pgstat.stat over a fast-to-
slow cycle.
regards, tom lane