Re: More Autovacuum questions

Alvaro Herrera wrote:
> Matthew T. O'Connor escribió:
>
>> As Alvaro already said this is a case where autovacuum still isn't
>> great.
>>
>
> While I have your attention ;-) do you have any ideas on how to improve
> this?  I don't see anything that looks like a solution for this case.

No good ideas, but a few random thoughts.
1) Can we make vacuum not block analyze?  That way we can continue to
analyze a table while it's being vacuumed.
1b) If not, can we make auto-analyze bump auto-vacuum?
2) Maintenance windows.  They wouldn't solve this problem, but they
might mitigate it some.