Horton

Re: vacuum locking

scott.marlowe <scott.marlowe@ihs.com>

View thread View on postgr.es
From: "scott.marlowe" <scott.marlowe@ihs.com>
To: Rob Nagler <nagler@bivio.biz>
Cc: <pgsql-performance@postgresql.org>
Date: 2003-10-30T17:55:32Z
Lists: pgsql-performance 
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.