| From: | Scott Whitney <scott(at)journyx(dot)com> |
|---|---|
| To: | Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov> |
| Cc: | Scott Whitney <swhitney(at)journyx(dot)com>, pgsql-admin(at)postgresql(dot)org, Kenneth Marshall <ktm(at)rice(dot)edu> |
| Subject: | Re: pg_clogs hanging around |
| Date: | 2011-03-10 15:47:24 |
| Message-ID: | 7423332.14202.1299772044088.JavaMail.root@zimbra.int.journyx.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
> > 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...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Grittner | 2011-03-10 15:56:50 | Re: pg_clogs hanging around |
| Previous Message | Kevin Grittner | 2011-03-10 15:30:44 | Re: pg_clogs hanging around |