$ ps -ef | grep postgres amul 46779 1 0 08:17 ? 00:00:00 /home/amul/work/source/PG/tmp_install/tmp/RM5444/inst/bin/postgres -F -c listen_addresses= -k /tmp/pg_upgrade_check-DpL1Pk amul 46783 46779 0 08:17 ? 00:00:00 postgres: checkpointer amul 46784 46779 0 08:17 ? 00:00:00 postgres: background writer amul 46787 46779 0 08:17 ? 00:00:00 postgres: walwriter amul 46789 46779 0 08:17 ? 00:00:00 postgres: stats collector amul 50246 46779 0 08:17 ? 00:00:00 postgres: amul regression [local] INSERT amul 54260 46779 0 08:18 ? 00:00:00 postgres: autovacuum worker regression amul 59474 46779 0 08:18 ? 00:00:00 postgres: autovacuum worker postgres amul 62444 46779 0 08:19 ? 00:00:00 postgres: autovacuum worker regression ============================== bt: (gdb) bt #0 0x00007ff852901afb in do_futex_wait.constprop.1 () from /lib64/libpthread.so.0 #1 0x00007ff852901b8f in __new_sem_wait_slow.constprop.0 () from /lib64/libpthread.so.0 #2 0x00007ff852901c2b in sem_wait@@GLIBC_2.2.5 () from /lib64/libpthread.so.0 #3 0x000000000079f6e2 in PGSemaphoreLock () at pg_sema.c:327 #4 0x000000000082a794 in LWLockAcquire () at lwlock.c:1318 #5 0x00000000005c2110 in AdvanceXLInsertBuffer (upto=182534144, opportunistic=false) at xlog.c:2203 #6 0x00000000005c2273 in GetXLogBuffer () at xlog.c:1982 #7 0x00000000005c2b44 in CopyXLogRecordToWAL (EndPos=182534176, StartPos=182534024, rdata=0x293ba50, isLogSwitch=false, write_len=124) at xlog.c:1581 #8 XLogInsertRecord () at xlog.c:1146 #9 0x00000000005ccadf in XLogInsert () at xloginsert.c:866 #10 0x0000000000557ae1 in heap_insert (relation=relation@entry=0x7ff853308c08, tup=tup@entry=0x2a648c8, cid=cid@entry=44, options=options@entry=0, bistate=bistate @entry=0x0) at heapam.c:2211 #11 0x0000000000565596 in heapam_tuple_insert (relation=0x7ff853308c08, slot=0x2a46600, cid=44, options=0, bistate=0x0) at heapam_handler.c:252 #12 0x00000000006e62e5 in table_tuple_insert (bistate=0x0, options=0, cid=, slot=0x2a46600, rel=0x7ff853308c08) at ../../../src/include/access/tabl eam.h:1374 #13 ExecInsert () at nodeModifyTable.c:934 #14 0x00000000006e6ddc in ExecModifyTable () at nodeModifyTable.c:2561 #15 0x00000000006b7ff3 in ExecProcNode (node=0x2a2fa68) at ../../../src/include/executor/executor.h:257 #16 ExecutePlan (execute_once=, dest=0x2a363f0, direction=, numberTuples=0, sendTuples=, operation=CMD_INSERT, use_pa rallel_mode=, planstate=0x2a2fa68, estate=0x2a2f7e0) at execMain.c:1551 #17 standard_ExecutorRun () at execMain.c:361 #18 0x000000000083e540 in ProcessQuery (plan=, sourceText=0x29060c0 "insert into bmscantest select r, 'f", 'o' , "' FROM generate _series(1,100000) r;", params=0x0, queryEnv=0x0, dest=0x2a363f0, qc=0x7fff6ae822d0) at pquery.c:160 #19 0x000000000083f05a in PortalRunMulti (portal=portal@entry=0x2969d10, isTopLevel=isTopLevel@entry=true, setHoldSnapshot=setHoldSnapshot@entry=false, dest=dest@ entry=0x2a363f0, altdest=altdest@entry=0x2a363f0, qc=qc@entry=0x7fff6ae822d0) at pquery.c:1266 #20 0x000000000083f557 in PortalRun () at pquery.c:786 #21 0x000000000083b4e5 in exec_simple_query () at postgres.c:1214 #22 0x000000000083cab9 in PostgresMain () at postgres.c:4497 #23 0x00000000007b239a in BackendRun (port=, port=) at postmaster.c:4560 #24 BackendStartup (port=) at postmaster.c:4288 #25 ServerLoop () at postmaster.c:1801 #26 0x00000000007b336b in PostmasterMain () at postmaster.c:1473 ============================== regression=# select * from pg_locks; locktype | database | relation | page | tuple | virtualxid | transactionid | classid | objid | objsubid | virtualtransaction | pid | mode | granted | fastpath | waitstart ---------------+----------+----------+------+-------+------------+---------------+---------+-------+----------+--------------------+-------+--------------------------+---------+----------+----------- relation | 16387 | 12073 | | | | | | | | 7/2193 | 65034 | AccessShareLock | t | t | virtualxid | | | | | 7/2193 | | | | | 7/2193 | 65034 | ExclusiveLock | t | t | relation | 16387 | 19473 | | | | | | | | 3/4997 | 50246 | AccessShareLock | t | t | relation | 16387 | 19462 | | | | | | | | 3/4997 | 50246 | AccessShareLock | t | t | relation | 16387 | 19447 | | | | | | | | 3/4997 | 50246 | AccessShareLock | t | t | relation | 16387 | 17564 | | | | | | | | 3/4997 | 50246 | AccessShareLock | t | t | relation | 16387 | 19402 | | | | | | | | 3/4997 | 50246 | AccessShareLock | t | t | relation | 16387 | 19388 | | | | | | | | 3/4997 | 50246 | AccessShareLock | t | t | relation | 16387 | 19375 | | | | | | | | 3/4997 | 50246 | AccessShareLock | t | t | relation | 16387 | 19341 | | | | | | | | 3/4997 | 50246 | AccessShareLock | t | t | relation | 16387 | 17561 | | | | | | | | 3/4997 | 50246 | AccessShareLock | t | t | relation | 16387 | 17640 | | | | | | | | 3/4997 | 50246 | AccessShareLock | t | t | relation | 16387 | 17637 | | | | | | | | 3/4997 | 50246 | AccessShareLock | t | t | relation | 16387 | 17632 | | | | | | | | 3/4997 | 50246 | AccessShareLock | t | t | relation | 16387 | 17629 | | | | | | | | 3/4997 | 50246 | AccessShareLock | t | t | relation | 16387 | 17624 | | | | | | | | 3/4997 | 50246 | AccessShareLock | t | t | relation | 16387 | 17621 | | | | | | | | 3/4997 | 50246 | AccessShareLock | t | t | virtualxid | | | | | 3/4997 | | | | | 3/4997 | 50246 | ExclusiveLock | t | t | relation | 16387 | 2696 | | | | | | | | 6/1653 | 62444 | RowExclusiveLock | t | t | relation | 16387 | 2619 | | | | | | | | 6/1653 | 62444 | RowExclusiveLock | t | t | relation | 16387 | 16984 | | | | | | | | 6/1653 | 62444 | AccessShareLock | t | t | virtualxid | | | | | 6/1653 | | | | | 6/1653 | 62444 | ExclusiveLock | t | t | virtualxid | | | | | 5/2721 | | | | | 5/2721 | 59474 | ExclusiveLock | t | t | relation | 16387 | 2704 | | | | | | | | 4/1627 | 54260 | RowExclusiveLock | t | t | relation | 16387 | 2703 | | | | | | | | 4/1627 | 54260 | RowExclusiveLock | t | t | virtualxid | | | | | 4/1627 | | | | | 4/1627 | 54260 | ExclusiveLock | t | t | relation | 16387 | 16709 | | | | | | | | 6/1653 | 62444 | ShareUpdateExclusiveLock | t | f | relation | 0 | 2677 | | | | | | | | 5/2721 | 59474 | RowExclusiveLock | t | f | object | 16387 | | | | | | 1247 | 28328 | 0 | 3/4997 | 50246 | AccessExclusiveLock | t | f | object | 16387 | | | | | | 1247 | 28327 | 0 | 3/4997 | 50246 | AccessExclusiveLock | t | f | relation | 16387 | 27185 | | | | | | | | 3/4997 | 50246 | ShareUpdateExclusiveLock | t | f | relation | 16387 | 27194 | | | | | | | | 3/4997 | 50246 | ShareUpdateExclusiveLock | t | f | relation | 16387 | 17629 | | | | | | | | 3/4997 | 50246 | ShareUpdateExclusiveLock | t | f | relation | 16387 | 17564 | | | | | | | | 3/4997 | 50246 | ShareUpdateExclusiveLock | t | f | transactionid | | | | | | 9955 | | | | 6/1653 | 62444 | ExclusiveLock | t | f | object | 16387 | | | | | | 1247 | 28322 | 0 | 3/4997 | 50246 | AccessExclusiveLock | t | f | relation | 16387 | 17561 | | | | | | | | 3/4997 | 50246 | ShareUpdateExclusiveLock | t | f | relation | 16387 | 17627 | | | | | | | | 3/4997 | 50246 | ShareUpdateExclusiveLock | t | f | relation | 16387 | 17637 | | | | | | | | 3/4997 | 50246 | ShareUpdateExclusiveLock | t | f | relation | 16387 | 28333 | | | | | | | | 3/4997 | 50246 | AccessExclusiveLock | t | f | relation | 16387 | 28332 | | | | | | | | 3/4997 | 50246 | ShareLock | t | f | relation | 16387 | 17635 | | | | | | | | 3/4997 | 50246 | ShareUpdateExclusiveLock | t | f | relation | 16387 | 17643 | | | | | | | | 3/4997 | 50246 | ShareUpdateExclusiveLock | t | f | relation | 16387 | 17632 | | | | | | | | 3/4997 | 50246 | ShareUpdateExclusiveLock | t | f | relation | 16387 | 28323 | | | | | | | | 3/4997 | 50246 | AccessShareLock | t | f | relation | 16387 | 28323 | | | | | | | | 3/4997 | 50246 | AccessExclusiveLock | t | f | object | 16387 | | | | | | 1247 | 28321 | 0 | 3/4997 | 50246 | AccessExclusiveLock | t | f | object | 16387 | | | | | | 1247 | 28325 | 0 | 3/4997 | 50246 | AccessExclusiveLock | t | f | relation | 16387 | 17624 | | | | | | | | 3/4997 | 50246 | ShareUpdateExclusiveLock | t | f | relation | 16387 | 28326 | | | | | | | | 3/4997 | 50246 | AccessShareLock | t | f | relation | 16387 | 28326 | | | | | | | | 3/4997 | 50246 | AccessExclusiveLock | t | f | relation | 16387 | 1247 | | | | | | | | 4/1627 | 54260 | ShareUpdateExclusiveLock | t | f | transactionid | | | | | | 9954 | | | | 3/4997 | 50246 | ExclusiveLock | t | f | relation | 0 | 2676 | | | | | | | | 5/2721 | 59474 | RowExclusiveLock | t | f | relation | 16387 | 17621 | | | | | | | | 3/4997 | 50246 | ShareUpdateExclusiveLock | t | f | relation | 16387 | 28329 | | | | | | | | 3/4997 | 50246 | RowExclusiveLock | t | f | relation | 16387 | 28329 | | | | | | | | 3/4997 | 50246 | AccessExclusiveLock | t | f | object | 16387 | | | | | | 2615 | 2200 | 0 | 3/4997 | 50246 | AccessShareLock | t | f | relation | 16387 | 27190 | | | | | | | | 3/4997 | 50246 | ShareUpdateExclusiveLock | t | f | relation | 0 | 1260 | | | | | | | | 5/2721 | 59474 | ShareUpdateExclusiveLock | t | f | object | 16387 | | | | | | 1247 | 28324 | 0 | 3/4997 | 50246 | AccessExclusiveLock | t | f | relation | 16387 | 17640 | | | | | | | | 3/4997 | 50246 | ShareUpdateExclusiveLock | t | f | relation | 16387 | 28320 | | | | | | | | 3/4997 | 50246 | AccessShareLock | t | f | relation | 16387 | 28320 | | | | | | | | 3/4997 | 50246 | AccessExclusiveLock | t | f | (64 rows)