Postgres Pro
Downloads
Home   >   mailing lists

Full Vacuum/Reindex vs autovacuum - Mailing list pgsql-general

From Jason Long
Subject Full Vacuum/Reindex vs autovacuum
Date
Msg-id 1289243173.2646.36.camel@localhost.fx60
Whole thread Raw
Responses Re: Full Vacuum/Reindex vs autovacuum  (Leif Biberg Kristensen <leif@solumslekt.org>)
Re: Full Vacuum/Reindex vs autovacuum  (Vick Khera <vivek@khera.org>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: ERROR: Out of memory - when connecting to database
Next
From: Jakub Ouhrabka
Date:
Subject: Re: ERROR: Out of memory - when connecting to database