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)