Re: 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