From: | Vadim Mikheev <vadim(at)krs(dot)ru> |
---|---|
To: | hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] proposals for LLL, part 2 (locking) |
Date: | 1998-07-31 02:46:30 |
Message-ID: | 35C13006.35F3B822@krs.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> But I would like to add two internal lock modes due to VACUUM.
>
> 6. AccessShareLock - acquired by each DML statement
> (INSERT, UPDATE, DELETE, SELECT)
> for the duration of statement.
>
> 7. AccessExclusiveLock - acquired by VACUUM
>
> : we can't vacuum a relation scanned by some other backend...
> (BTW, having these ones we get rid of pg_vlock file...)
On the other hand, we could use ObjExclusiveLock for vacuum -
vacuuming relations opened by running transaction is not
much usefull thing for now...
>
> And now yet two another locks for DDL statements
> (DROP/ALTER) for tables and indices only.
>
> 8. ObjShareLock - acquired by heap/index open for the duration
> of transaction.
>
> 9. ObjExclusiveLock - acquired by DROP/ALTER.
Vadim
From | Date | Subject | |
---|---|---|---|
Next Message | Zoltran | 1998-07-31 04:13:54 | [HACKERS] unsubscribe |
Previous Message | Thomas G. Lockhart | 1998-07-31 02:44:56 | Re: [INTERFACES] psqlodbc |