On Monday 8. November 2010 20.06.13 Jason Long 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, and
> then dump a nightly backup.
>
> Is this optimal with regards to performance? autovacuum is set to the
> default.
I've got a database about the same size order (65 MB on disk, 5 MB dump.tgz)
and I never bother with neither full vacuum nor reindexing. I run the default
autovacuum, and if the db becomes bloated for some reason, I just do a
dump/drop/reload cycle. It's done in a few seconds.
regards,
Leif B. Kristensen
http://solumslekt.org/