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(at)laokoon(dot)IN-Berlin(dot)DE
Beam me up, Scotty. There is no intelligent live down in Redmond.