Re: [HACKERS] toast operations while locking a buffer

Hiroshi Inoue <[EMAIL PROTECTED]> writes: > I see heap_tuple_toast_attrs() calls in heapam.c. > When they are called from heap_update/delete() > ,a buffer is locked. Hm. Seems like it would be better to do the tuple toasting before we lock the target buffer... regards, t

[HACKERS] toast operations while locking a buffer

Hi all I see heap_tuple_toast_attrs() calls in heapam.c. When they are called from heap_update/delete() ,a buffer is locked. OTOH heap_tuple_toast_attrs() calls heap_open(.., .., RowExclusiveLock). Hmm,try to acquire a RowExclusiveLock while locking a buffer. Is there no problem ? Regards. Hiros