Re: Stats collector frozen? - Mailing list pgsql-general

From Jeremy Haile
Subject Re: Stats collector frozen?
Date
Msg-id 1169824051.30848.1171376725@webmail.messagingengine.com
Whole thread Raw
In response to Re: Stats collector frozen?  (Magnus Hagander <magnus@hagander.net>)
List 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 by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Stats collector frozen?
Next
From: Tom Lane
Date:
Subject: Re: "no unpinned buffers available" ? why? (hstore and plperl involved)