Atri Sharma <atri.j...@gmail.com> writes: > On a different note, shouldn't we have a time out for a content lock > in buffer cache?
No; the overhead of setting up and canceling such a timeout would greatly outweigh any possible benefit. Generally speaking, LWLocks are not meant to be used in situations where the lock hold time might be long enough to justify worrying about timeouts. If you need that kind of behavior, use a heavyweight lock. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers