On Mon, 2010-03-15 at 13:20 -0500, Scott Whitney wrote:
My problem is that each Saturday at midnight, I have to start a
vacuumdb -f -z -a or my pg_clog dir never clears out.
Why is your pg_clog dir a problem?
So, my questions are:
a) Is the manual vacuum needed for performance reasons, or
I've got about 44GB of data in a few hundred production databases. I'm using PG
8.1.4, but upgrading today (even to the latest 8.1) is not an option. I know, I
know. I wish it were, and it's slated here for q2, but I cannot even apply
maintenance patches without a full testing cycle.
My
I've got about 44GB of data in a few hundred production databases. I'm using PG
8.1.4, but upgrading today (even to the latest 8.1) is not an option. I know, I
know. I wish it were, and it's slated here for q2, but I cannot even apply
maintenance patches without a full testing cycle.
My
Scott Whitney wrote:
So, my questions are:
a) Is the manual vacuum needed for performance reasons, or is auto-vac
sufficient?
b) How do my settings look?
c) Is there a way that the clogs get cleared via autovac, would a full vac of
just template1/template0 (if that last is possible)