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.
--
Thank you for your time,
Jason Long
CEO and Chief Software Engineer
BS Physics, MS Chemical Engineering
http://www.octgsoftware.com
HJBug Founder and President
http://www.hjbug.com