DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=ymail.com;
 h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
 b=D5ZAlPbvbfN9XfI+8dt4POf9S4TJqQWUqY/bxblYM+F6f793pxW4X2r+xzxojGvtjoQibclxPT6G+25mFWofXE+vmdWycO04m5Nj87uaMnACD+1EoDklcjfxr1wJPDYOkxF0fbHW9RjEb6bWH/Li1T0mKG0BCbqf7LTyCSTKh6Q=;
References: <5233BA90.3020107@gmail.com>
 <20130914045519.GD5033@eldon.alvh.no-ip.org> <5233F3A9.30901@gmail.com>
 <1379178368.98727.YahooMailNeo@web162901.mail.bf1.yahoo.com>
 <523507DE.3060909@gmail.com>
 <1379266279.54874.YahooMailNeo@web162902.mail.bf1.yahoo.com>
 <52366022.8020706@gmail.com>
Message-ID: <1379347372.27022.YahooMailNeo@web162906.mail.bf1.yahoo.com>
Date: Mon, 16 Sep 2013 09:02:52 -0700 (PDT)
From: Kevin Grittner <kgrittn@ymail.com>
Reply-To: Kevin Grittner <kgrittn@ymail.com>
Subject: Re: wrong database name in error message?
To: Rural Hunter <ruralhunter@gmail.com>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
In-Reply-To: <52366022.8020706@gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Rural Hunter <ruralhunter@gmail.com> wrote:

> This was changed quite long time ago when I saw too frequent auto
> vacuums to prevent the wrap-around on a very busy/large table
> which slow down the performance. I will change it back to the
> default to see how it works.

There was a long-standing bug which could cause over-frequent
wraparound prevention autovacuums.=A0 As long as you are on the
latest minor release, things should be much better now.

> I will try the parameters as you suggested too.

Possibly.=A0 As I said before, I think the symptoms might better fit
a situation where the table in need of VACUUM was a shared table
and it just happened to mention db1 because that was the database
it was scanning at the time.=A0 (Every database includes the shared
system tables in its catalog.)

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin