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. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
