As part of the standby lag investigation, I identified this as a large bottleneck on startup when creating a large number of cursors on a standby. Converting it to a read/write lock (making a few existing users readers, and leaving the rest as writers) yielded a large performance win.