Re: Toast space grows

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