| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | François Beausoleil <francois(at)teksol(dot)info> |
| Cc: | Forums postgresql <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Determining last auto vacuum / analyze |
| Date: | 2013-02-21 17:39:26 |
| Message-ID: | CAMkU=1wxX6++g-AiZip8o9ynPo0PPa=kOC2mXkDm2iCvK-kPaA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Feb 21, 2013 at 8:52 AM, François Beausoleil <francois(at)teksol(dot)info>
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | James B. Byrne | 2013-02-21 17:48:16 | Re: Need help extripating plpgsql |
| Previous Message | bricklen | 2013-02-21 17:38:55 | View to show privileges on views/tables/sequences/foreign tables |