Mike G wrote:
> Try reading through the pgsql-performance mailing list. Generally the database needs to be vacuumed and analyzed to
updatethe stats usually for the planner to make the correct choices.
Of course, I do VACUUM FULL ANALYZE some times, VACUUM ANALYZE
periodicaly.
But I don't change "traf_raw" some hours, and imagine that ANALYZE may
be enough for this examle.
>>cnupm=> ANALYZE traf_raw;
>>ANALYZE
--
engineer