Herouth Maoz wrote:
> We found out that the table's response depends on the rate of ANALYZE being performed. We have tuned the values in
pg_autovacuumso that we have around one analyze per minute.
>
> What is bothering me is that sometimes the auto vacuum daemon decides to perform a vacuum analyze rather than just
analyze.If it just does a vacuum independent of the analyze, we don't see much impact on performance. But if it does
vacuumanalyze, it means that until vacuum is over, it doesn't do another analyze, and this may take about five minutes,
inwhich our performance under load conditions might deteriorate.
Hmm, this is an use case we never thought about. I don't think there's
any way to coerce autovacuum into doing what you want it to do. I
suggest you turn analyze off for this table (say by setting a very large
scale factor), and analyze it manually through cron or something.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.