Re: [HACKERS] ANALYZE locks pg_listener in EXCLUSIVE for long

Philip Warner Sun, 02 May 2004 22:15:15 -0700

At 02:54 PM 3/05/2004, Tom Lane wrote:

I don't believe any of this.

mail=# select * from pg_locks where not granted; relation | database | transaction | pid | mode | granted ----------+----------+-------------+-------+---------------------+--------- 16414 | 17149 | | 7847 | AccessExclusiveLock | f 16414 | 17149 | | 51015 | AccessExclusiveLock | f 16414 | 17149 | | 51149 | AccessExclusiveLock | f 16414 | 17149 | | 51024 | AccessExclusiveLock | f 16414 | 17149 | | 48838 | AccessExclusiveLock | f 16414 | 17149 | | 57670 | AccessExclusiveLock | f 16414 | 17149 | | 54535 | AccessExclusiveLock | f 16414 | 17149 | | 57756 | AccessExclusiveLock | f 16414 | 17149 | | 25894 | AccessExclusiveLock | f 16414 | 17149 | | 55813 | AccessExclusiveLock | f 16414 | 17149 | | 18181 | AccessExclusiveLock | f 16414 | 17149 | | 57846 | AccessExclusiveLock | f 16414 | 17149 | | 44827 | AccessExclusiveLock | f 16414 | 17149 | | 52352 | AccessExclusiveLock | f 16414 | 17149 | | 51239 | AccessExclusiveLock | f 16414 | 17149 | | 14610 | AccessExclusiveLock | f 16414 | 17149 | | 88549 | AccessExclusiveLock | f 16414 | 17149 | | 36939 | AccessExclusiveLock | f 16414 | 17149 | | 57120 | AccessExclusiveLock | f 16414 | 17149 | | 89107 | AccessExclusiveLock | f 16414 | 17149 | | 48915 | AccessExclusiveLock | f 16414 | 17149 | | 74102 | AccessExclusiveLock | f 16414 | 17149 | | 51029 | AccessExclusiveLock | f 16414 | 17149 | | 51100 | AccessExclusiveLock | f 16414 | 17149 | | 57865 | AccessExclusiveLock | f 16414 | 17149 | | 45777 | AccessExclusiveLock | f 16414 | 17149 | | 22288 | AccessExclusiveLock | f 16414 | 17149 | | 52006 | AccessExclusiveLock | f 16414 | 17149 | | 44829 | AccessExclusiveLock | f 16414 | 17149 | | 49073 | AccessExclusiveLock | f 16414 | 17149 | | 52827 | AccessExclusiveLock | f 16414 | 17149 | | 21003 | AccessExclusiveLock | f 16414 | 17149 | | 50204 | AccessExclusiveLock | f mail=# select * from pg_class where oid=16414; relname | relnamespace | reltype | relowner | relam | relfilenode | relpages | reltuples | reltoastrelid | reltoastidxid | relh asindex | relisshared | relkind | relnatts | relchecks | reltriggers | relukeys | relfkeys | relrefs | relhasoids | relhaspkey | rel hasrules | relhassubclass | relacl -------------+--------------+---------+----------+-------+-------------+----------+-----------+---------------+---------------+----- --------+-------------+---------+----------+-----------+-------------+----------+----------+---------+------------+------------+---- ---------+----------------+------------ pg_listener | 11 | 16415 | 1 | 0 | 16414 | 0 | 0 | 0 | 0 | f | f | r | 3 | 0 | 0 | 0 | 0 | 0 | f | f | f | f | {=r/pgsql} (1 row)

mail=# select * from pg_locks where granted and relation=16414;
 relation | database | transaction |  pid  |      mode       | granted
----------+----------+-------------+-------+-----------------+---------
    16414 |    17149 |             | 56399 | AccessShareLock | t
(1 row)

mail=# \q
[~] [EMAIL PROTECTED]>ps ax | grep 56399;
56399  ??  D      0:03.41 postmaster: pgsql mail 127.0.0.1 ANALYZE (postgres)
[~] [EMAIL PROTECTED]>kill -TERM 56399
[~] [EMAIL PROTECTED]>ps ax | grep 56399;
[~] [EMAIL PROTECTED]>psql -p5443 -U pgsql mail
Welcome to psql 7.3.3, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit

mail=# select * from pg_locks where granted and relation=16414;
 relation | database | transaction | pid | mode | granted
----------+----------+-------------+-----+------+---------
(0 rows)

mail=# select * from pg_locks where not granted;
 relation | database | transaction |  pid  |   mode    | granted
----------+----------+-------------+-------+-----------+---------
          |          |    65738548 | 72279 | ShareLock | f
          |          |    65738548 | 40479 | ShareLock | f
          |          |    65738548 | 46830 | ShareLock | f
          |          |    65738478 | 20762 | ShareLock | f
(4 rows)

mail=# select * from pg_locks where not granted;
 relation | database | transaction | pid | mode | granted
----------+----------+-------------+-----+------+---------
(0 rows)

---------------------------------------------------------------- Philip Warner | __---_____ Albatross Consulting Pty. Ltd. |----/ - \ (A.B.N. 75 008 659 498) | /(@) ______---_ Tel: (+61) 0500 83 82 81 | _________ \ Fax: (+61) 03 5330 3172 | ___________ | Http://www.rhyme.com.au | / \| | --________-- PGP key available upon request, | / and from pgp.mit.edu:11371 |/


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
     subscribe-nomail command to [EMAIL PROTECTED] so that your
     message can get through to the mailing list cleanly

Re: [HACKERS] ANALYZE locks pg_listener in EXCLUSIVE for long

Reply via email to