Обсуждение: postgrses database problem
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@csc.com
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
On Mon, 2006-09-25 at 10:41, Srinivas Lakshmi Sistla wrote: > 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. You probably just need a ; character vacuum analyze; or you can enter it on the second line: vacuum analyze ; and it'll still work.