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)