Re: autovacuum causing numerous regression-test failures

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: autovacuum causing numerous regression-test failures
Date: 2006-08-29 13:42:14
Message-ID: 200608291542.15665.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Am Dienstag, 29. August 2006 11:14 schrieb Andreas Pflug:
> already pointed out, all win32 installations have it on by default, to
> take them to the safe side. Disabling it for modules a "retail" user
> will never launch appears overreacting.

Well, the really big problem is that autovacuum may be connected to a database
when you want to drop it. (There may be related problems like vacuuming a
template database at the wrong time. I'm not sure how that is handled.) I
think this is not only a problem that is specific to the regression testing
but a potential problem in deployment. I have opined earlier how I think
that should behave properly, but we're not going to change that in 8.2.

The other problems that were mentioned are pretty easy to work around by
setting stats_row_level to off on the fly, but that doesn't stop autovacuum
from connecting.

The good thing is that we have collected plenty of interesting data in the
last 24 hours which will make for plenty of development work next time
around. :)

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Meskes 2006-08-29 13:53:13 Re: [PATCHES] Another VPATH patch for ecpg
Previous Message Tom Lane 2006-08-29 13:38:23 Re: [COMMITTERS] pgsql: Second try committing the path changes.