On Wed, Nov 3, 2010 at 10:06 AM, Silvio Brandani <silvio.brand...@tech.sdb.it> wrote: > > Alls, > > we have develop a script to execute the vacuum full on all tables of our
Vacuum full is more of a recovery / offline command and is to be used sparingly, especially before 9.0. > very big database , since it is a 24 x 7 available system we have not a > timeframe to exec the vacuum full. Is there a reason you're avoiding autovacuum and tuning it to keep up? It's usually the better option. > PostgreSQL 8.3.1 on x86_64-redhat-linux-gnu Is there a good reason for avoiding about two years of updates (8.3.latest has a lot of bug fixes.) -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
