On Mon, May 21, 2007 at 03:50:27PM -0400, Merlin Moncure wrote:
> I work on a system about like you describe....400tps constant....24/7.
> Major challenges are routine maintenance and locking. Autovacuum is
> your friend but you will need to schedule a full vaccum once in a
> while because of tps wraparound. If you allow AV to do this, none of
> your other tables get vacuumed until it completes....heh!
BTW, that's changed in either 8.2 or 8.3; the change is that freeze
information is now tracked on a per-table basis instead of per-database.
So autovacuum isn't forced into freezing everything in the database at
once.
--
Jim Nasby decibel(at)decibel(dot)org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)