My question is about the default isolation level: "read committed". As I understand, during a read committed transaction, when we update a record, the system puts a lock on that record, so other transactions would wait. Is this correct?
Other: and there's a limit in the config file for the maximum number of locks in a transaction:
What happens when that limit is reached? I made a test and nothing happened. Does the system exchange the row-level locks for a full-table lock?