Re: Wierd Explain

Hi,

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?
AFAIK is not.

>   BTW i am using 7.1.3 ... seems it does not support analyze :(.
There were great feature improvements regarding vacuum on 7.2.x

greetings.
-tb

> 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) 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html

-- 
Thomas Beutin                             tb@laokoon.IN-Berlin.DE
Beam me up, Scotty. There is no intelligent live down in Redmond.