On Thu, Feb 21, 2013 at 8:52 AM, Fran=E7ois Beausoleil <francois@teksol.inf=
o>
wrote:
> The application is on-line analytics with long reporting queries. 3/hour
I import new data. Once a day, I rollup the raw values into summary tables
and run reports on the summary values. One of the steps in each of the
import and summary scripts is to ANALYZE the tables (not VACUUM, plain
ANALYZE).
If you run ANALYZE manually, and then the data doesn't change much after
that, then there is no reason for the tables to be autoanalyzed.
Cheers,
Jeff