| From: | Philip Warner <pjw(at)rhyme(dot)com(dot)au> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Meaning of transaction pg_locks? |
| Date: | 2008-11-12 03:08:45 |
| Message-ID: | 491A48BD.9060207@rhyme.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Tom Lane wrote:
> Neither are we, because you left out all the columns that might tell
> that ...
>
The columns are actually blank....it's the other rows I left out with
the row-level locks:
925282231 | 925280527 | | 62814 | RowExclusiveLock | t
925282208 | 925280527 | | 62814 | RowExclusiveLock | t
| | 1192675195 | 62814 | ExclusiveLock | t
925282207 | 925280527 | | 62814 | RowExclusiveLock | t
925282025 | 925280527 | | 62814 | AccessShareLock | t
925282025 | 925280527 | | 62814 | RowExclusiveLock | t
925282206 | 925280527 | | 62814 | RowExclusiveLock | t
925282212 | 925280527 | | 62814 | RowExclusiveLock | t
925282210 | 925280527 | | 62814 | RowExclusiveLock | t
925282209 | 925280527 | | 62814 | RowExclusiveLock | t
925281338 | 925280527 | | 62814 | AccessShareLock | t
925281338 | 925280527 | | 62814 | RowExclusiveLock | t
925282211 | 925280527 | | 62814 | RowExclusiveLock | t
925282213 | 925280527 | | 62814 | RowExclusiveLock | t
So I assume the processes waiting on the TX were waiting for one or more
of those rows.
Now I just need to figure out why the rows were locked for such a long
time (the row level locks are mostly on one table and various indexes of
that table).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2008-11-12 04:06:08 | Re: WIP: Automatic view update rules |
| Previous Message | Tom Lane | 2008-11-12 02:57:06 | Re: Reducing some DDL Locks to ShareLock |