On Mon, Nov 8, 2010 at 11:50 AM, Jason Long <jason@xxxxxxxxxxxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general