Re: [HACKERS] collector/autovacuum after crash (8.1beta3)
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 Herrerahttp://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
Re: [HACKERS] collector/autovacuum after crash (8.1beta3)
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 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
[HACKERS] collector/autovacuum after crash (8.1beta3)
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