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: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: autovacuum causing numerous regression-test failures
Date: 2006-08-28 20:05:35
Message-ID: 17333.1156795535@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=osprey&dt=2006-08-28%2016:00:17
shows another autovac-induced failure mode:

! psql: FATAL:  sorry, too many clients already

initdb is choosing max_connections = 20 on this machine, which is
sufficient to run the parallel regression tests by themselves,
but not regression tests plus autovac.

IIRC initdb will go down to 10 or so connections before deciding
it's hopeless.  I don't really want to change that behavior because
it might make it impossible to initdb at all on a small machine.
But probably there needs to be a way for pg_regress to set a floor
on the acceptable max_connections setting while initializing the
test instance for "make check".

This also ties into the recent discussions about whether autovac needs
its own reserved backend slots.  Which, again, sounds to me like a fine
idea for 8.3 work.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Joachim WielandDate: 2006-08-28 21:03:25
Subject: Re: [PATCHES] Another VPATH patch for ecpg
Previous:From: Tom LaneDate: 2006-08-28 19:42:15
Subject: Re: autovacuum causing numerous regression-test failures

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