From: Arjen van der Meijden <acmmailing@vulcanus.its.tudelft.nl>
To: 'Jeremiah Jahn' <jeremiah@cs.earlham.edu>
To: 'Hannu Krosing' <hannu@tm.ee>
Cc: 'postgres performance' <pgsql-performance@postgresql.org>
Subject: Re: cross table indexes or something?
Date: Mon, 1 Dec 2003 17:24:43 +0100
Message-ID: <002901c3b827$a48aeff0$3ac15e91@acm> (raw)
In-Reply-To: <1070288942.22346.27.camel@bluejay.goodinassociates.com>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: acmmailing@vulcanus.its.tudelft.nl, jeremiah@cs.earlham.edu, hannu@tm.ee
Subject: Re: cross table indexes or something?
In-Reply-To: <002901c3b827$a48aeff0$3ac15e91@acm>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox