| From: | Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx> |
|---|---|
| To: | gerry(dot)smit(at)lombard(dot)ca |
| Cc: | ghaverla(at)freenet(dot)edmonton(dot)ab(dot)ca, pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Answering my own question |
| Date: | 2002-05-15 18:18:28 |
| Message-ID: | m3hel9gtqj.fsf@dep4.fciencias.unam.mx |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
gerry(dot)smit(at)lombard(dot)ca writes:
> Now THAT's REALLY fascinating. We upgraded from 6.5 to 7.1 about
> 4-5 months ago , and only got this problem after that. I leave
> "ANALYZE" out of VACUUM due to the large volume of (I though
> needless) output that gets piped to my cron_log.
>
> Does anyone have a feal for how "necessary" VACUUM ANALYZE is over
> "VACUUM" ??
The analyze part records statistical information about your
data. Without it the planner doesn't have information to decide a
better plan.
BTW if you are still in 7.1 you should upgrade. 7.2 is smarter about
the statistical information it records and is able to make better
decisions.
Regards,
Manuel.
ps. yes: mx -> México
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Francisco Reyes | 2002-05-15 19:29:00 | Re: Answering my own question |
| Previous Message | gerry.smit | 2002-05-15 17:56:04 | Re: Answering my own question |