| From: | "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net> |
|---|---|
| To: | daveg <daveg(at)sonic(dot)net>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Segv in pg_autovacuum in 8.0.x |
| Date: | 2005-10-19 15:01:09 |
| Message-ID: | 43565FB5.9080307@zeut.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | 沈一枫 | 2005-10-19 15:46:25 | tsearch2 's access method? |
| Previous Message | Katherine Stoovs | 2005-10-19 14:51:55 | tuning seqscan costs |