David Fetter wrote:
> On Tue, Sep 16, 2008 at 08:59:08PM -0400, Alvaro Herrera wrote:
>> Simon Riggs wrote:
>>> Disabling autovacuum can have catastrophic effects, since it disables
>>> the ANALYZing of tables.
>>>
>>> Can we have a mode where we disable autoVACUUM yet enable autoANALYZE?
>> You mean something like
>> autovacuum = on / off / analyze ?
>>
>> We can certainly do that, but is there buy-in?
>
> +1
>
> Having autovacuum on during bulk loads can really tank performance,
> but having autoanalyze on is good :)
Isn't autoanalyze a waste of time during a bulk load? Seems better to
run ANALYZE manually at the end.
Adding that option feels natural to me, but it is a rather blunt
instrument. You can already do that with pg_autovacuum, though that
interface isn't very user-friendly. I whole-heartedly support the idea
of controlling autovacuum with storage options, e.g "ALTER TABLE ...
WITH (autoanalyze = on)".
-- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com