Re: Minimize row locking for update statement

[irek kordirko]

gaetano giunta Wrote:
-------------------------------------------------------
> This is what I am currently looking at. Enabling
> the lock monitor, I tested the simple query "
> update ezdfsfile set expired=1, mtime=-mtime where
> name_trunk =
> 'var/ezflow_site/cache/content/ezflow_site/1/186-'
> and expired = 1", and I see there are 4 locks
> held:
> - table
> - pk
> - index "ezdfsfile_name_trunk" (record)
> - index "ezdfsfile_name_trunk" (gap before rec)

Could you be more precise ?
What we know is that you run the above query in the session 1.
What was the isolation level in this session 1 ?
In the same time you run the other query in the session 2.
What query exactly did you run ? Was it 'SELECT ... FOR UPDATE' ? Or something else ? And What was the isolation level in the session 2 ?