Re: Query Speed!!!

vacuum full is supported in 7.2.x, not any prior release.

----- Original Message -----
From: "Thirumoorthy Bhuvneswari" <tbhuvneswari(at)yahoo(dot)com>
To: "Chris Albertson" <chrisalbertson90278(at)yahoo(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Friday, July 12, 2002 10:54 AM
Subject: Re: [GENERAL] Query Speed!!!

> hi Chris,
> Thanks for your idea. But, if I give the command
> 'VACUUM FULL ANALYZE', it says a parsing error.
> Actually, I use to give
>
> 'vacuumdb databasename' from outside the psql prompt
> weekly. Whether it is 'VACUUM FULL ANALYZE' or I use
> to give 'VACUUM ANALYZE tablename' it is the one.
> Please let me know. In 'man vacuum' it just says
> 'VACUUM VERBOSE ANALYZE' and not 'VACUUM FULL
> ANALYZE'. Please
> forgive if I am wrong somewhere. thanks.
>
> regards,
> bhuvana.
>
>
> --- Chris Albertson <chrisalbertson90278(at)yahoo(dot)com>
> wrote:
> >
> > --- Thirumoorthy Bhuvneswari
> > <tbhuvneswari(at)yahoo(dot)com> wrote:
> > > <SNIP>
> >
> > > ....Also, what is 'VACUUM FULL ANALYZE'.
> >
> > THat's it. If you don't know that you must not have
> > done it. Do it and things will speed up. Run it as
> > a nightly cron job and it will stay fast.
> >
> > See "man vacuum"
> >
> > It is a SQL statment that compacts the tables and
> > populates
> > statics about the table that the querry optimizer an
> > use.
> >
> >
> > =====
> > Chris Albertson
> > Home: 310-376-1029
> > chrisalbertson90278(at)yahoo(dot)com
> > Cell: 310-990-7550
> > Office: 310-336-5189
> > Christopher(dot)J(dot)Albertson(at)aero(dot)org
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Sign up for SBC Yahoo! Dial - First Month Free
> > http://sbc.yahoo.com
>
>
> __________________________________________________
> Do You Yahoo!?
> Sign up for SBC Yahoo! Dial - First Month Free
> http://sbc.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>