Re: Query Speed!!!

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
>