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.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- 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. --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------