FW: Shared versus Exclusive Locks

A little bit of silly information - for those interested (which I had to look up !) FROM THE MANUAL: - In shared mode, the database server places one shared lock on the table, which informs other users that no updates can be performed. In addition, the database server adds locks for every row updated, deleted, or inserted. - In exclusive mode, the database server places only one exclusive lock on the table, no matter how many rows it updates. If you update most of the rows in the table, place an exclusive lock on the table. Dirk Moolman Database and Unix Administrator MXGROUP I feel like I'm diagonally parked in a parallel universe