Re: Stats collector frozen?
От | Jeremy Haile |
---|---|
Тема | Re: Stats collector frozen? |
Дата | |
Msg-id | 1169824051.30848.1171376725@webmail.messagingengine.com обсуждение исходный текст |
Ответ на | Re: Stats collector frozen? (Magnus Hagander <magnus@hagander.net>) |
Список | pgsql-general |
> 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?
В списке pgsql-general по дате отправления: