Hi All,

At system crash or poweroff the autovacuum statistics will be lost,
because this statistics only stored in RAM and saved/restored at
service shutdown/startup.
I think it should be saved periodically and not to be deleted after
crash.



-Sygma

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Szima Gábor wrote:

> At system crash or poweroff the autovacuum statistics will be lost,
> because this statistics only stored in RAM and saved/restored at
> service shutdown/startup.
> I think it should be saved periodically and not to be deleted after
> crash.

I don't remember why it was that we made the stat file be dropped on
crash recovery, but there was a reason. I guess you could research the
reason; it was a thread which ended with an autovacuum patch from me.
You could look the CVS logs for the pgstat.c file.

--
Alvaro Herrera http://www.advogato.org/person/alvherre
"Someone said that it is at least an order of magnitude more work to do
production software than a prototype. I think he is wrong by at least
an order of magnitude." (Brian Kernighan)

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> Szima Gábor 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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster