lionel duboeuf wrote: > Kevin Grittner a écrit : >> I just reread your original email, and I'm not sure I understand >> what you meant regarding VACUUM ANALYZE. If you run that right >> beforehand, do you still get the slow plan for user 10? > I confirm by executing manual "VACUUM ANALYZE" that the problem is > solved. But what i don't understand is that i would expect > autovacuum to do the job. I think this is the crux of the issue. Boosting the default_statistics_target or the statistics target for specific columns might help, reducing autovacuum_analyze_scale_factor might help, but I can't help wondering whether you inserted a large number of rows for user 10 and then ran the query to select user 10 before autovacuum had time to complete. Does that seem possible?
-Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance