Bruce Momjian <[EMAIL PROTECTED]> writes: > I just noticed that if I do BEGIN;CREATE TABLE..., and then start VACUUM > of the database in another psql session, the VACUUM hangs until the > transaction completes. Is this expected? Sure. You have a write lock on pg_class ... not to mention a few other system tables, but that's the one this trace shows VACUUM is waiting for exclusive lock on: > #5 0x811b67a in LockRelation (relation=0x826b01c, lockmode=7) at lmgr.c:141 > #6 0x80735c5 in heap_open (relationId=1259, lockmode=7) at heapam.c:596 regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster