From: Kevin Grittner <kgrittn@ymail.com>
To: Rural Hunter <ruralhunter@gmail.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: wrong database name in error message?
Date: Mon, 16 Sep 2013 09:02:52 -0700 (PDT)
Message-ID: <1379347372.27022.YahooMailNeo@web162906.mail.bf1.yahoo.com> (raw)
In-Reply-To: <52366022.8020706@gmail.com>
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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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. 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. 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. (Every database includes the shared
system tables in its catalog.)
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: kgrittn@ymail.com, ruralhunter@gmail.com
Subject: Re: wrong database name in error message?
In-Reply-To: <1379347372.27022.YahooMailNeo@web162906.mail.bf1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox