Re: Wierd Explain

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 :(.
thanks
  
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
> 

-- 
------
Varun
Do not kill time ... else time will kill you


----- End forwarded message -----

-- 
------
Varun
REALITY.SYS corrupted: Reboot universe? (Y/N/Q)