vacuum full is supported in 7.2.x, not any prior release.
----- Original Message -----
From: "Thirumoorthy Bhuvneswari" <tbhuvneswari@yahoo.com>
To: "Chris Albertson" <chrisalbertson90278@yahoo.com>
Cc: <pgsql-general@postgresql.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@yahoo.com>
> wrote:
> >
> > --- Thirumoorthy Bhuvneswari
> > <tbhuvneswari@yahoo.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@yahoo.com
> > Cell: 310-990-7550
> > Office: 310-336-5189
> > Christopher.J.Albertson@aero.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@postgresql.org so that your
> message can get through to the mailing list cleanly
>