On Friday, February 08, 2013 6:06 PM Karolis Pocius wrote:
> I've tried changing autovacuum_analyze_scale_factor as well as setting
> job_batches table to auto analyze every 500 changes (by setting scale
> factor to 0 and threshold to 500), but I still keep running into that
> issue, sometimes minutes after the table was analyzed.
> I checked pg_locks to see if anything had granted=false, but that
>doesn't seem to be the case.
> This issue is occurring on two separate instances 9.0.4 and 9.1.4 - both
> have nearly identical settings, just run on a different hardware.
> Config changes http://pgsql.privatepaste.com/8acfb9d136
> Any ideas what is going wrong here?
I think you can verify in Logs whether analyze is happening as per your expectation.
You can set log_autovacuum_min_duration = 0, so that auto_analyze can be logged everytime it happens.
With Regards,
Amit Kapila.