From: Scott Whitney <scott@journyx.com>
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: Scott Whitney <swhitney@journyx.com>
Cc: pgsql-admin@postgresql.org, Kenneth Marshall <ktm@rice.edu>
Subject: Re: pg_clogs hanging around
Date: Thu, 10 Mar 2011 09:47:24 -0600 (CST)
Message-ID: <7423332.14202.1299772044088.JavaMail.root@zimbra.int.journyx.com> (raw)
In-Reply-To: <27682685.14194.1299771826678.JavaMail.root@zimbra.int.journyx.com>
> > This is also interesting. I just allowed connections to template0
> > for the express purpose of vacuuming it, did a full vac on
> > template0, and that did NOT clear up the hanging clogs.
>
> Was it a VACUUM FREEZE followed by a CHECKPOINT? Did you also cover
> that new database?
Yes, yes and yes, actually. Unless I did it wrong, which is always a strong possibility. Especially early in the morning...
pg statement: update pg_database set datallowconn=true where datname='template0';
shell: vacuumdb -f -v -z -F template0
pg statement: checkpoint;
pg statement: update pg_database set datallowconn=true where datname='template0';
Like I said, I'm beginning to believe that something is rotten wrt my Saturday vacs...
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: scott@journyx.com, Kevin.Grittner@wicourts.gov, swhitney@journyx.com, ktm@rice.edu
Subject: Re: pg_clogs hanging around
In-Reply-To: <7423332.14202.1299772044088.JavaMail.root@zimbra.int.journyx.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