On Mon, Nov 8, 2010 at 11:50 AM, Jason Long <jason(at)octgsoftware(dot)com> wrote:
> I currently have Postgres 9.0 install after an upgrade. My database is
> relatively small, but complex. The dump is about 90MB.
>
> Every night when there is no activity I do a full vacuum, a reindex,
One question, why?
> and then dump a nightly backup.
Good idea.
> Is this optimal with regards to performance? autovacuum is set to the
> default.
that depends very much on your answer to the question of why are you
doing it and what you're trying to gain / work around with vacuum full
/ reindex every night.