| From: | "Arjen van der Meijden" <acmmailing(at)vulcanus(dot)its(dot)tudelft(dot)nl> |
|---|---|
| To: | "'Jeremiah Jahn'" <jeremiah(at)cs(dot)earlham(dot)edu>, "'Hannu Krosing'" <hannu(at)tm(dot)ee> |
| Cc: | "'postgres performance'" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: cross table indexes or something? |
| Date: | 2003-12-01 16:24:43 |
| Message-ID: | 002901c3b827$a48aeff0$3ac15e91@acm |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
> Jeremiah Jahn wrote:
>
> > Have you run ANALYZE ? Why does DB think that there is only
> one judge
> > with name like SMITH% ?
> I've attached the Analyze below. I have no idea why the db
> thinks there is only 1 judge named simth. Is there some what
> I can inform the DB about this. In actuality, there aren't
> any judges named smith at the moment, but there are 22K
> people named smith.
>
I think you're mistaking the command EXPLAIN ANALYZE for the command
ANALYZE.
Have you actually run the command ANALYZE or perhaps even better if you
haven't vacuumed before: VACUUM FULL ANALYZE
If you have no idea what vacuum is, check the manual. If you've already
run such a VACUUM/ANALYZE-command, then ignore this message :)
Best regards,
Arjen van der Meijden
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roger Ging | 2003-12-01 17:14:48 | Re: Followup - expression (functional) index use in joins |
| Previous Message | Richard Huxton | 2003-12-01 15:59:52 | Re: cross table indexes or something? |