> We have had lots of reports of issues with the stats collector on
> Windows. Some were definitly fixed by the patch by O&T, but I don't
> think all.
Here were a couple of other reports I found:
http://archives.postgresql.org/pgsql-hackers/2006-09/msg00415.php
http://archives.postgresql.org/pgsql-hackers/2006-04/msg00127.php
> The thing is, since it didn't give any error messages at all, most users
> wouldn't notice. Other than their tables getting bloated, in which case
> they would do a manual vacuum and conlcude autovacuum wasn't good
> enough. Or something.
This is indeed what I assumed at first. I started running "vacuum
analyze" hourly and turned off autovacuum. Later, I decided to try the
autovacuum route again and investigated why it wasn't working well.
Magnus - could you send me a patched exe to try in my environment?
Would it be compatible with 8.2.1?