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
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 poss
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 auto
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 aut
