Re: collector/autovacuum after crash (8.1beta3)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
Cc: Szima Gábor <sygma(at)tesla(dot)hu>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: collector/autovacuum after crash (8.1beta3)
Date: 2005-10-21 14:33:23
Message-ID: 21371.1129905203@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> writes:
> Szima Gbor wrote:
>> At system crash or poweroff the autovacuum statistics will be lost,

> I don't remember why it was that we made the stat file be dropped on
> crash recovery, but there was a reason.

The fact that it's not WAL-backed and hence couldn't be trusted. But
I think he's complaining about the contrib version of autovacuum anyway.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-10-21 15:29:20 Re: [PATCHES] Win32 CHECK_FOR_INTERRUPTS() performance tweak
Previous Message Martijn van Oosterhout 2005-10-21 14:31:10 Which platforms don't HAVE_POSIX_SIGNALS?