Re: vacuum locking - Mailing list pgsql-performance

From scott.marlowe
Subject Re: vacuum locking
Date
Msg-id Pine.LNX.4.33.0310301054360.23412-100000@css120.ihs.com
Whole thread Raw
In response to Re: vacuum locking  (Rob Nagler <nagler@bivio.biz>)
List 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.


pgsql-performance by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: vacuum locking
Next
From: Greg Stark
Date:
Subject: Re: Query puts 7.3.4 on endless loop but 7.4beta5 is fine.