vacuum

From: Culley Harrelson <culley(at)shapebooks(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: vacuum
Date: 2001-11-24 16:57:03
Message-ID: 5.1.0.14.2.20011124085146.00a87ec0@shapebooks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

couple of questions about vacuum:

If you run vacuum nightly does that mean you do not need to run vacuum
analyze? is analyze implicit?

I've set up a job to vacuum my databases nightly but the account running
the job doesn't have super-user permissions and it blows up on all the pg_
tables. Is there any harm in transferring ownership of these tables away
from a super-user?

culley

Browse pgsql-general by date

  From Date Subject
Next Message culley 2001-11-24 19:09:48 implicit analyze on vacuum?
Previous Message Francis + Helena Madden 2001-11-24 07:47:55 Problems with createdb in MacOsX.1