Full Vacuum/Reindex vs autovacuum

From: Jason Long <jason(at)octgsoftware(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Full Vacuum/Reindex vs autovacuum
Date: 2010-11-08 18:50:52
Message-ID: 1289242252.2646.34.camel@localhost.fx60
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2010-11-08 18:52:53 Re: ERROR: Out of memory - when connecting to database
Previous Message akp geek 2010-11-08 18:45:49 need help with Triggers