| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Jeff Kirby" <Jeff(dot)Kirby(at)wicourts(dot)gov> |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Vacuum Full Analyze Stalled |
| Date: | 2005-10-03 19:38:56 |
| Message-ID: | s3414285.013@gwmta.wicourts.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
In my previous post I failed to mention that after we stopped the
applications and found that autovacuum remained idle for several
minutes, we restarted postgres before cleaning up the bloat on
the problem table.
Also, the log shows that autovacuum stopped kicking in after
4:43 p.m. on Friday. It was at about this point that I was
dropping and creating indexes through psql. I did not use
BEGIN TRANSACTION, but I went home with an index being
built on a large table, so that connection remained open until
Sunday at 9:00 p.m. I don't know if that matters, but I'm trying
to be thorough.
-Kevin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2005-10-03 19:41:14 | Re: Vacuum Full Analyze Stalled |
| Previous Message | Kevin Grittner | 2005-10-03 19:09:37 | Re: Vacuum Full Analyze Stalled |