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/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
