| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Suresh Gupta VG" <suresh(dot)g(at)zensar(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-07 16:46:31 |
| Message-ID: | dcc563d10801070846n1035b974u3a535ae68b8c17e9@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joshua D. Drake | 2008-01-07 17:12:11 | Re: When does VACUUM FULL not clean out all deleted data? |
| Previous Message | Geoffrey | 2008-01-07 15:53:11 | Re: When does VACUUM FULL not clean out all deleted data? |