On Thu, 30 Oct 2003, Rob Nagler wrote:

> scott.marlowe writes:
> > t2 was 'vacuum full'ed and analyzed, right?  Just guessing.
> Fresh import.  I've been told this includes a ANALYZE.

You should probably run analyze by hand just to be sure.  If the planner 
is using an index scan on a table with 20 rows, then it's likely it has 
the default statistics for the table, not real ones.

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?


Reply via email to