Skip site navigation (1) Skip section navigation (2)

Re: autovacuum causing numerous regression-test failures

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org, Peter Eisentraut <peter_e(at)gmx(dot)net>
Subject: Re: autovacuum causing numerous regression-test failures
Date: 2006-08-28 23:18:37
Message-ID: 19821.1156807117@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
"Matthew T. O'Connor" <matthew(at)zeut(dot)net> writes:
>> Tom Lane wrote:
>>> Not a solution for "make installcheck",

> I'm sure I'm missing some of the subtleties of make installcheck issues, 
> but autovacuum can be enabled / disabled on the fly just as easily as 
> stats_row_level, so I don't see the difference?

Well, "just as easily" means "edit postgresql.conf and SIGHUP", which is
not an option available to "make installcheck", even if we thought that
an invasive change of the server configuration would be acceptable for
it to do.  It's conceivable that we could invent a per-database
autovac-off variable controlled by, say, ALTER DATABASE SET ... but we
haven't got one today.

My objection here is basically that this proposal passed on the
assumption that it would be very nearly zero effort to make it happen.
We are now finding out that we have a fair amount of work to do if we
want autovac to not mess up the regression tests, and I think that has
to mean that the proposal goes back on the shelf until 8.3 development
starts.  We are already overcommitted in terms of the stuff that was
submitted *before* feature freeze.

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2006-08-28 23:20:57
Subject: Re: updated patch for selecting large results sets
Previous:From: Bruce MomjianDate: 2006-08-28 23:08:07
Subject: Re: updated patch for selecting large results sets

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group