postgrses database problem

[Srinivas Lakshmi Sistla <ssistla3@xxxxxxx>]

Guys,

I am new to Postgresql. We have a database
on Linux box and users complaining about queries running very slow. I tried
to run vacuum this moring but it doesn't seem to do anything. I logged
on to database by typing psql bhpbprod (bhpbprod is database name)
and that gave me the prompt  bhpbprod=# . There i typed in
vacuum analyze and i got the same prompt again. so i assume it didn't work.


So could some one please help how to
go about this problem. I really appreciate all your positive replys. Thanks.



Regards,
Srinivas Sistla
Managed Computing Services
Computer Sciences Corporation India Private Limited,
Ph: 91 -40 39824100 Extn 4329
India        - +91 -40  39824100   Extn 4329
US           - +1     302 781 1020  
Extn 4329
UK   -          +44  08706000180  
  Extn 4329
Denmark -  +45  70100087         Extn 4329
E-mail : ssistla3@xxxxxxx


--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit written
agreement or government initiative expressly permitting the use of e-mail
for such purpose.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------