Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group