Jim C. Nasby wrote:
> On Thu, Sep 14, 2006 at 02:36:22PM -0700, Joshua D. Drake wrote:
>> But on a serious note, the problem I run into is exactly the opposite.
>> Someone will turn on autovacuum because they thought it was a good idea
>> and for their work load, it isn't. So instead of creating new and
>> interesting ways to allow their database to be more efficient, I am
>> dealing with snafu's created by my own community.
>
> Then we should change autovacuum so that it stays out of the way when
> tables are being vacuumed frequently enough via an external means.
ALTER TABLE foo DISABLE autovacuum? :)
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL
solutionssince 1997 http://www.commandprompt.com/