Re: [HACKERS] collector/autovacuum after crash (8.1beta3)

2005-10-21 Thread Alvaro Herrera
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

Re: [HACKERS] collector/autovacuum after crash (8.1beta3)

2005-10-21 Thread Tom Lane
Alvaro Herrera [EMAIL PROTECTED] 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

[HACKERS] collector/autovacuum after crash (8.1beta3)

2005-10-19 Thread Szima Gábor
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.