Pavel Rotek escribió: > 2008/3/7, Bill Moran <wmoran@xxxxxxxxxxxxxxxxxxxxxxx>: > > 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
