"Rafael Domiciano" <rafael.domiciano at gmail.com> writes:
> You said that VACUUM FULLs are not an effective method of ongoing
> maintenance. But VACUUM FULL is used by more than 5 years, so VACUUM
> is a culture in the company. The DBA function is new in the company,
> and I have been reading everything I find about Postgres, DB, Slony,
> Maintenance, and so on.

Cultures get addicted to all manner of traditions, but times change,
and sometimes, the nature of technology turns what was once a fine
idea into a very bad one.

"VACUUM FULL" is an example of something that used to be fine and
necessary that is now a Really Terrible tradition to continue.

If you try to continue this tradition, in the context of Slony-I, you
will find your system performance worsening, and find that replication
is not working as it should.

This is not a case where it is quaint and cute to keep to the old
traditions - this is a case where you will cause plenty of unnecessary
pain by trying to ignore five years worth of development effort that
has taken place.

> I would like to know if you could pass me a forum or a list of
> messages on Postgres or maintenance in DB.  If you can, I would be
> very grateful.

Look to the documentation:
   http://www.postgresql.org/docs/8.3/static/maintenance.html
-- 
output = ("cbbrowne" "@" "linuxdatabases.info")
http://cbbrowne.com/info/sgml.html
It isn't that  physicists enjoy physics  more than they enjoy sex, its
that they enjoy sex more when they are thinking of physics.