| From: | Shaun Thomas <sthomas(at)optionshouse(dot)com> |
|---|---|
| To: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Unexplained Major Vacuum Archive Activity During Vacuum |
| Date: | 2012-11-01 14:04:09 |
| Message-ID: | 50928159.5080000@optionshouse.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hey guys,
I don't notice any errors, which just makes this even more strange. But
after weeks of operating normally, our 10pm manual vacuum job generated
transaction logs basically equivalent to 3/4 of our database, and I
can't find any explanation. This amount is about 6x higher than usual.
Before I go crazy and tear the box apart, does anyone know of some
internal change that may cause intermittent marking of pages to increase
without related database activity?
Or did I just vacuum a database with a corrupt CPU or piece of RAM? (Let
me say again, I see no errors anywhere in the database logs.)
--
Shaun Thomas
OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604
312-444-8534
sthomas(at)optionshouse(dot)com
______________________________________________
See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Burton | 2012-11-01 14:06:14 | Re: role does not exist |
| Previous Message | craig | 2012-11-01 14:02:43 | Re: Unable to do a mailing list proper search |