postgrses database problem

From: Srinivas Lakshmi Sistla <ssistla3(at)csc(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: postgrses database problem
Date: 2006-09-25 15:41:58
Message-ID: OF8D315414.BB155AC8-ON652571F4.0054C4A1-652571F4.00561681@csc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)csc(dot)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.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2006-09-25 16:24:38 Re: best OS and HW for postgreSQL
Previous Message Joshua D. Drake 2006-09-25 15:28:20 Re: best OS and HW for postgreSQL