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.