Pavel Rotek escribió:
> 2008/3/7, Bill Moran <wmoran@collaborativefusion.com>:
> > Don't do vacuum full on this table. Do frequent vacuums. The table will
> > bloat some, but not 10x the required size, once you find a reasonable
> > frequency for vacuums. You might find it practical to manually vacuum
> > this table from your application after insert and update operations.
>
> I perform autovacuum daily.
Sorry, this sentence makes no sense. Do you mean that you set
autovacuum_naptime=1 day? If so, that's a bad idea -- you should let
autovacuum run far more frequently.
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
