On Thu, Feb 21, 2013 at 8:52 AM, François Beausoleil <francois@xxxxxxxxxxx> 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
