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