Search Postgresql Archives

Unexplained Major Vacuum Archive Activity During Vacuum

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxxx

______________________________________________

See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux