Re: Wierd Explain

On Tue, Jun 18, 2002 at 12:33:26PM +0530, Varun Kacholia wrote:
> hi ,
> Many ppl have suggested me vaccum analyze .
> But the manuals say me that it is reqd after "major update/deletion".
> I have just 'created' the tables and done fresh insertions.
> is it still required?
> BTW i am using 7.1.3 ... seems it does not support analyze :(.

Fresh inserts would count as "major" since now there are values and before
there wern't :).

Anyway, a vacuum analyze is recommended anything you think the planner is
doing something wrong. Prior to 7.2 you could only do the analyze with a
vacuum, in 7.2 it was separated out

Also, EXPLAIN VERBOSE could be helpful also.

> On Mon, Jun 17, 2002 at 11:17:06PM +0200, Jochem van Dieten wrote:
> > Varun Kacholia wrote:
> > > hi ,
> > > I have just migrated to PostgreSQL...and found the following wierd :
> > >
> > > suryadb=# explain select * from dbwin where id in (select id from wdwin
> > > where word='bacd');
> > > NOTICE: QUERY PLAN:
> > > Seq Scan on dbwin (cost=0.00..8158.20 rows=1000 width=76)
> >
> > 1000 rows should trigger the obvious question: did I run vacuum analyze?
> >
> > Jochem

--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.