From: | "Suresh Gupta VG" <suresh(dot)g(at)zensar(dot)com> |
---|---|
To: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
Cc: | "Peter Koczan" <pjkoczan(at)gmail(dot)com>, <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Need some info on Postgresql |
Date: | 2008-01-08 07:39:36 |
Message-ID: | 3D5445983859B84B92669C0D883EA6FB0BB94E30@ZENMAILHQ1.ind.zensar.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thanks Scott for your reply.
Actually, our application will extract all the data from currency table
and never uses that table later at all. I don't know which process is
locking that table. Pls find the attached file for the list of locks
available on our Pgsql. Our database is restarted recently last 2 days
back. No fruitful result has come.
Pls advice us why it is happening. And our database is taking more than
5 minutes to execute a simple query directly on the database at the peak
timings say (9:00 Am to 11:00 AM).
Pls advice and suggest us what to do.
Regards,
G. V. Suresh Gupta
------------------------------------------------------------------------
---------------------------------------------------------
Innovative Technology Solutions(ITS), Zensar Technologies
Zensar Knowledge Park, Plot#5, MIDC IT Tower,
Kharadi, Off Nagar Road, Pune - 411014
Landline : +91-20-66453471 | +91-9890898688
Email : suresh(dot)g(at)zensar(dot)com | website: www.zensar.com
-----Original Message-----
From: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
Sent: Monday, January 07, 2008 10:17 PM
To: Suresh Gupta VG
Cc: Peter Koczan; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Need some info on Postgresql
On Jan 7, 2008 3:41 AM, Suresh Gupta VG <suresh(dot)g(at)zensar(dot)com> wrote:
>
> Hi Scott,
>
> Thanks for your reply. Pls find the attached file for the output of
the
> command given by you. The reindex problem is coming for the table
> "currency". Pls look into the result and advice me what to do.
Well, looks like something is holding locks on currency. What
processes are using that table and what kind of explicit locks, if
any, are they taking?
DISCLAIMER:
This email may contain confidential or privileged information for the intended recipient(s) and the views expressed in the same are not necessarily the views of Zensar Technologies Ltd. If you are not the intended recipient or have received this e-mail by error, its use is strictly prohibited, please delete the e-mail and notify the sender. Zensar Technologies Ltd. does not accept any liability for virus infected mails.
Attachment | Content-Type | Size |
---|---|---|
localtest_gg | application/octet-stream | 6.3 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2008-01-08 15:25:07 | Re: Need some info on Postgresql |
Previous Message | dr_pompeii | 2008-01-08 04:26:08 | user login: problems in linux |