Confussion with table-lock levels and isolation levels
От | Gabriel Fernandez |
---|---|
Тема | Confussion with table-lock levels and isolation levels |
Дата | |
Msg-id | 387D94F8.9CB6F223@unica.edu обсуждение исходный текст |
Ответы |
Re: [GENERAL] Confussion with table-lock levels and isolation levels
Re: [GENERAL] confusion with vacuum commnad. |
Список | pgsql-general |
Hi fellows ! I would only want to ask some questions concerning table-locking levels and isolation levels: * First of all: should I assume that AccessXXXXXXX modes imply locking the complete table and RowXXXX imply locking only the rows which have been accessed ? Will then the conflicts be solved according the hierarchy between modes ? * Second: - What does exactly mean that a mode 'CONFLICTS' with another ? - Does it mean that another concurrent transactions having these modes will have to wait until the first transaction have finished (commit or roll back) ? - Can we determine (when accessing a row in a table) wether we will have a conflict or not according to the criteria explained in the previous question (Access-> complete table, Row -> rows accessed) ? *Third: If all the previous assumptions are true: - When there is a conflict, will the only consequence be that all concurrent transactions will be processed in a FIFO serie and not in parallel ? - What about all the others concurrent transactions which haven't conflicted ? How can you avoid falling into contradiction with the isolation level (and assure the protection against non-repeteable reads or phantom reads ? - I feel those two levels (transactions and isolation levels) are two layers so the transactions will be processed according to a FIFO serie when exist any problem concerning the isolation level or the table-locking. Is this a good way to describe the way PostgreSQL manages the things ? Thank you very much for your help. By the way, is the first time i'm subscribed to a mailing list so if I do anything inappropiate or strange please tell me. Best regards Gabi :-)
В списке pgsql-general по дате отправления: