Re: Huge number of disk writes after migration to 8.1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: Chris Campbell <chris(at)bignerdranch(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Huge number of disk writes after migration to 8.1
Date: 2006-01-19 17:14:41
Message-ID: 17473.1137690881@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> writes:
> Chris Campbell wrote:
>> Do the stats need to persist across postmaster restarts (or crashes)?

> After a crash we forcibly _delete_ the stat file.

I'm not sure why, though --- the writing technique seems fairly safe,
and in any case the reader checks what it's reading. Maybe we shouldn't
throw away the old stats.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 2006-01-19 20:36:22 Re: BUG #2182: Internal account lookup failure:
Previous Message Alexander Yeliseyev 2006-01-19 16:26:36 BUG #2186: syntax error in postgresql.conf