Row level locks - Mailing list pgsql-hackers

From Paulo Roberto Siqueira
Subject Row level locks
Date
Msg-id NEBBKGEDALIEOOKFKHCLMEBFCDAA.paulo.siqueira@usa.net
Whole thread Raw
List pgsql-hackers
    On the documentation
http://www.postgresql.org/users-lounge/docs/7.0/postgres/mvcc4646.htm what
does mean "...Postgres doesn't remember any information about modified rows
in memory and so has no limit to the number of rows locked without lock
escalation."?
Following you find "However, take into account that SELECT FOR UPDATE will
modify selected rows to mark them and so will results in disk writes." Why
does it result in disk writes?

Paulo Siqueira



pgsql-hackers by date:

Previous
From: Philip Warner
Date:
Subject: RFC - change of behaviour of pg_get_userbyid & pg_get_viewdef?
Next
From: Tom Lane
Date:
Subject: Re: RFC - change of behaviour of pg_get_userbyid & pg_get_viewdef?