Обсуждение: Segv in pg_autovacuum in 8.0.x

Apologies if this is old news, but pg_autovacuum in 8.0.x has the bad habit
of SEGVing and exiting when a table gets dropped out from under it. This
creates problems if you rely on pg_autovacuum for the bulk of your vacuuming
as it forgets it's statistics when it is restarted and so will skip some
desireable vacuums.

I have a patch for this that should apply against any 8.0.x if there is any
interest.

I looked at the new autovacuum in 8.1 and it appears from casual inspection
not to have the same problem.

-dg

-- 
David Gould                      daveg@sonic.net
If simplicity worked, the world would be overrun with insects.

daveg wrote:
> Apologies if this is old news, but pg_autovacuum in 8.0.x has the bad habit
> of SEGVing and exiting when a table gets dropped out from under it. This
> creates problems if you rely on pg_autovacuum for the bulk of your vacuuming
> as it forgets it's statistics when it is restarted and so will skip some
> desireable vacuums.
>
> I have a patch for this that should apply against any 8.0.x if there is any
> interest.
>   

Please post the patch, it might get committed into 8.0.x.  I personally 
haven't heard any other reports of it dieing when tables are dropped, 
but I don't doubt there are some lingering issues like this.

> I looked at the new autovacuum in 8.1 and it appears from casual inspection
> not to have the same problem.

The autovacuum in 8.1 is a very different critter.  While its design is 
based on the contrib autovacuum, it is mostly a total rewrite, and 
probably a vast improvement :-)


Matt