Message-ID: <4C698D88.6030201@agliodbs.com>
Date: Mon, 16 Aug 2010 12:12:08 -0700
From: Josh Berkus <josh@agliodbs.com>
User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US;
	rv:1.9.1b3pre) Gecko/20090223 Thunderbird/3.0b2
MIME-Version: 1.0
To: Joe Conway <mail@joeconway.com>
CC: PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: Return of the Solaris vacuum polling problem -- anyone
	remember this?
References: <4C69827A.409@agliodbs.com> <4C698CAD.2020001@joeconway.com>
In-Reply-To: <4C698CAD.2020001@joeconway.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit


> I've also recently heard a report of vacuum hanging on 8.3.x on Solaris
> Sparc. Any chance you can get a backtrace from a build with debug symbols?

The problem is that we haven't been able to reproduce the bug in
testing.  Like I said, it only seems to happen occasionally ... like
maybe once in 10 or 20 (or more?) autovacuums.  We've never been seen it
with a manual vacuum at all.

And we can't rebuild the production servers.

-- 
                                  -- Josh Berkus
                                     PostgreSQL Experts Inc.
                                     http://www.pgexperts.com