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. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
