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.