Re: ANALYZE locks pg_listener in EXCLUSIVE for long

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
[~] root(at)beast>ps ax | grep 56399;
56399 ?? D 0:03.41 postmaster: pgsql mail 127.0.0.1 ANALYZE (postgres)
[~] root(at)beast>kill -TERM 56399
[~] root(at)beast>ps ax | grep 56399;
[~] root(at)beast>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 |/